ORA-01400: cannot insert NULL into ("IDAM"."RUNTIMESTATUSDETAIL12"."EVENTID") ORA-06512: at "IDAM.INSERTRUNTIMESTATUSDETAIL"" after upgrade to 14.5

Products

• CA Identity Suite

Issue/Introduction

Upgraded from 14.4 to 14.5.  When cleanup sunbmitted tasks we see:

"java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("IDAM"."RUNTIMESTATUSDETAIL12"."EVENTID")
ORA-06512: at "IDAM.INSERTRUNTIMESTATUSDETAIL""

Environment

Identity Manager

14.5 Standalone

Cause

Post-upgrade Documentation. 

Role Definitions

Role definitions were not upgraded after IDM upgrade. 

 

Resolution

Access Management Console. Go to Environments\xxx\Roles. Check the box on Upgrade-14-to-14.X-RoleDefinitions

Upgrade-14-to-14.X-RoleDefinitions  >>>>  Upgrade-14-to-14.X-RoleDefinitions-ProvisioningOrganization.xml

Once completed the Oracle errors no longer occurred 

Import the remaining role definitions where the Installed version does not match Version column.

Resolution 2:

This message can also occur if the wrong Role Definition is selected after the upgrade in the management console.  If you do not use Provisioning but select "Upgrade-14-to-14-X-RoleDefinition-ProvisioningOrganization.xml and try to import, this Oracle message will display.  Once you select the proper XML, in this case they were not using Provisioning so they needed to use "Upgrade-14-to-14-X-RoleDefinition-Organization.xml" (No provisioning). It updated without issue and the error was resolved.