ORCO Retrying to Process a Failed Jar File Without Moving It to Archive Folder (Doc ID 2266264.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

When the Oracle Retail Central Office (ORCO) tries to process a Jar file that contains incorrect data, the processing will fail due to 'ORA-12899: value too large for column' error.
The issue is that ORCO does not move the jar file to the archive folder, instead it keeps trying to reprocess the same jar file with no maximum number of retries.

Steps to Recreate :

1. Place a Jar file that contains incorrect data into the Data Import(DIMP) Incoming folder.
2. The processing will fail due to 'ORA-12899: value too large for column' error.
3. The Archive Status MA_STS_BNDL_IMP.SC_STS_BNDL remains 'Processing' and the BundleRetryCount MA_STS_BNDL_IMP.QU_BNDL_RTRY_CNT keeps incrementing.

The MOM file is never moved to the Archive folder.

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