AnsweredAssumed Answered

Indirect Relationship Processing/Role Import Error

Question asked by Christopher Smith on Aug 4, 2020
Latest reply on Aug 12, 2020 by Christopher Smith


Currently on 7.1.1 P07.  This issues manifested itself over 1 week after patch installation.


Indirect Relationship Processing fails after every collection.  ADC or EDC, does not matter Collector type.


This started happening after a user on my team attempted to import a role to production.  The role was originally export from production, and attempted to be re-imported.  There was a removal of 1 entitlement after the role was exported.  We have done this multiple times before to remove an entitlement that was associated to a Deleted collector.


During the Role Import run, the second step fails per attached screenshot.  I also see an Admin error as pasted below:


Error while exploding and compute metrics of imported roles: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 5334 ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 4592 ORA-06512: at line 1


Has anyone seen this before?  When collectors collect now, Indirect Relationship Processing fails.  User accounts are no longer having entitlements mapped to them, therefore the access is not showing up on the user's identity records.  Indirect Relationship Processing is also failing as it relates to orphan mapping.  Attached picture of recent successful collection and failed Indirect Relationship Processing.  The EDC says aborted, however a following collection had the collector succeed with the Indirect Relationship Processing failed again.


Thank you,