My Oracle Support Banner

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 JUNE 11, 2021

Applies to:

Oracle Healthcare Foundation - Version 8.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.