Indirect Relationship Processing fails with ORA-30926 and 'ORA-06512: at "AVUSER.CE_USERS" ' errors after Migration to 7.0.1 P02 of RSA Identity Governance & Lifecycle ORA-30926
Originally Published: 2017-02-28
Article Number
Applies To
RSA Version/Condition: 7.0.1 P02
Issue
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
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
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 if you are on a WildFly cluster or a non-WildFly platform. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs).
Cause
This is a known issue reported in engineering ticket ACM-71877.
Resolution
- RSA Identity Governance & Lifecycle 7.0.1 P03
- RSA Identity Governance & Lifecycle 7.0.2 P01
- RSA Identity Governance & Lifecycle 7.1.0
Workaround
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;
Notes
- 000038826 -- Indirect Relationship Processing fails with ORA-30926 and 'ORA-06512: at "AVUSER.CE_USERS" ' errors when collecting Groups in RSA Identity Governance & Lifecycle
- 000034775 -- Indirect Relationship Processing fails with 'ORA-12899 value too large for column' error in RSA Identity Governance & Lifecycle
