My Oracle Support Banner

Error:"ORA-00001: Unique Constraint (PK_W_RTL_PROMO_D) Violated" When Running Seed Program SIL_RetailInitial_W_RTL_PROMO_D_Dummy_Load (Doc ID 1604217.1)

Last updated on DECEMBER 03, 2020

Applies to:

Oracle Retail Merchandising Insights - Version 13.3 to 13.3.6 [Release 13.3]
Information in this document applies to any platform.


The Retail Analytics (RA) 13.3 initial data seeding program SIL_RetailInitial_W_RTL_PROMO_D_Dummy_Load fails with a unique constraint violation error:

 Steps to Reproduce:

1. Make sure you have W_RTL_PROMO_D.csv file shipped with installation of RA 13.3.6.
2. Put the file in the directory where ODI installation file directory is set (FILE_GENERIC.#GLOBAL.GET_ODI_HOME/file/ra/install)
3. Run Unix wrapper SIL_RetailLoadControlSeedData.ksh to run seeding program from $MMHOME/src.
4. See the execution log through Operator in step SIL_RetailInitial_W_RTL_PROMO_D_Dummy_Load.  You will see the above error message.




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

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