ORA-30926: 'Unable to get a stable set of rows in the source tables' at AVUSER.ARCHIVEPURGE_PKG line 839  creating an archive in RSA Identity Governance & Lifecycle 
Originally Published: 2018-02-23
Last Modified: 2022-06-20
Article Number
000041999
Applies To
RSA Product Set: Identity Governance & Lifecycle 
RSA Version/Condition: 7.1.0, 7.1.1

 
Issue
When creating an archive .dmp file in RSA Identity Governance & Lifecycle using the Data Archiving utility (Admin > System > Data Management tab > Create under Archiving), the attempt fails immediately and the aveksaServer.log has the following error: 
 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)

Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment.
 
Cause
This is a known issue reported in engineering ticket ACM-84609.
Resolution
This issue is resolved in the following RSA Identity Governance & Lifecycle versions and/or patch levels:
  • RSA Identity Governance & Lifecycle 7.1.0 P01
  • RSA Identity Governance & Lifecycle 7.1.1 
Workaround
There is a cleanup script that can workaround this issue. Please contact RSA Identity Governance & Lifecycle Support for the cleanup script and mention this RSA Knowledge Base Article ID 000036071 for reference.  
 

Related Articles

Trending Articles

Don't see what you're looking for?