DIH batch executions are failing.
(Doc ID 3077641.1)
Last updated on MARCH 26, 2025
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.0.7 and laterInformation in this document applies to any platform.
Symptoms
DIH batch execution is failing with index unusable state.
ODI-1217: Session FLX Party Details xxx_100_DEFAULT_DEP_SPEC_SESS (14284) fails with return code ODI-1298.
ODI-1226: Step DEFAULT_DEP_SPEC_STEP fails after 1 attempt(s).
ODI-1240: Flow DEFAULT_DEP_SPEC_STEP fails while performing a Insert new rows-IKM Oracle Insert Only (Ext Tab and DB)- operation. This flow loads target table STG_PARTY_DETAILS.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-FSDFINFO_UNIT (80)" is in error.
ODI-1298: Serial task "SERIAL-EU-FSDFINFO_UNIT (80)" failed because child task "Insert new rows-IKM Oracle Insert Only (Ext Tab and DB)- (130)" is in error.
ODI-1228: Task Insert new rows-IKM Oracle Insert Only (Ext Tab and DB)- fails on the target connection FSDFINFO.
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P008, instance xxxxxxxxx:xxxxxx (1)
ORA-26026: unique index xxxxx.PK_332 initially in unusable state
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 |