Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 5s706ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2026-02-12 13:36:33
Duration: 5s706ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 5s706ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2026-02-12 13:36:33
Duration: 5s706ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 5s706ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1375875') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2026-02-12 13:36:33
Duration: 5s706ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Most Frequent Error / Event #1

x Hide

ERROR: column "reference_acc_txt" does not exist at character 8

Statement: select reference_acc_txt from pub1.reference limit 100

Date: 2026-02-12 11:38:21

ERROR: column "reference_acc_db_id" does not exist at character 17

Statement: select acc_txt, reference_acc_db_id, * from pub1.reference limit 100

Date: 2026-02-12 11:41:30

ERROR: column "acc_db_id" does not exist at character 17

Hint: Perhaps you meant to reference the column "reference.acc_db_cd".
Statement: select acc_txt, acc_db_id, * from pub1.reference limit 100

Date: 2026-02-12 11:41:44

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: syntax error at or near "taxon_id" at character 349

Statement: BEGIN transaction; INSERT INTO pub2.chem_conc ( id ,reference_id ,reference_acc_txt ,reference_acc_db_id ,chem_id ,chem_acc_txt ,chem_acc_db_id ,chem_nm ,chem_nm_html ,chem_conc ,chem_conc_range ,chem_conc_uom_nm taxon_id int4 NOT NULL, ,taxon_acc_txt ,taxon_acc_db_id ,taxon_nm ,taxon_nm_html disease_id int4, ,disease_acc_txt ,disease_acc_db_id ,disease_nm ,disease_nm_html ,chem_conc_exp_route_nm ,ixn_qualifier_nm ,note ,action_type_cd ,chem_co_nm ,chem_catalog_nbr ) ------------------------------------------------------ SELECT cc.id -- id ,r.reference_id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.id -- taxon_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND cc.reference_acc_db_cd = 'PUBCHEM' ----------------------------------------------------------------------------------- -- COMMIT -- rollback; --------------------------------

Date: 2026-02-12 12:55:53

ERROR: syntax error at or near "SELECT" at character 3997

Statement: SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,taxonTerm.id -- taxon_id ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' ----------------------------------------------------------------------------------- SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,taxonTerm.id -- taxon_id ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' ----------------------------------------------------------------------------------- -- rollback

Date: 2026-02-12 13:15:46

ERROR: syntax error at or near "anatomy_id" at character 83

Statement: BEGIN transaction; INSERT INTO pub2.chem_conc_anatomy ( chem_conc_id anatomy_id ,anatomy_acc_txt ,anatomy_acc_db_id ,anatomy_nm ,anatomy_nm_html ,position_seq ) SELECT cca.chem_conc_id -- chem_conc_id ,cca.anatomyTerm.id -- anatomy_acc_txt ,cca.anatomy_acc_txt -- anatomy_acc_txt ,cca.anatomy_acc_db_id -- anatomy_acc_db_id ,anatomyTerm.nm -- anatomy_nm ,anatomyTerm.nm_html -- anatomy_nm_html ,cca.position_seq -- position_seq FROM load.chem_conc_anatomy cca ,pub2.term anatomyTerm WHERE cca.anatomy_acc_txt = anatomyTerm.acc_txt AND anatomyTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'anatomy' ) -------------------------------- -------------------------------- -- COMMIT -- rollback; -- limit 100 -------------------------------- --------------------------------

Date: 2026-02-12 16:16:47

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: select cc.chem_co_nm from load.chem_conc limit 100

Date: 2026-02-12 13:03:59

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,taxonTerm.id -- taxon_id ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' -----------------------------------------------------------------------------------

Date: 2026-02-12 13:15:28

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: BEGIN transaction; INSERT INTO pub2.chem_conc ( id ,reference_id ,reference_acc_txt ,reference_acc_db_id ,chem_id ,chem_acc_txt ,chem_acc_db_id ,chem_nm ,chem_nm_html ,chem_conc ,chem_conc_range ,chem_conc_uom_nm ,taxon_id ,taxon_acc_txt ,taxon_acc_db_id ,taxon_nm ,taxon_nm_html ,disease_id ,disease_acc_txt ,disease_acc_db_id ,disease_nm ,disease_nm_html ,chem_conc_exp_route_nm ,ixn_qualifier_nm ,note ,action_type_cd ,chem_co_nm ,chem_catalog_nbr ) ------------------------------------------------------ SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,taxonTerm.id -- taxon_id ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.id -- disease_id ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' ----------------------------------------------------------------------------------- -- COMMIT -- rollback;

Date: 2026-02-12 13:23:32

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: column "taxon_id" is of type integer but expression is of type character varying at character 1522

Hint: You will need to rewrite or cast the expression.
Statement: BEGIN transaction; INSERT INTO pub2.chem_conc ( id ,reference_id ,reference_acc_txt ,reference_acc_db_id ,chem_id ,chem_acc_txt ,chem_acc_db_id ,chem_nm ,chem_nm_html ,chem_conc ,chem_conc_range ,chem_conc_uom_nm ,taxon_id ,taxon_acc_txt ,taxon_acc_db_id ,taxon_nm ,taxon_nm_html ,disease_id ,disease_acc_txt ,disease_acc_db_id ,disease_nm ,disease_nm_html ,chem_conc_exp_route_nm ,ixn_qualifier_nm ,note ,action_type_cd ,chem_co_nm ,chem_catalog_nbr ) ------------------------------------------------------ SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.id -- taxon_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' ----------------------------------------------------------------------------------- -- COMMIT -- rollback;

Date: 2026-02-12 13:14:03

ERROR: column "disease_id" is of type integer but expression is of type character varying at character 1822

Hint: You will need to rewrite or cast the expression.
Statement: BEGIN transaction; INSERT INTO pub2.chem_conc ( id ,reference_id ,reference_acc_txt ,reference_acc_db_id ,chem_id ,chem_acc_txt ,chem_acc_db_id ,chem_nm ,chem_nm_html ,chem_conc ,chem_conc_range ,chem_conc_uom_nm ,taxon_id ,taxon_acc_txt ,taxon_acc_db_id ,taxon_nm ,taxon_nm_html ,disease_id ,disease_acc_txt ,disease_acc_db_id ,disease_nm ,disease_nm_html ,chem_conc_exp_route_nm ,ixn_qualifier_nm ,note ,action_type_cd ,chem_co_nm ,chem_catalog_nbr ) ------------------------------------------------------ SELECT cc.id -- id ,r.id -- reference_id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,chemTerm.id -- chem_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,ccUOM.nm -- chem_conc_uom_nm ,taxonTerm.id -- taxon_id ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,diseaseTerm.acc_txt -- disease_nm ,actor.acc_db_id -- disease_acc_db_id ,diseaseTerm.id -- disease_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub2.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub2.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) left OUTER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id ----------------------------------------------------------------------------------- left outer join edit.ixn i ON cc.ixn_id = i.id -- don't need root_id here - there are binary relationships left outer JOIN edit.ixn_action ia ON i.id = ia.ixn_id left outer JOIN edit.action_type actionType ON ia.action_type_id = actionType.id left outer JOIN edit.ixn_actor actor ON ia.ixn_id = actor.ixn_id AND actor.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) left outer JOIN pub2.term diseaseTerm ON actor.acc_txt = diseaseTerm.acc_txt AND actor.object_type_id = diseaseTerm.object_type_id INNER JOIN edit.chem_conc_uom ccUOM ON cc.chem_conc_uom_id = ccUOM.id ----------------------------------------------------------------------------------- INNER JOIN pub2.reference r ON cc.reference_acc_txt = r.acc_txt AND r.acc_db_cd = 'PUBMED' ----------------------------------------------------------------------------------- -- COMMIT -- rollback;

Date: 2026-02-12 13:22:04

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

ERROR: relation "pub2.chem_conc" does not exist at character 15

Statement: select * from pub2.chem_conc limit 100

Date: 2026-02-12 10:20:17
Database: ctddev51
Application: pgAdmin 4 - CONN:761484
User: load
Remote: 

x Hide

Times Reported Most Frequent Error / Event #8

x Hide

ERROR: missing FROM-clause entry for table "cc" at character 8

Statement: select cc.chem_co_nm from load.chem_conc limit 100

Date: 2026-02-12 13:04:11

x Hide

Times Reported Most Frequent Error / Event #9

x Hide

ERROR: invalid reference to FROM-clause entry for table "anatomyterm" at character 264

Hint: There is an entry for table "anatomyterm", but it cannot be referenced from this part of the query.
Statement: BEGIN transaction; INSERT INTO pub2.chem_conc_anatomy ( chem_conc_id ,anatomy_id ,anatomy_acc_txt ,anatomy_acc_db_id ,anatomy_nm ,anatomy_nm_html ,position_seq ) SELECT cca.chem_conc_id -- chem_conc_id ,cca.anatomyTerm.id -- anatomy_acc_txt ,cca.anatomy_acc_txt -- anatomy_acc_txt ,cca.anatomy_acc_db_id -- anatomy_acc_db_id ,anatomyTerm.nm -- anatomy_nm ,anatomyTerm.nm_html -- anatomy_nm_html ,cca.position_seq -- position_seq FROM load.chem_conc_anatomy cca ,pub2.term anatomyTerm WHERE cca.anatomy_acc_txt = anatomyTerm.acc_txt AND anatomyTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'anatomy' )

Date: 2026-02-12 16:21:51

x Hide

Times Reported Most Frequent Error / Event #10

x Hide

ERROR: insert or update on table "chem_conc_anatomy" violates foreign key constraint "chem_conc_chem_conc_anatomy_fk"

Detail: Key (chem_conc_id)=(1) is not present in table "chem_conc".
Statement: BEGIN transaction; INSERT INTO pub2.chem_conc_anatomy ( chem_conc_id ,anatomy_id ,anatomy_acc_txt ,anatomy_acc_db_id ,anatomy_nm ,anatomy_nm_html ,position_seq ) SELECT cca.chem_conc_id -- chem_conc_id ,anatomyTerm.id -- anatomy_acc_txt ,cca.anatomy_acc_txt -- anatomy_acc_txt ,cca.anatomy_acc_db_id -- anatomy_acc_db_id ,anatomyTerm.nm -- anatomy_nm ,anatomyTerm.nm_html -- anatomy_nm_html ,cca.position_seq -- position_seq FROM load.chem_conc_anatomy cca ,pub1.term anatomyTerm WHERE cca.anatomy_acc_txt = anatomyTerm.acc_txt AND anatomyTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'anatomy' )

Date: 2026-02-12 16:22:38

x Hide