Times Reported Most Frequent Error / Event #1

x Hide

ERROR: column r.reference_id does not exist at character 578

Hint: Perhaps you meant to reference the column "cc.reference_id".
Statement: SELECT cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT r.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id ) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc

Date: 2026-07-08 12:40:33

ERROR: column "OMIM" does not exist at character 48

Statement: SELECT * FROM pub1.reference where acc_db_cd = "OMIM" ORDER BY id DESC LIMIT 100

Date: 2026-07-08 12:50:41
Database: ctddev51
Application: pgAdmin 4 - CONN:6418065
User: pubeu
Remote: 

ERROR: column cc.source_acc_txt does not exist at character 111

Statement: SELECT /* ChemConcentrationRefsDAO */ i.* FROM ( SELECT DISTINCT r.acc_txt AS refAcc, cc.source_acc_txt AS sourceAcc, cc.source_acc_db_id AS sourceAccDbId, r.id, r.abbr_authors_txt AS authors, r.title, r.core_citation_txt AS citation, r.pub_start_yr AS yr, r.has_diseases OR r.has_ixns OR r.has_exposures OR r.has_phenotypes AS iscurated, c.acc_txt AS chemacc, cc.chem_id AS chemid, cc.disease_id AS diseaseid, r.has_exposures AS hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN reference r ON cc.reference_id = r.id WHERE cc.chem_id = 1486859 ) i;

Date: 2026-07-08 14:12:14

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

ERROR: syntax error at or near "," at character 102

Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT ,r.acc_txt refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = $1 ) i ORDER BY 1 LIMIT 50

Date: 2026-07-08 15:20:50
Database: ctddev51
Application: 
User: pubeu
Remote: 

ERROR: syntax error at or near "," at character 102

Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT ,r.acc_txt refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = ? ) i ORDER BY 1 LIMIT 50

Date: 2026-07-08 15:49:24

ERROR: syntax error at or near ")" at character 539

Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT r.acc_txt refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = ? ) i ORDER BY 1 LIMIT 50

Date: 2026-07-08 15:49:34

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: table name "r" specified more than once

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT r.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id ) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc

Date: 2026-07-08 12:40:00
Database: ctddev51
Application: pgAdmin 4 - CONN:6375286
User: pubeu
Remote: 

ERROR: table name "r" specified more than once

Statement: SELECT cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT r.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id ) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc

Date: 2026-07-08 12:40:13

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: missing FROM-clause entry for table "cdr" at character 104

Statement: SELECT /* ChemConcentrationRefsDAO */ i.* FROM ( SELECT DISTINCT COALESCE( cdr.source_acc_txt, 'ZZZ ' || r.sort_txt ) AS refcolsort, CASE WHEN cdr.source_acc_db_id IS NOT NULL THEN get_disease_ixn_source_link_html( cdr.source_acc_db_id, cdr.source_acc_txt ) END AS sourceacclink, r.acc_txt AS refAcc, cc.source_acc_txt AS sourceAcc, cc.source_acc_db_id AS sourceAccDbId, r.id, r.abbr_authors_txt AS authors, r.title, r.core_citation_txt AS citation, r.pub_start_yr AS yr, r.has_diseases OR r.has_ixns OR r.has_exposures OR r.has_phenotypes AS iscurated, c.acc_txt AS chemacc, cc.chem_id AS chemid, cc.disease_id AS diseaseid, r.has_exposures AS hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN reference r ON cc.reference_id = r.id WHERE cc.chem_id = 1486859 ) i;

Date: 2026-07-08 14:11:40

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: canceling statement due to user request

Statement: SELECT * FROM pub1.reference where acc_db_cd = 'PUBMED'

Date: 2026-07-08 12:51:27

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

ERROR: operator does not exist: character varying == unknown at character 46

Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM pub1.reference where acc_db_cd == 'PUBMED'

Date: 2026-07-08 12:51:12

x Hide