000036071 - 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 

Document created by RSA Customer Support Employee on Mar 6, 2018Last modified by RSA Customer Support Employee on Dec 12, 2019
Version 14Show Document
  • View in full screen mode

Article Content

Article Number000036071
Applies ToRSA Product Set: Identity Governance & Lifecycle 
RSA Version/Condition: 7.1.0, 7.1.1

IssueWhen 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.
CauseThis is a known issue reported in engineering ticket ACM-84609.
ResolutionThis 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 
WorkaroundThere 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.