Sale Transaction Tendered with Check is Sent to QueueException Folder Due to "ORA-12899: Value Too Large for Column" Error When ORPOS is Integrated with RSA
(Doc ID 1601312.1)
Last updated on FEBRUARY 08, 2019
Applies to:Oracle Retail Point-of-Service - Version 13.3 and later
Information in this document applies to any platform.
When attempting to persist a sale transaction that is tendered with a check and driver license swiped on magnetic stripe reader (MSR), the transaction fails to save to the Store database and the following error occurs:
"ERROR 2013-10-10 16:05:42,292 206763 (TransactionQueueMonitor-2:oracle.retail.stores.foundation.manager.data.DataManager):
Cannot continue upon DataException per config of TransactionWriteDataTransaction
Class: oracle.retail.stores.foundation.manager.data.DataException(Revision $Revision: /main/14 $) @21909158: SQLState: 72000
Error generated from Oracle: user requested cancel of current operation, Source Exception: java.sql.SQLException: ORA-12899: value too large for column "BASEOWNER"."TR_LTM_CHK_TND"."TRK1_ID" (actual: 369, maximum: 120)
Transaction Name: [TransactionWriteDataTransaction]
Error code:  [An error occurred while executing the command]
Error code (extended): 
Description: [SQLState: 72000]"
Steps to Reproduce:
Prerequisite: ORPOS should be integrated with RSA (key management service).
- Log into ORPOS.
- Scan an item.
- Press Tender -> Check -> Select ID Type as 'Driver's License'.
- Swipe Driver's License at MSR.
- Enter phone number -> Scan Check or enter manually -> Enter Check Number.
- Complete the transaction.
- Note that the transaction is sent to the QueueException folder with the error above.
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