Unification fails with ORA-30926: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line 60 in RSA Identity Governance & Lifecycle
Originally Published: 2017-09-27
Article Number
Applies To
RSA Version/Condition: 7.0.2
Issue
The aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log) shows:
9/25/2017 21:23:32.574 INFO (Exec Task Consumer#4) [com.aveksa.server.xfw.UnificationExecutor] Failed method=Process subTask=CompleteMergeTasks Default User Population, nnnnn 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 60 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) Caused by: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
Cause
This is a known issue reported in engineering ticket ACM-76856.
Resolution
- RSA Identity Governance & Lifecycle 7.0.2 P04
- RSA Identity Governance & Lifecycle 7.1.0 P01
Related Articles
RSA Identity Governance & Lifecycle unification fails with ORA-30926: unable to get a stable set of rows in the source tab… 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 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 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 "ORA-30926: Unable to get a stable set of rows in the source tables" error when trying to modify a role in RSA Identity Go… Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
