DIMP Import Fails On LO_ADS Table (Doc ID 2292114.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Retail Central Office - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Central Office (ORCO) version 14.1.2, during StoreOrgHier_corp.xml, Data Import (DIMP) process fails on LO_ADS table with error:

[error completing import...][Unable to Copy data from temp table LO_ADS_TEMP to LO_ADS; nested exception is:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "CO14.COPY_DATA_BETWEEN_TABLES", line 2
ORA-06512: at line 1...][ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "CO14.COPY_DATA_BETWEEN_TABLES", line 2
ORA-06512: at line 1...]


The rest of the DIMP is then not processed (MerchandiseHier, ItemExport)
For the LO_ADS table, as KillAndFill is used, the foundation data records are removed.


The issue can be reproduced at will with the following steps:

1. Import StoreOrgHier_corp.xml;
2. See the above error.

Changes

 

Cause

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 hundreds of Community platforms