'ORA-06512' Error Reported while Running ResaFileParser.sh Job with Over 100 Input Files

(Doc ID 1435269.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.3.3 and later
Information in this document applies to any platform.

Symptoms

In Store Inventory Management (SIM), when ResaFileParser.sh batch is run with over 100 input files (for 100 different stores), the batch aborts with the following error:

 

531836633[ERROR]ORA-06512: at "SYS.UTL_FILE", line 536
ORA-06512: at "SIM.RESA_FILE_PARSER", line 625

 Steps to Reproduce:

1. Process 100 input POSU file as follows:
    a. For each input file, kick off the batch.
    b. Process 10 files at a time.
2. The error can be observed after processing 60 files.


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