TR: Query For Observation Or Diagnosis In Cohort Explorer Gives Error "An error has occurred. Please contact support with reference 'LOG-#########'

(Doc ID 2337350.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.2.1 to 3.2.1 [Release 3.2]
Information in this document applies to any platform.

Symptoms

Translational Research version 3.2.1, recent upgrade, users get the following error message in the Cohort Explorer UI:

"An error has occurred. Please contact support with reference 'LOG-554009099'
(ok)

(Note:  you may have a different incremented LOG-########## number)

 

Check the Cohort Explorer Log and you see the following:

 

Caused By: java.sql.SQLException: ORA-04023: Object SELECT dd.diagnosis_name,
dd.diagnosis_code,
dh.age_at_first_onset,
dh.diagnosis_onset_dt,
dh.diagnosis_reported_dt,
dh.diagnosis_end_dt,
decode(dsd.row_wid, '-1','','-2','',dsd.diagnosis_status_name) diagnosis_status_name,
decode(asd.row_wid, '-1','','-2','',asd.anatomical_site_name) anatomical_site_name,
decode(asd.row_wid, '-1','','-2','',asd.anatomical_site_code) anatomical_site_code,
patient_identifier,
dc.datasource_name
||'('
||dc.datasource_code
||')' AS datasource,
dd.row_wid AS diagnosis_wid,
dd.DIAGNOSIS_CD_SYS_ID AS diagnosis_code_system_id,
dd.DIAGNOSIS_CD_SYS_NAME AS diagnosis_code_system_name
FROM W_EHA_PATIENT_D_SEARCH_V d,

...

 

AND

 

Log #LOG-554009106 Error Msg: 'SQL error during statement preparation. Statement: SELECT dd.diagnosis_name,
dd.diagnosis_code,
dh.age_at_first_onset,
dh.diagnosis_onset_dt,
dh.diagnosis_reported_dt,
dh.diagnosis_end_dt,
decode(dsd.row_wid, '-1','','-2','',dsd.diagnosis_status_name) diagnosis_status_name,
decode(asd.row_wid, '-1','','-2','',asd.anatomical_site_name) anatomical_site_name,
decode(asd.row_wid, '-1','','-2','',asd.anatomical_site_code) anatomical_site_code,
patient_identifier,
dc.datasource_name
||'('
||dc.datasource_code
||')' AS datasource,
dd.row_wid AS diagnosis_wid,
dd.DIAGNOSIS_CD_SYS_ID AS diagnosis_code_system_id,
dd.DIAGNOSIS_CD_SYS_NAME AS diagnosis_code_system_name
FROM W_EHA_PATIENT_D_SEARCH_V d,

...

 



Steps to Replicate
===================
Cohort Explorer
Click Cohort Query
Click Diagnosis OR Observations
Add Criteria
Click Run Query
results in the aforementioned error message




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms