RTLOG Files Are Intermittently Not Generated for Huge Transactions Due To OutOfMemory Errors
Last updated on JUNE 30, 2018
Applies to:Oracle Retail Point-of-Service - Version 12.0.9 to 14.0.4 [Release 12.0 to 14.0]
Information in this document applies to any platform.
In Oracle Retail Point of Service (ORPOS), Out Of Memory error occurs while generating RTLOG for transactions with more than 300 line items.
Steps to reproduce:
This issue can only be reproduced with large number of line items in the transaction.
1. Create transactions with more than 100 items
2. RTLOG does not get generated for some of the transactions due to OutOfMemoryErrors
In addition RTLog Export failures due to error below occur:
ERROR 2018-06-30 06:43:08,746 24608957 (RTLogExportDaemon-4:com.oracle.xmlreplication.extractor.EntityTable):
Sql error reading table ST_ASCTN_MRHRC
java.sql.SQLException: ORA-00904: "ID_MRHRC_GP": invalid identifier
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