000036071 - Unable to get a stable set of rows in the source tables at AVUSER.ARCHIVEPURGE_PKG line 839  when attempting to create an archive in RSA Identity Governance & Lifecycle 7.1.0

Document created by RSA Customer Support Employee on Mar 6, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036071
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0
IssueAttempting to create an archive dmp file in RSA Identity Governance & Lifecycle 7.1.0 fails instantly with 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)

The archive job fails instantly when attempting to create it.
CauseThe archive meta data was not properly updated for a fresh install. This has been reported in engineering ticket ACM-84609.
ResolutionThe issue is resolved in 7.1.0 P01
  1. From the Data Management tab the Failed archive should be highlighted.  Delete the archive.  This will rollback the start of that archive and clear all the tables. Wait until the archive deletion process is successful.
  2. Run the attached ArchiveMetadataUpd_ACM-84609.sql:
    1. Place the ArchiveMetadataUpd_ACM-84609.sql file into a directory.  In the example below, the PL/SQL block was placed in /home/oracle.
    2. Login as the oracle user.
    3. Run the PL/SQL block:

su - oracle
cd /home/oracle
sqlplus avuser/<avuser's_password> @ArchiveMetadataUpd_ACM-84609.sql

  1. Try running the archive again.