E_REJECT_DATA_NOTIF_JOB Failed Due to "ORA-00942: table or view does not exist"
(Doc ID 2982632.1)
Last updated on OCTOBER 30, 2023
Applies to:
Oracle Retail Science Platform Cloud Service - Version 23.1 and laterOracle Retail AI Foundation Cloud Service - Version 23.2 and later
Information in this document applies to any platform.
Goal
After recent version update, E_REJECT_DATA_NOTIF_JOB fails with log below.
2023-10-20T23:34:02,737 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: BEGIN reject_record_reload.load_all_e_notification; END;
2023-10-20T23:34:02,738 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
2023-10-20T23:34:02,738 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: *
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ERROR at line 1:
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-20001: Error occurred in REJECT_RECORD_RELOAD.LOAD_ALL_E_NOTIFICATION
2023-10-20T23:34:02,739 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
2023-10-20T23:34:02,740 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 721
2023-10-20T23:34:02,740 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-20001: Error occurred in REJECT_RECORD_RELOAD.LOAD_E_NOTIFICATION
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 680
2023-10-20T23:34:02,741 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-00942: table or view does not exist
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 660
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 703
2023-10-20T23:34:02,742 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at "RABE01USER.REJECT_RECORD_RELOAD", line 703
2023-10-20T23:34:02,743 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh: ORA-06512: at line 1
2023-10-20T23:34:02,743 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
2023-10-20T23:34:02,744 [Thread-114] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:rejdatanotifplp.ksh:
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! |