ORA-01013: user requested cancel current operation
The system hangs on opening the Operations landing page to view the logs. An error message displays on the Tracer after 30 seconds. Post this, the landing page displays and the operator is able to proceed to the logs.
FAIL: There was a problem getting a list: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation
Steps to Reproduce
- Log in to Designer Studio.
- Navigate to Designer Studio > Menu > System > Operations > Logs.
- Open the Operations Landing Page.
A defect or configuration issue in the operating environment.
Multiple tabs are present on the Operations landing page. One of the tables queries a table with 17 million rows of old or stale data. This caused the query to take longer than 30 seconds to execute.
As a local-change, clear the old or stale data from the database table.
0% found this useful