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
Last Modified: 2022-06-20
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… 344Number 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… 150Number of Views Unification fails with ORA-30927: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line… 146Number of Views ORA-30926: 'Unable to get a stable set of rows in the source tables' at AVUSER.ARCHIVEPURGE_PKG line 839 creating an arch… 196Number 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… 232Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?