Cannot Create Roles

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Unable to create new roles. The error appears in the UI:
System Error. Please contact system administrator.

The excerpt of the error from the APP logs:

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("CLARITY"."SRM_RESOURCES"."PERSON_TYPE") 

Caused by: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("CLARITY"."SRM_RESOURCES"."PERSON_TYPE")

Cause

This can happen if the "person_type" attribute is null in the odf_default_overrides table. One reason this can happen is due to perform the below steps:

1. Go to Administration->Objects->Resource
2. Enter a default value for Person Type and Save
3. Delete the default value entered in Person Type and Save 
    

Environment

Clarity PPM 15.6.1 and higher

Resolution

Step 1: Run the below query to verify there is a null value for 'person_type':

Select * from odf_default_overrides where object_code='resource' and attribute_code='person_type'; 

If the results return with a blank value for 'person_type', proceed to Step 2

Step 2: Create backup of odf_default_overrides table

Step 3: Run below query: 

delete from odf_default_overrides where object_code='resource' and attribute_code='person_type' and value is NULL; 
Commit; 

Step 4: Flush PPM cache (or restart app services) 

Steps to flush PPM cache: 

a. Login to the Clarity PPM application as an admin user 
b. Modify the URL field to: http://<svr>/niku/nu#action:security.caches 
c. Click Caches tab, click FLUSH ALL button