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

4 years ago

Originally Published: 2018-02-23

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.

Don't see what you're looking for?

Related Articles

Trending Articles