My Oracle Support Banner

W_RTL_ITEM_GRP1_D_ITEMBRAND_JOB, W_RTL_ITEM_GRP1_D_ITEMSIZE_JOB, and W_RTL_ITEM_GRP1_D_ITEMCOLOR_JOB Are Stuck (Doc ID 2954783.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

W_RTL_ITEM_GRP1_D_ITEMBRAND_JOB, W_RTL_ITEM_GRP1_D_ITEMSIZE_JOB, and W_RTL_ITEM_GRP1_D_ITEMCOLOR_JOB were started at the same time and ran for a long time. Eventually. the jobs failed with ERROR ReSTUtils - Internal Server Error.

Failed during operation - Querying DIS job W_RTL_ITEM_GRP1_D_ITEMBRAND_JOB, process LOAD_DIMENSION_ITEMBRAND_GROUP1_PROCESS, taskId W_RTL_ITEM_GRP1_D_ITEMBRAND_JOB-SIL_RETAILITEMDIFFDIMENSION_BRAND1686177973046, params {logLevel=5, disJobType=ODI_JOB_RUN, name=SIL_RETAILITEMDIFFDIMENSION_BRAND, context=DEVELOPMENT, type=SCN, params=RA_BI.RA_ITEM_GRP_DIFF:BRAND, referenceId=W_RTL_ITEM_GRP1_D_ITEMBRAND_JOB-SIL_RETAILITEMDIFFDIMENSION_BRAND1686177973046}
oracle.retail.apps.oam.common.rest.exception.ReSTInvocationException: Internal Server Error

ERROR AbstractInvoker - Failed during operation - Querying DIS job W_RTL_ITEM_GRP1_D_ITEMSIZE_JOB, process LOAD_DIMENSION_ITEMSIZE_GROUP1_PROCESS, taskId W_RTL_ITEM_GRP1_D_ITEMSIZE_JOB-SIL_RETAILITEMDIFFDIMENSION_SIZE1686177972734, params {logLevel=5, disJobType=ODI_JOB_RUN, name=SIL_RETAILITEMDIFFDIMENSION_SIZE, context=DEVELOPMENT, type=SCN, params=RA_BI.RA_ITEM_GRP_DIFF:SIZE, referenceId=W_RTL_ITEM_GRP1_D_ITEMSIZE_JOB-SIL_RETAILITEMDIFFDIMENSION_SIZE1686177972734}
oracle.retail.apps.oam.common.rest.exception.ReSTInvocationException: Internal Server Error 

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.