'ORA-12899 - SQLState: 72000' Causes Continuous Retrying of Transaction Persistence, Resulting in Loss of the Next Set of Transactions
(Doc ID 1519656.1)
Last updated on MARCH 20, 2023
Applies to:Oracle Retail Point-of-Service - Version 13.2 and later
Information in this document applies to any platform.
When attempting to insert a record with a longer response than accepted into "TR_LTM_CHK_TND"."ID_AJD_CHK", the following error occurs and the application does not handle the exception. This causes loss of transaction data for subsequent transactions.
"ERROR 2012-12-04 19:57:42,093 51418562 (RMI TCP Connection(11460)-10.192.68.1:com.extendyourstore.domain.arts.JdbcSaveTenderLineItems):
Class: com.extendyourstore.foundation.manager.data.DataException(Revision $Revision: /main/10 $) @12460173: SQLState: 72000
Error generated from Oracle: user requested cancel of current operationSource Exception: java.sql.SQLException: ORA-12899: value too large for column "POS_OWNER"."TR_LTM_CHK_TND"."ID_AJD_CHK" (actual: 22, maximum: 20)
Error code:  [An error occurred while executing the command]
Error code (extended): 
Description: [SQLState: 72000
Error generated from Oracle: user requested cancel of current operationSource Exception: java.sql.SQLException: ORA-12899: value too large for column "POS_OWNER"."TR_LTM_CHK_TND"."ID_AJD_CHK" (actual: 22, maximum: 20)"
Steps to Reproduce:
1. Introduce a transaction with a response for the check approval longer than 20 characters.
2. POS does not move the transaction to the QueueException folder, nor is it retried for persistence.
The transaction is just lost (as well as the subsequent transactions) in the FileQueue.
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