ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Cannot Create Roles
book
Article ID: 132590
calendar_today
Updated On:
Products
Clarity PPM On PremiseClarity PPM SaaS
Issue/Introduction
Unable to create new roles. The error appears in the UI: System Error. Please contact system administrator.
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:
Go to Administration->Objects->Resource
Enter a default value for Person Type and Save
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