RSA Identity Governance & Lifecycle unification fails with ORA-30926: unable to get a stable set of rows in the source tables, ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47
Originally Published: 2018-03-09
Article Number
Applies To
RSA Version/Condition: 7.0.2, 7.1.0
Issue
RSA Identity Governance & Lifecycle unification fails with the following error in the aveksaServer.log file:
05/03/2018 14:10:51.048 INFO (Exec Task Consumer#1) [com.aveksa.server.xfw.UnificationExecutor] Failed method=Process subTask=CompleteMergeTasks Default User Population, 1026095
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.UNFC_PROCESSOR", line 47
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1601)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1459)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267)
at com.aveksa.server.xfw.UnificationExecutor.executeTask(UnificationExecutor.java:122)
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:745)
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.UNFC_PROCESSOR", line 47
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1601)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1459)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267)
at com.aveksa.server.xfw.UnificationExecutor.executeTask(UnificationExecutor.java:122)
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:745)
Cause
Resolution
This issue is resolved in the following RSA Identity Governance & Lifecycle patches:
- RSA Identity Governance & Lifecycle 7.0.2 P07
- RSA Identity Governance & Lifecycle 7.1.0 P01
The fix works as follows:
In versions where the patch has been applied, if the Identity Data Collectors (IDCs) have been collected before configuring the unification, then the unification screen will prevent the join from being created.
If the IDCs have not been collected before the unification join has been created, the unification change will be allowed, but duplicate users will be rejected during unification.
If the IDCs have not been collected before the unification join has been created, the unification change will be allowed, but duplicate users will be rejected during unification.
NOTE: If you still encounter this exact error after applying the above patches, please see RSA Knowledge Base Article 000037875 -- Unification fails with ORA-30926: unable to get a stable set of rows in the source tables, ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47 in RSA Identity Governance & Lifecycle.
Workaround
- This issue may be resolved by identifying and removing the duplicate users from the source data. Contact RSA Customer Support for assistance if you are unable to identify which users are not uniquely identified.
- Alternatively, you may change the unification configuration to use a different unique identifier for the user join.
Notes
Unification issues may appear similar but have different causes. If the error does not match exactly, suspect a different issue.
See article 000035588 - Identity Data Unification failing with "ORA-30926: unable to get a stable set of rows" in RSA Identity Governance and Lifecycle 7.0.2 for similar errors with different causes.
Related Articles
Unification fails with ORA-30926: unable to get a stable set of rows in the source tables, ORA-06512: at "AVUSER.UNFC_PROC… Number of Views Unification fails with ORA-30926: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line… Number of Views Unification fails with ORA-30927: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line… Number of Views RSA Identity Governance & Lifecycle fails to start with "Unable to get avdb connection" message Number of Views Segregation of Duties (SOD) Rule fails with error 'ORA-30926: unable to get a stable set of rows in the source tables' err… Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
