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

Document created by RSA Customer Support Employee on Mar 1, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034893
Applies ToRSA Product Set: RSA Identity Governance and 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 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