My Oracle Support Banner

RI Job SI_W_PRODUCT_DS_TL_JOB Failing with Unique Constraint Error (Doc ID 2897372.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

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

Goal

Job SI_W_PRODUCT_DS_TL_JOB is failing with a unique constraint error:

2022-09-20T10:41:09,735 DEBUG ERROR at line 1:
2022-09-20T10:41:09,735 DEBUG ORA-00001: unique constraint (RADM01.UI_W_PRODUCT_DS_TL) violated
2022-09-20T10:41:09,736 DEBUG ORA-06512: at "RADM01.RI_PROD_EXTRN_UTIL", line 255
2022-09-20T10:41:09,736 DEBUG ORA-06512: at "RADM01.RI_PROD_EXTRN_UTIL", line 245
2022-09-20T10:41:09,736 DEBUG ORA-06512: at "RADM01.RI_PROD_EXTRN_UTIL", line 208
2022-09-20T10:41:09,736 DEBUG ORA-06512: at line 2
2022-09-20T10:41:09,736 DEBUG
2022-09-20T10:41:09,736 DEBUG
2022-09-20T10:41:09,754 DEBUG ### 20-09-2022_10:41:09 SCRIPT extfileprodtlds.ksh FAILED. CHECK ERROR FILE(/u01/retail/ri/mmhome/error/extfileprodtlds_20092022_104032.log) FOR MORE DETAILS. ###

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.