ORA-01013 user requested cancel of current operation
Hi,
We are getting this error when application is trying to insert into table. From database side I don't find any locks, blocing locks or high number of sessions. Not sure where to start to analyze the issue. Please find the error below, and please let me know how to analyze the error.
at abcde.epi.datamanager.jdbc.JdbcConnector.prepareAndExecute(JdbcConnector.java:3545)
at abcde.epi.datamanager.jdbc.JdbcConnector.executeOperationsSqlBatch(JdbcConnector.java:3629)
at abcde.epi.datamanager.jdbc.JdbcConnector.batchCommit(JdbcConnector.java:1139)
at abcde.epi.datamanager.DataStore.batchCommit(DataStore.java:2427)
at abcde.epi.datamanager.DataManagerCls.batchCommit(DataManagerCls.java:1291)
at abcde.epi.datamanager.Transaction.writeTransaction(Transaction.java:2511)
at abcde.epi.datamanager.Transaction.continueCommit(Transaction.java:1461)
at abcde.epi.datamanager.Transaction.continueCommit(Transaction.java:1419)
at abcde.epi.session.EpiSessionContext.beginCommit(EpiSessionContext.java:3886)
at abcde.epi.datamanager.Transaction.prepareForCommit(Transaction.java:1282)
... 50 more
Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
ORA-06512: at line 2
Database version is 11.2.0.3
Thanks and Regards
Venkata