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

Típus: Hírek
Publikálva: 15/07/2019
További hibaüzenetek:
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

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

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


A megoldást a következő IGL verziók telepítése jelenti:
- RSA Identity Governance & Lifecycle 7.1.0 P08
- RSA Identity Governance & Lifecycle 7.1.1 P02


A teljes cikk elréhető az alábbi linken:
https://community.rsa.com/docs/DOC-105931

Kapcsolat

+36 1 371 2 370
rsa.ecs.hu@arrow.com

 CL Social Media Icon - Facebook 40px CL Social Media Icon - Twitter 40px CL Social Media Icon - Blog 40px  YouTube_40