Times Reported Most Frequent Error / Event #1

x Hide

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

ERROR: syntax error at or near "ELECT" at character 1

Statement: ELECT /* GeneBrowseTermsDAO */ t.nm ,t.nm_html nmHtml ,t.secondary_nm secondaryNm ,t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_exposures hasExposures ,t.has_phenotypes hasPhenotypes ,COUNT(*) OVER() fullRowCount FROM term t WHERE t.object_type_id = $1 AND REGEXP_REPLACE(UPPER(SUBSTRING(t.nm,1,1)),'[^A-Z]','#') = $2 ORDER BY t.nm_sort LIMIT 100

Date: 2026-05-22 09:56:13
Database: ctddev51
Application: 
User: qaeu
Remote: 

ERROR: syntax error at or near "ELECT" at character 1

Statement: ELECT /* GeneBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( ELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm secondaryNm ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Symbol' THEN true ELSE false END isNameMatch ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isSecondaryNameMatch ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_exposures hasExposures ,CASE WHEN UPPER(l.nm) = $1 THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.has_phenotypes hasPhenotypes FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE l.object_type_id = 4 AND t.object_type_id = 4 AND l.id IN( ELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', $2) ) UNION ALL ELECT /* acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm secondaryNm ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,false isSecondaryNameMatch ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_exposures hasExposures ,1 relevance ,t.nm_sort ,t.id ,t.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 4 AND (upper( l.acc_txt ) = $3 ) ORDER BY 13,14 ) sq LIMIT 50

Date: 2026-05-22 10:11:07
Database: ctddev51
Application: 
User: qaeu
Remote: 

ERROR: syntax error at or near "FIRST_VALUE" at character 835

Statement: SELECT /* GeneBasicQueryDAO */ sq.* ,COUNT(*) OVER() fullRowCount FROM ( SELECT /* label */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm secondaryNm ,l.nm matchedNm ,lt.nm_display matchedType ,CASE WHEN lt.nm_display='Symbol' THEN true ELSE false END isNameMatch ,CASE WHEN lt.nm_display='Name' THEN true ELSE false END isSecondaryNameMatch ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_exposures hasExposures ,CASE WHEN UPPER(l.nm) = 'INS' THEN 1 ELSE 2 END relevance ,t.nm_sort ,t.id ,t.has_phenotypes hasPhenotypes FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE l.object_type_id = 4 AND t.object_type_id = 4 AND l.id IN( ELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'INS') ) UNION ALL SELECT /* acc */ t.acc_txt acc ,'name:' || t.nm accQueryStr ,t.nm ,t.nm_html nmHtml ,t.secondary_nm secondaryNm ,l.acc_txt matchednm ,'Accession' matchedtype ,false isNameMatch ,false isSecondaryNameMatch ,t.has_chems hasChems ,t.has_diseases hasDiseases ,t.has_exposures hasExposures ,1 relevance ,t.nm_sort ,t.id ,t.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 4 AND (upper( l.acc_txt ) = 'INS' ) ORDER BY 13,14 ) sq

Date: 2026-05-22 10:14:36
Database: ctddev51
Application: pgAdmin 4 - CONN:676043
User: pub1
Remote: 

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

ERROR: column reference "nm" is ambiguous at character 8

Statement: SELECT nm, FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'INS')

Date: 2026-05-22 10:16:42
Database: ctddev51
Application: pgAdmin 4 - CONN:7421198
User: pub1
Remote: 

ERROR: column reference "nm" is ambiguous at character 26

Statement: SELECT FIRST_VALUE(i.id, nm) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'INS')

Date: 2026-05-22 10:17:10

ERROR: column reference "id" is ambiguous at character 79

Statement: select t.nm, tl.* from term_label tl ,term t where t.id = tl.term_id and id in ( SELECT FIRST_VALUE(i.id) OVER(PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'INS') )

Date: 2026-05-22 10:18:19

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: schema "simple" does not exist at character 235

Statement: SELECT DISTINCT ON (tl.term_id) t.nm, tl.* FROM term_label tl INNER JOIN term t ON t.id = tl.term_id INNER JOIN term_label_type it ON tl.term_label_type_id = it.id WHERE tl.object_type_id = 4 AND tl.nm_fts @@ to_tsquery('simple.english_nostops', 'INS') -- AND tl.nm_fts @@ to_tsquery('common.english_nostops', 'INS') gives 1934 rows -- AND tl.nm like '%INS%' gives 60 rows ORDER BY tl.term_id, it.priority_seq, tl.nm;

Date: 2026-05-22 11:50:59

ERROR: schema "english" does not exist at character 235

Statement: SELECT DISTINCT ON (tl.term_id) t.nm, tl.* FROM term_label tl INNER JOIN term t ON t.id = tl.term_id INNER JOIN term_label_type it ON tl.term_label_type_id = it.id WHERE tl.object_type_id = 4 AND tl.nm_fts @@ to_tsquery('english.simple', 'INS') -- AND tl.nm_fts @@ to_tsquery('common.english_nostops', 'INS') gives 1934 rows -- AND tl.nm like '%INS%' gives 60 rows ORDER BY tl.term_id, it.priority_seq, tl.nm;

Date: 2026-05-22 14:43:47

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: cross-database references are not implemented: simple.english.nostops at character 235

Statement: SELECT DISTINCT ON (tl.term_id) t.nm, tl.* FROM term_label tl INNER JOIN term t ON t.id = tl.term_id INNER JOIN term_label_type it ON tl.term_label_type_id = it.id WHERE tl.object_type_id = 4 AND tl.nm_fts @@ to_tsquery('simple.english.nostops', 'INS') -- AND tl.nm_fts @@ to_tsquery('common.english_nostops', 'INS') gives 1934 rows -- AND tl.nm like '%INS%' gives 60 rows ORDER BY tl.term_id, it.priority_seq, tl.nm;

Date: 2026-05-22 11:50:40
Database: ctddev51
Application: pgAdmin 4 - CONN:6666373
User: pub1
Remote: 

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: cross-database references are not implemented: common.english.simple at character 235

Statement: SELECT DISTINCT ON (tl.term_id) t.nm, tl.* FROM term_label tl INNER JOIN term t ON t.id = tl.term_id INNER JOIN term_label_type it ON tl.term_label_type_id = it.id WHERE tl.object_type_id = 4 AND tl.nm_fts @@ to_tsquery('common.english.simple', 'INS') -- AND tl.nm_fts @@ to_tsquery('common.english_nostops', 'INS') gives 1934 rows -- AND tl.nm like '%INS%' gives 60 rows ORDER BY tl.term_id, it.priority_seq, tl.nm;

Date: 2026-05-22 14:44:28

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

FATAL: password authentication failed for user "jwiegers"

Detail: Role "jwiegers" does not exist. Connection matched pg_hba.conf line 80: "host all all 10.12.5.0/24 md5 "

Date: 2026-05-22 12:09:18

x Hide

Times Reported Most Frequent Error / Event #8

x Hide

x Hide

Times Reported Most Frequent Error / Event #9

x Hide

ERROR: text search configuration "common.english_simple" does not exist at character 235

Statement: SELECT DISTINCT ON (tl.term_id) t.nm, tl.* FROM term_label tl INNER JOIN term t ON t.id = tl.term_id INNER JOIN term_label_type it ON tl.term_label_type_id = it.id WHERE tl.object_type_id = 4 AND tl.nm_fts @@ to_tsquery('common.english_simple', 'INS') -- AND tl.nm_fts @@ to_tsquery('common.english_nostops', 'INS') gives 1934 rows -- AND tl.nm like '%INS%' gives 60 rows ORDER BY tl.term_id, it.priority_seq, tl.nm;

Date: 2026-05-22 14:44:46

x Hide