My Oracle Support Banner

'ORA-06512' Error Reported while Running ResaFileParser.sh Job with Over 100 Input Files (Doc ID 1435269.1)

Last updated on FEBRUARY 03, 2019

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

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.