My Oracle Support Banner

RI/AI : How to Resolve W_RTL_STCKLDGR_SC_LC_WK_F_JOB Failure with Error "ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter" (Doc ID 2958540.1)

Last updated on JUNE 30, 2023

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Demand Forecasting Cloud Service Plus - Version 23.1 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 22.1 and later
Information in this document applies to any platform.

Goal

During the POM RI Schedule cycle, the W_RTL_STCKLDGR_SC_LC_WK_F_JOB Failed with the following error:
ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter
and 
ORA-00001: unique constraint (RADM01.PK_W_RTL_STCKLDGR_SC_LC_WK_F) violated

How can this be resolved? 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.