Error Running OHF 8.0.1 CDM Informatica Workflow Wf_SIL_CDM_W_EHA_DX_PATIENT_H_FULL
(Doc ID 2768265.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Healthcare Foundation - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
On : Oracle Healthcare Foundation 8.0.1 version, Installer and configuration
When attempting to run OHF 801 CDM informatica workflow wf_SIL_CDM_W_EHA_DX_PATIENT_H_FULL,
the following error occurs:
ERROR
-----------------------
2021-03-31 15:46:29 : ERROR : (42591 | MAPPING) : (IS | IS_Cohort_Datamart_Loaders_801_TEST) : CMN_1022 : Database driver error...
CMN_1022 [CALL CDM.CDM_SCHEMA_MAINT_UTIL.CREATE_TAB_INDEXES('W_EHA_DX_PATIENT_H')
ORA-20005: Application error creating index W_EHA_DX_PATIENT_H_U1 for W_EHA_DX_PATIENT_H
ORA-12801: error signaled in parallel query server P005
ORA-06512: at "CDM.CDM_SCHEMA_MAINT_UTIL", line 104
ORA-06512: at "CDM.CDM_SCHEMA_MAINT_UTIL", line 104
Try to create the index manually where the above error was reported:
CREATE UNIQUE INDEX W_EHA_DX_PATIENT_H_U1
ON W_EHA_DX_PATIENT_H (INTEGRATION_ID ASC, DATASOURCE_NUM_ID ASC)
TABLESPACE CDM_INDEX_TS
The following error occurs:
ORA-12801: error signaled in parallel query server P00F
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |