- Product: RSA Identity Governance & Lifecycle
- Version: 7.0.2, 7.1.0, 7.1.1
- Component: Indirect Relationship Processing, Account Data Collectors (ADCs)
- Database: Oracle Database
The Indirect Relationship Processing task for Account Data Collectors (ADCs) fails during Group collection.
Observable symptoms:
- The Indirect Relationship Processing task shows a status of Failed in the UI under Admin > Monitoring > Run ID
- The
aveksaServer.logfile containsORA-30926andORA-06512errors
Task Details
com.aveksa.server.xfw.ExecutionException: 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.CE_USERS", line 103
ORA-06512: at "AVUSER.CE_USERS", line 143
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 435
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 114
ORA-06512: at line 1
The following text is logged to the aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log):
ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor]
Failed method=Execute ExecutionTask[TaskID=XXXXXX RunID=XXXXXX Source=XXXX
Type=EntitlementExplosionProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: 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.CE_USERS", line 30
ORA-06512: at "AVUSER.CE_USERS", line 139
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 435
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 114
ORA-06512: at line 1
RSA Identity Governance & Lifecycle fails to resolve Account-to-Group membership as a unique entitlement when an account belongs to a group through more than one path in the same ADC run.
This occurs because the Indirect Relationship Processing step — which is shared across multiple ADC runs — cannot handle duplicate Account-to-Group relationships resolved within the same run.
This error occurs because of data duplication in the T_CE_EXPLICIT_RELATIONS table.
This is a known issue reported in engineering ticket ACM-71877.
This issue is resolved in the following RSA Identity Governance & Lifecycle versions:
- RSA Identity Governance & Lifecycle 7.0.2 P14
- RSA Identity Governance & Lifecycle 7.1.0 P08
- RSA Identity Governance & Lifecycle 7.1.1 P02
- RSA Identity Governance & Lifecycle 7.2.0
Run the following query as avuser using a SQL client such as SQL Developer. If the query returns any output, please contact RSA Support and mention this RSA Knowledge Base Article ID 34893 for reference.
select * from t_ce_explicit_relations where (entitled_id, entitled_type, entitlement_id, entitlement_type) in (select entitled_id, entitled_type, entitlement_id, entitlement_type from t_ce_explicit_relations group by entitled_id, entitled_type, entitlement_id, entitlement_type having count(*) > 1) order by entitled_type, entitled_id, entitlement_id;
Related Articles
Indirect Relationship Processing fails with ORA-30926 and 'ORA-06512: at "AVUSER.CE_USERS" ' errors when collecting Groups… 412Number of Views How to install Access Fulfillment Express (AFX) for use with RSA Identity Governance & Lifecycle 1.32KNumber of Views Running AFX Connectors fail, connectors remain in "Not Deployed" state in RSA Governance & Lifecycle 1.16KNumber of Views Clean Up Unresolvable Users Manually 322Number of Views After restarting RSA Identity Governance & Lifecycle, the browser shows an Initialization Status screen with connection er… 399Number 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-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide