Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1

[#1]

Article Number

000037708

Applies To

RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1
 

Issue

The RSA Identity Governance & Lifecycle Data Purging job run fails, as shown:

Image description
 

The database logs for the job run show the following errors:

Error Stack Trace: ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 73
ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 30
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1241

and

Error Stack Trace: ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1258
ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 73
ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 30
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1241
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038

The aveksaServer.log shows the following stack trace:
 

06/11/2019 08:40:49.018 INFO (ThreadPool-8) [com.aveksa.server.xfw.ExecutionRequest] Notify execution request for ExecutionContext[ID=173305 Type=DataPurging Status=New NumTasks=1 tasks=ExecutionTask[TaskID=434535 RunID=173305 Source=1 Type=DataPurging Status=New]]
 06/11/2019 08:40:49.023 INFO (Thread-13 (ActiveMQ-client-global-threads-632342923)) [com.aveksa.server.xfw.ExecutionServiceProvider] Notified execution request for ExecutionContext[ID=173305 Type=DataPurging Status=New NumTasks=1 tasks=ExecutionTask[TaskID=434535 RunID=173305 Source=1 Type=DataPurging Status=New]]
 06/11/2019 08:40:49.186 INFO (Exec Task Consumer#3 - Main) [com.aveksa.server.xfw.TaskExecutor] Setting thread ThreadExec Task Consumer#3 - Main,5,Execution Task on 834357487 method=Execute 
 06/11/2019 08:40:57.879 INFO (Exec Task Consumer#3 - Main) [com.aveksa.server.db.persistence.PersistenceServiceProvider] executeCallableStatement giving up after hitting SQLException: ORA-20001: No jobs were found to delete.
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 130
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1073
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1258
 ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 73
 ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 30
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1241
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 127
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 93
 ORA-06512: at line 1
...
 Caused by: Error : 20001, Position : 0, Sql = BEGIN Data_Pruning_Pkg.Main(:1 ,:2 ,:3 ); END;, OriginalSql =
{call Data_Pruning_Pkg.Main(?,?,?)}
, Error Msg = ORA-20001: No jobs were found to delete.
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 130
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1073
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1258
 ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 73
 ORA-06512: at "AVUSER.SPWP_DELETE_JOBS", line 30
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1241
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038
 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1038
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 127
 ORA-06512: at "AVUSER.DATA_PRUNING_PKG", line 93
 ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
 ... 30 more

Please refer to article 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log for your specific deployment.

Cause

This is a known issue reported in engineering ticket ACM-98953.


 

Resolution

This issue is resolved in the following RSA Identity Governance & Lifecycle patches:

• RSA Identity Governance & Lifecycle 7.1.0 P08
• RSA Identity Governance & Lifecycle 7.1.1 P02