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