Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1
3 years ago
Originally Published: 2019-07-09
Article Number
000040945
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:
 
User-added image
 

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

Related Articles

Trending Articles

Don't see what you're looking for?