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

Document created by RSA Customer Support Employee on Jul 9, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037708
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1
 
IssueThe 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.
CauseThis is a known issue reported in engineering ticket ACM-98953.


 
ResolutionThis 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

Attachments

    Outcomes