IAM-1020021 Unable to execute job : Refresh Role Memberships with Job History Id:xxxxx

Refresh Role Memberships schedule job is failing

 

 

 

 

 

 

 

 

 

The schedule job "Refresh Role Memberships" is failing every time. The following error is seen in the log file.

[2022-05-17T11:39:49.111+00:00] [oim_server1] [WARNING] [] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 8d6118d3-c0fd-4fd4-8f76-d7cce785005b-000000ae,1:17] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] IAM-1020021 Unable to execute job : Refresh Role Memberships with Job History Id:148269[[
oracle.iam.platform.utils.SuperRuntimeException: Role membership rule evaluation failed for following roles :497
at oracle.iam.identity.scheduledtasks.RefreshRoleMembershipsTask.execute(RefreshRoleMembershipsTask.java:181)

 

Troubleshooting:

 

checked UGP and DYN_EVAL_CHANGELOG tables
UGP table does not have a record for UGP_KEY=497;
DYN_EVAL_CHANGELOG have a record for ENTITY_ID=497; 

Solution:

There is a record for 497 Entity_ID in DYN_EVAL_CHANGELOG table for relationship_type = ROLE_USER.
So, one can take backup of db and delete that entry.
Rerun Refresh Role Memberships job to resolve the issue.