My Oracle Support Banner

ReSA Batch SAIMPTLOG Fails With Memory Fault Error While Loading Large RTLOG Files (Doc ID 1605654.1)

Last updated on JANUARY 22, 2018

Applies to:

Oracle Retail Sales Audit - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

Oracle Retail Sales Audit (ReSA) batch SAIMPTLOG fails with a memory fault error/core dump while loading large RTLOG files.


Steps to Reproduce:

1. Create or select an eligible store_day for data load. Collect the store_day_seq_no.
2. Run SAGETREF batch for this store_day_seq_no to generate necessary datafiles.
3. Create a large RTLOG file with the store and business date selected above in such a way so that the file has at least one transaction that will produce more than 40 errors by itself alone.
4. Run SAIMPTLOGI batch and notice that the program aborts with a coredump error.

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.