ORA-01013 Error During Normal UCM Operations
(Doc ID 866645.1)
Last updated on DECEMBER 06, 2018
Applies to:
Oracle WebCenter Content - Version 10.1.3.3.0 to 11.1.1.5.0 [Release 10gR3 to 11g]Oracle WebCenter Content - Version 11.1.1.6.0 to 11.1.1.6.0 [Release 11g]
Oracle WebCenter Content - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]
Oracle WebCenter Content - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.
Symptoms
This is a generic Oracle Database error encountered when a query is taking too long to execute.
The message "user requested cancel of the current operation" is simply referring to the system timing out the query before it has a chance to complete. The timeout is intentional so the query doesn't continue indefinitely and utilize system resources.
(Below stack example is from UCM 10gR3. 11g stack will differ):
Event generated by user 'sysadmin' at host '<machinename>'.
intradoc.common.ServiceException: ORA-01013: user requested cancel of current operation
intradoc.data.DataException: ORA-01013: user requested cancel of current operation
java.sql.SQLException: ORA-01013: user requested cancel of current operation [ Details ]
An error has occurred. The stack trace below shows more information.
!csUserEventMessage,sysadmin,<machinename>!$!syExceptionType2,intradoc.common.ServiceExcepti
on,ORA-01013: user requested cancel of current
operation<br>!syExceptionType2,intradoc.data.DataException,ORA-01013: user requested cancel
of current operation<br>!syExceptionType2,java.sql.SQLException,ORA-01013: user requested
cancel of current operation<br>
intradoc.common.ServiceException: ORA-01013: user requested cancel of current operation
at intradoc.data.WorkspaceTransactionWrapper.beginTransaction(WorkspaceTransactionWrapper.java:52)
at intradoc.server.ServiceRequestImplementor.beginTransaction(ServiceRequestImplementor.java:285)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1179)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1114)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: intradoc.data.DataException: ORA-01013: user requested cancel of current operation
at intradoc.jdbc.JdbcWorkspace.beginTranEx(JdbcWorkspace.java:1079)
at intradoc.data.WorkspaceTransactionWrapper.beginTransaction(WorkspaceTransactionWrapper.java:47)
... 9 more
Caused by: java.sql.SQLException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4086)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4234)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
at intradoc.jdbc.JdbcWorkspace.beginTranEx(JdbcWorkspace.java:1061)
intradoc.common.ServiceException: ORA-01013: user requested cancel of current operation
intradoc.data.DataException: ORA-01013: user requested cancel of current operation
java.sql.SQLException: ORA-01013: user requested cancel of current operation [ Details ]
An error has occurred. The stack trace below shows more information.
!csUserEventMessage,sysadmin,<machinename>!$!syExceptionType2,intradoc.common.ServiceExcepti
on,ORA-01013: user requested cancel of current
operation<br>!syExceptionType2,intradoc.data.DataException,ORA-01013: user requested cancel
of current operation<br>!syExceptionType2,java.sql.SQLException,ORA-01013: user requested
cancel of current operation<br>
intradoc.common.ServiceException: ORA-01013: user requested cancel of current operation
at intradoc.data.WorkspaceTransactionWrapper.beginTransaction(WorkspaceTransactionWrapper.java:52)
at intradoc.server.ServiceRequestImplementor.beginTransaction(ServiceRequestImplementor.java:285)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1179)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1114)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: intradoc.data.DataException: ORA-01013: user requested cancel of current operation
at intradoc.jdbc.JdbcWorkspace.beginTranEx(JdbcWorkspace.java:1079)
at intradoc.data.WorkspaceTransactionWrapper.beginTransaction(WorkspaceTransactionWrapper.java:47)
... 9 more
Caused by: java.sql.SQLException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4086)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4234)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
at intradoc.jdbc.JdbcWorkspace.beginTranEx(JdbcWorkspace.java:1061)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |