| Issue | RSA Identity Governance & Lifecycle Database Purging may fail after Data Archiving.
The Data Management tab on the Admin System menu shows the Archive Status as Completed but the Purge Status as Failed. (Additional information may be displayed if the "Error Message" column is displayed.)
The following WARN and ERROR level messages are logged in the aveksaserver.log file
05/21/2020 16:27:28.812 WARN (Exec Task Consumer#3 - Main) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 30926, SQLState: 99999
05/21/2020 16:27:28.812 ERROR (Exec Task Consumer#3 - Main) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 839
ORA-06512: at line 1
05/21/2020 16:27:28.827 ERROR (Exec Task Consumer#3 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=58858 RunID=25582 Source=68 Type=DataArchiving Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 839
ORA-06512: at line 1
at com.aveksa.server.xfw.DataArchivingTaskExecutor.executeTask(DataArchivingTaskExecutor.java:62)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 839
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1548)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1480)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:245)
at com.aveksa.server.xfw.DataArchivingTaskExecutor.executeTask(DataArchivingTaskExecutor.java:59)
... 3 more
Caused by: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 839
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
at com.aveksa.server.db.persistence.work.PersistenceServiceBaseWork.executeCallableStatement(PersistenceServiceBaseWork.java:36)
at com.aveksa.server.db.persistence.work.StoredProcedureCallWork.execute(StoredProcedureCallWork.java:80)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
at org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2134)
at org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2131)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:332)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2153)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2138)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1526)
... 6 more
Caused by: Error : 30926, Position : 0, Sql = BEGIN ArchivePurge_Pkg.archiveData(:1 ,:2 ,:3 ); END;, OriginalSql = {call ArchivePurge_Pkg.archiveData(?,?,?)}, Error Msg = ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 839
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 30 more
The "Database Logs for Run" for the Data Archive task shows the following event.
Error archiving data from T_AV_RULES
"Error Stack Trace: ORA-06512: at ""AVUSER.ARCHIVEPURGE_PKG"", line 975
ORA-06512: at ""AVUSER.ARCHIVEPURGE_PKG"", line 740"
|
on Dec 18, 2020