RDE: SDE_RETAILSTOCKLEDGERWEEKFACT Failing With Interlock
(Doc ID 2554057.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Retail Integration Bus - Version 16.0.1 and later
Information in this document applies to any platform.
Getting below error while running SDE_RETAILSTOCKLEDGERWEEKFACT.
ODI-1226: Step SDE_RetailStockLedgerWeekFactLoad fails after 1 attempt(s).
ODI-1240: Flow SDE_RetailStockLedgerWeekFactLoad fails while performing a Insert new rows-IKM RA Oracle Generic Insert with Control- operation. This flow loads target table W_RTL_STCKLDGR_SC_LC_WK_FS.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-BIAPPS_11g_RA_UNIT (90)" is in error.
ODI-1298: Serial task "SERIAL-EU-BIAPPS_11g_RA_UNIT (90)" failed because child task "Insert new rows-IKM RA Oracle Generic Insert with Control- (140)" is in error.
ODI-1228: Task Insert new rows-IKM RA Oracle Generic Insert with Control- fails on the target connection ORACLE_BI_APPLICATIONS.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock
Steps To Recreate:
1. Execute SDE_RETAILSTOCKLEDGERWEEKFACT and note the above error.
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