'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 DECEMBER 12, 2016

Applies to:

Oracle Retail Point-of-Service - Version 13.2 and later
Information in this document applies to any platform.

Symptoms

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.


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.

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