000034893 - Indirect relationship processing fails after installing RSA Identity Lifecycle & Governance 7.0.1 P02

Document created by RSA Customer Support Employee on Mar 1, 2017Last modified by RSA Customer Support on Nov 18, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000034893
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 7.0.1 P02 
 
IssueAccount data collectors and entitlement data collectors may fail on the indirect relationship processing task if you have recently applied 7.0.1 P02.
 
User-added image

The following errors can be seen in the aveksaServer.log which can be retrieved from Admin > System > Server Nodes, under Logs. 

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

Another variation of the error may look like this: 

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
CauseThis occurs because of data duplication in the T_CE_EXPLICIT_RELATIONS table.
ResolutionRun the following query as AVUSER using a SQL client such as SQL Developer. If the query returns any output, please contact RSA Customer Support for resolution and mention this article. 

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;

Attachments

    Outcomes