ORA-01013 Error During Normal UCM Operations (Doc ID 866645.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 to 11.1.1.5.0 [Release 10gR3 to 11g]
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)

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms