P6 ETL Fails with Detailed Error 'Ora-30926 ...Stable Set of Rows' Updating Table W_REFRDELETE_S
(Doc ID 2940357.1)
Last updated on OCTOBER 10, 2023
Applies to:
Construction Intelligence Cloud Service - Version 22.10 to 23.4 [Release 22.10 to 23.4]Primavera Analytics Cloud Service - Version 16.1.0.0 to 23.4 [Release 16.1 to 23.4]
Information in this document applies to any platform.
Symptoms
When running P6 ETL, the following detailed ODI error occurs.
ODI-1217: Session P6_SCHEDULED_W_REFDELETE_S_PHYSICAL (452697) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1240: Flow Physical_STEP fails while performing a Merge into Refdel table-IKM Oracle Incremental Update (DELETE)- operation. This flow loads target table W_REFDELETE_S.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-PRIMAVERA_ANALYTICS_TGT_LS_UNIT (80)" is in error.
ODI-1298: Serial task "SERIAL-EU-PRIMAVERA_ANALYTICS_TGT_LS_UNIT (80)" failed because child task "Merge into Refdel table-IKM Oracle Incremental Update (DELETE)- (160)" is in error.
ODI-1228: Task Merge into Refdel table-IKM Oracle Incremental Update (DELETE)- fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
Caused By: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
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! |