My Oracle Support Banner

SALESPROCESS_CYCLE_JOB Failing With Error "EXT_PROG_SYS_OUT:@RMSAlias:Timeout expired@2SALES_PROCESS_BI_SQL.UPDATE_STATUS" (Doc ID 2961842.1)

Last updated on JULY 18, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 to 23.1 [Release 22.1 to 23.1]
Information in this document applies to any platform.

Symptoms

SALESPROCESS_CYCLE_JOB fails with error:

"@0PACKAGE_ERROR@1ORA-00054: resource busy and acquire with NOWAIT specified or t
2023-07-14T05:12:02,441 [Thread-166] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias:Timeout expired@2SALES_PROCESS_BI_SQL.UPDATE_STATUS"

Steps to reproduce:

1. Run SALESPROCESS_CYCLE_JOB.
2. Batch fails with error.

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


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