Fail to assign/unassign provisioning roles on users with exception PxSystemException: Error creating data for corresponding events

Products

• CA Identity Suite

Issue/Introduction

Seeing the following error " PxSystemException: Error creating data for corresponding events" in the log while assigning/unassigning provisioning roles, with the task failing to complete

Environment

Standalone/Virtual Appliance Identity Manager 14.5

Cause

Corrupted objectstore after failed import roledef.xml

Resolution

1. Back up  PX_When  and PX_Policy tables
   
   
2. Once the tables are backed up:
   
   
   1. Run a query on the PX_When table to retrieve all rows that have EVENTNAME that contains the string: Synchronize.
      The query should be something like:
      
      SELECT * from PX_WHEN where EVENTNAME like '%synchronize%'
      
      
   2. For each returned row: look at the POLICYUN value and find out if it exists in the PX_Policy table (in the UNIQUE_NAME column).
      
      
   3. If the POLICYUN value does not exist in the PX_POLICY table, please remove this line from the PX_WHEN table.
      
      
   4. If the POLICYUN value is NULL, please remove this line from the PX_WHEN table.
      
      This procedure will clear up any leftover dangling policy objects that might have been left in the database associated to an event without a real policy to be fired, which might lead to the error at the top
3. Restart IDM