HIST_LOAD_PRICE_JOB Aborting With Unique Constraint Error
(Doc ID 2983859.1)
Last updated on NOVEMBER 01, 2023
Applies to:
Oracle Retail Insights Cloud Service Suite - Version 21.0 to 23.2 [Release 21.0 to 23.2]Information in this document applies to any platform.
Symptoms
HIST_LOAD_PRICE_JOB aborting with Unique Constraint error.
Error while running RI_PRICE_HIST_LOAD
2023-07-31T19:09:31,097 [Thread-131] INFO AbstractShellJobExecutor -
***********************************************************************************************
2023-07-31T19:09:34,763 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: BEGIN RI_PRICE_HIST_LOAD.RI_PRICE_HIST_LOAD; END;
2023-07-31T19:09:34,764 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: 2023-07-31T19:09:34,765 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: *
2023-07-31T19:09:34,765 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ERROR at line 1:
2023-07-31T19:09:34,766 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-20001: Error occurred in RI_PRICE_HIST_LOAD.RI_PRICE_HIST_LOAD - Invalid history load last date which should be one day prior to daily seeding day
2023-07-31T19:09:34,766 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-6512: at "RADM01.RI_LOG_UTIL", line 317
2023-07-31T19:09:34,766 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-6512: at "RABE01USER.RI_PRICE_HIST_LOAD", line 2801
2023-07-31T19:09:34,767 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-6510: PL/SQL: unhandled user-defined exception
2023-07-31T19:09:34,767 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-6512: at "RABE01USER.RI_PRICE_HIST_LOAD", line 2698
2023-07-31T19:09:34,768 [Thread-131] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:histpricesil.ksh: ORA-6512: at line 1
Cause
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
Symptoms |
Cause |
Solution |
References |