OHF Workflow Fails With "ORA-26002: Table HCD.W_HCD_INT_ORG_DH has index defined upon it" Due To Bulk Load Settings
(Doc ID 2619232.1)
Last updated on FEBRUARY 20, 2023
Applies to:
Oracle Healthcare Foundation - Version 7.1.1 and laterInformation in this document applies to any platform.
Symptoms
On Oracle Healthcare Foundation (OHF) 7.1.1 version
When attempting to execute Informatica workflow wf_SIL_HCD_W_HCD_INT_ORG_DH, the workflow is failing due to Oracle bulk load setting on target table that has indexes built over it. Many of the workflows in the HCD_HIERARCHY_LOAD folder have similar settings.
ERROR
-----------------------
2019-12-03 13:10:52 : ERROR : (1985 | WRITER_1_*_1) : (IS | IS_Common_Datamart_Loaders_711_DEV) : <HOST_NAME>_<NODE_ID> : WRT_8229 : Database errors occurred:
ORA-26002: Table HCD.W_HCD_INT_ORG_DH has index defined upon it.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the workflow wf_SIL_HCD_W_HCD_INT_ORG_DH
2. Then workflow is failing due to Oracle bulk load setting on target table since it has indexes built over it.
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 |
Cause |
Solution |
References |