Message: ORA-01013: user requested cancel of current operation
Message: ORA-01013: user requested cancel of current operation is observed.
Message: ORA-01013: user requested cancel of current operation.
Steps to Reproduce
The root cause of this problem is defect/misconfiguration in the operating environment.
The primary key on table pr_sys_ruleset_index, a table involved in managing the application ruleset cache, was missing.
Without this index access to the cache is slowed and duplicates are allowed to be added.
The SQL causing the problem is as follows:
FROM PRPCRULES.pr_sys_ruleset_index "i" WHERE "i".pzRuleSetListHash = ?
INNER JOIN resolved_rules_pc0 "resolved_rules_pc0" ON ("PC0".pzInsKey = "resolved_rules_pc0".pzInsKey) INNER JOIN PRPCRULES.pr_index_warnings "W" ON ( ( "PC0".PZINSKEY = "W".PXREFERENCINGRULEINSKEY ) AND "PC0".PXOBJCLASS = ? AND "W".PXOBJCLASS = ? ) WHERE ( "W".PXWARNINGCREATEOPERATOR = ? AND "W".PXWARNINGCREATEDTIME BETWEEN ? AND ? AND "PC0".PYRULESET NOT LIKE ? ) GROUP BY "W".PXWARNINGSEVERITY ORDER BY 1 ASC
The above SQL has been edited for clarity. Use this to identify whether you are experiencing the same issue.
If it is determined to be the same issue using the SQL signature above as a reference, then review whether the primary key index is in place on table pr_sys_ruleset_index .
This issue is resolved through the following local-change:
Add the primary key index.
ADD CONSTRAINT pr_sys_ruleset_index_PK PRIMARY KEY
0% found this useful