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 MAY 02, 2023

Applies to:

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

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