My Oracle Support Banner

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 later
Information 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


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