RAF_NOTIFICATION_PURGE_JOB is Failing Everyday with Deadlock
(Doc ID 3010436.1)
Last updated on MARCH 14, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Goal
RAF_NOTIFICATION_PURGE_JOB is failing everyday with deadlock
We have the batch RAF_NOTIFICATION_PURGE_JOB is failing everyday in nightly chain with deadlock error
ctShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: raf_notification_purge~20240215072244~EXEC_SQL~
2024-02-15T07:22:44,093 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: @0ORA-00060: deadlock detected while waiting for resource@1RAF_NOTIFICATION_TASK
2024-02-15T07:22:44,093 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: _PKG DEL_NOTIFS_PAST_RETENTION FAILED@2-60
2024-02-15T07:22:44,100 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Thu Feb 15 07:22:44 Program: raf_notification_purge: PID=26063: Aborted in EXEC_SQL
2024-02-15T07:22:44,938 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: raf_notification_purge~20240215072244~DEL_NOTIF_PAST_RETENTION~RAF_NOTIFICATION_TASK_PKG.DEL_NOTIF_PAST_RETENTION Failed
2024-02-15T07:22:44,944 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Thu Feb 15 07:22:44 Program: raf_notification_purge: PID=26063: Aborted in DEL_NOTIF_PAST_RETENTION
2024-02-15T07:22:45,806 [Thread-170] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Thu Feb 15 07:22:45 Program: raf_notification_purge: PID=26063: Errors encountered. See error file
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! |
In this Document
Goal |
Solution |
References |