Records Management Batch Services Throws ORA-01013: user requested cancel of current operation Error and Retention Items are Not Processing
(Doc ID 2967859.1)
Last updated on JULY 20, 2024
Applies to:
Oracle WebCenter Content: Records - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
Batch Services throws error and retention items are not processing.
Run batch services for WCCREC from 'Records > Run Batch Services > Run ALL' ends with error:
ERROR
-----------------------
java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation. Error : 1013, Position : 36, Sql = SELECT DISTINCT dDispositionID FROM ContentRetentionSteps WHERE dActionState='N' AND dIsFrozen=0 AND dIsPrevStepPending=0 AND dDueDate <= TO_TIMESTAMP ('2023-07-03 10:19:01.846', 'YYYY-MM-DD HH24:MI:SS.FF'), OriginalSql = SELECT DISTINCT dDispositionID FROM ContentRetentionSteps WHERE dActionState='N' AND dIsFrozen=0 AND dIsPrevStepPending=0 AND dDueDate <= {ts '2023-07-03 10:19:01.846'}, Error Msg = ORA-01013: user requested cancel of current operation.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |