My Oracle Support Banner

Transactions Fail To Persist In Store Database Due To "ORA-01013: user requested cancel of current operation" Error (Doc ID 2642485.1)

Last updated on MARCH 03, 2020

Applies to:

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

Symptoms

In Oracle Retail Point of Service (RPOS), transactions fail to persist to the store database and sent to the QueueException folder on the store server. The following error is seen in the orpos.log:

ERROR 2019-12-28 11:20:50,236 32499783 (RMI TCP Connection(<PORT>)-<IP>:oracle.retail.stores.commext.technician.data.RetailTransactionTechnician):
[oracle.retail.stores.commext.technician.data.RetailTransactionTechnician.translateException(RetailTransactionTechnician.java:95)]
Class: oracle.retail.stores.foundation.tour.gate.ValetException(Revision /rgbustores_13.4x_generic_branch/1) @3858085: Class: oracle.retail.stores.foundation.manager.data.DataException(Revision $Revision: /rgbustores_13.4x_generic_branch/1 $) @7488118: SQLState: UNKNOWN
Error generated from Oracle: Unknown, Source Exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
Transaction Name: [TransactionWriteDataTransaction]
Error code: [3] [A connection error occurred during database access.]
Error code (extended): [604]
Description: [SQLState: UNKNOWN
Error generated from Oracle: Unknown, Source Exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
]
Query String: INSERT INTO TR_TRN ( ID_STR_RT, ID_WS, DC_DY_BSN, AI_TRN, ID_OPR, TS_TRN_BGN, TS_TRN_END, TY_TRN, FL_TRG_TRN, ID_EM, INF_CT, TY_INF_CT, SC_TRN, ID_RPSTY_TND, SC_PST_PRCS, TS_MDF_RCRD, TS_CRT_RCRD, FL_TRE_TRN, FL_SLS_ASSC_MDF) VALUES (...)
Original exception: [null]
Nested exception--->Class: oracle.retail.stores.foundation.manager.data.DataException(Revision $Revision: /rgbustores_13.4x_generic_branch/1 $) @7488118: SQLState: UNKNOWN
Error generated from Oracle: Unknown, Source Exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
Transaction Name: [TransactionWriteDataTransaction]
Error code: [3] [A connection error occurred during database access.]
Error code (extended): [604]
Description: [SQLState: UNKNOWN
Error generated from Oracle: Unknown, Source Exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
]

 

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!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.