B1_PKG_CF_ORDER Failing In Daily Jobs
(Doc ID 2378468.1)
Last updated on MARCH 27, 2018
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.0 version, Install / Upgrade
B1_PKG_CF_ORDER failing in daily jobs
In OUA daily jobs, B1_PKG_CF_ORDER is failing with the below error:
ODI-1217: Session B1_PKG_CF_ORDER (88768) fails with return code ODI-1298.
ODI-1226: Step B1_F_ORDER fails after 1 attempt(s).
ODI-1240: Flow B1_F_ORDER fails while performing a Merge rows in Staging-IKM BI Fact Key Lookup- operation. This flow loads target table CF_ORDER.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-Target_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-Target_UNIT (20)" failed because child task "Merge rows in Staging-IKM BI Fact Key Lookup- (230)" is in error.
ODI-1228: Task Merge rows in Staging-IKM BI Fact Key Lookup- fails on the target connection B1.
Caused By: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
CF_Order fact was failing because of data issue in the CCB replication schema.
GoldenGate was unable to histories replication data properly. Hence, duplicates were coming during fact processing and fact job was failing wit error “Unable to get stable set of rows”.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!