My Oracle Support Banner

AIP: Running ext_order_group_assignment_in.sh Results in Error "E108: ORA-20001: run_post_load:ORA-20001: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" (Doc ID 2737576.1)

Last updated on DECEMBER 17, 2020

Applies to:

Oracle Retail Advanced Inventory Planning - Version 13.0.2.7 and later
Information in this document applies to any platform.

Symptoms

In AIP, intermittently running ext_order_multiple_in.sh or ext_order_group_assignment_in.sh the job will fail with the below error:

FATAL - E135: Exception in operator [orawrite:6]
E108: ORA-20001: run_post_load:ORA-20001: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-20001: run_post_load:ORA-20001: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired returned by aip_util.enable_constraints. returned by aip_util.enable_constraints.

Rerunning the same job it completes successfully.

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!


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