IBM Support

Error: Ora 01013 User requested Cancel of current operation

Troubleshooting


Problem

Error Error #-9 DMS-E-GENERAL, A general exception had occurred during operation 'fetch'. ORA-01013 User requested cancel of current operation. when running a report against Oracle.

Resolving The Problem

From the Oracle Error message help file:

ORA-01013: user requested cancel of current operation

Cause: The user interrupted an Oracle operation by entering , ControlC, or another canceling operation. This forces the current operation to end. This is an informational message only.
Action: Continue with the next operation. end of processing

This error may be due to an internal Sql*Net parameter which times out
the connection. This is called sqlnet.expired.time which logs out users after a set time. Contact your DBA to reset this parameter and retry.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 2.0;Impromptu 3.03;Impromptu 3.04;Impromptu 3.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

51252

Document Information

Modified date:
15 June 2018

UID

swg21351986