Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

500 SQL missing table, check UX, we should be saying no preview or similar? #44

Open
aurreco-uga opened this issue May 27, 2024 · 0 comments

Comments

@aurreco-uga
Copy link
Member

aurreco-uga commented May 27, 2024

user in toxo db workshop
Referred from: https://clinepidb.org/ce/app/workspace/analyses/EDAUD_azMrS2u0vgR/new/download
wdk_user = User #312088803 - [email protected]

2024-05-27 02:53:38.249 [rid: ][jid:][p:] ERROR ErrorMapper:68 - Caught Exception:
org.gusdb.fgputil.db.runner.SQLRunnerException: Unable to run SQL <WITH
VAR_f805a4bf0c2f356f as (
SELECT ToxoGenoAnim_stable_id FROM vdi_datasets_prod_s.ancestors_zrmfg2p_1_ToxoGenoAnim
),
subset AS (
SELECT distinct VAR_f805a4bf0c2f356f.ToxoGenoAnim_stable_id
FROM VAR_f805a4bf0c2f356f
),
wide_tabular AS (
select rownum as r, wt.*
from (
select ToxoGenoAnim_stable_id,
ea.stable_id
from vdi_datasets_prod_s.attributes_zrmfg2p_1_ToxoGenoAnim ea, vdi_datasets_prod_s.ancestors_zrmfg2p_1_ToxoGenoAnim a
where ea.stable_id in (select * from subset)
and ea.stable_id = a.ToxoGenoAnim_stable_id

) wt
)
select ToxoGenoAnim_stable_id
from wide_tabular
where r > 0 and r <= 1

with args [ ]
at org.gusdb.fgputil.db.runner.SQLRunner.executeSql(SQLRunner.java:442) ~[service.jar:3.0.0]
at org.gusdb.fgputil.db.runner.SQLRunner.executeQuery(SQLRunner.java:353) ~[service.jar:3.0.0]
at org.veupathdb.service.eda.subset.model.db.FilteredResultFactory.produceTabularSubset(FilteredResultFactory.java:235) ~[service.jar:3.0.0]
at org.veupathdb.service.eda.subset.model.db.FilteredResultFactory.produceTabularSubset(FilteredResultFactory.java:89) ~[service.jar:3.0.0]
at org.veupathdb.service.eda.subset.service.StudiesService.lambda$handleTabularRequest$8(StudiesService.java:298) ~[service.jar:3.0.0]
....

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

@aurreco-uga aurreco-uga changed the title 500 SQL missing table 500 SQL missing table, check UX, we should be saying no preview or similar? May 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant