IM Database Issue "ORA-01013: User Requested Cancel Of Current Operation "

News Knowledge Base
1

Resolution for IM Database issue "ORA-01013: user requested cancel of current operation" .

This may have been intentional if decided to cancel running the code mid-operation by pressing Control+C or by some front-end application. Otherwise, it may have been caused by a timeout in a SQL pass through query.

The most common cause of ORA-01013 is timeouts. Timeouts can be a little more tricky to identify because they may not be specifically reported in connection with ORA-01013. If a timeout is causing the ORA-01013 error in a SQL pass-through query, the properties in the timeout parameter should be altered to a higher value.

If Open Data Base Connectivity (ODBC) is being used in Oracle, there is option of enabling timeouts so that this error message does not get displayed again.

To enable timeouts, go to the Control Panel and click on Administrative Tools.

  1. In the Administrative Tools dialog box, clock data sources (ODBC).
  2. Select the ODBC connection.
  3. On the configuration page, look for the box next to “Enable ODBC Timeout” and make sure that is box is unchecked. This will prevent further timeouts from occurring.
Also read the blog - User Requested Cancel Of Current Operation Tips .