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
user in toxo db workshop Referred from: https://clinepidb.org/ce/app/workspace/analyses/EDAUD_azMrS2u0vgR/new/download wdk_user = User #312088803 - vanessarsevero@gmail.com
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
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist