Resource / Role does not get created

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

It is noticed that Resources or Roles cannot be created from the 'Home -> Resources' page, by clicking on the 'New' button. Although the page to fill in the details (Layout:Create) is shown, after clicking on the 'Save' button, the data is lost. A page that is not as per the configurations defined at Layout:Edit is displayed.

Following error is noticeable in the app-ca.log:

ERROR 2024-03-18 11:31:57,917 [http-nio-8080-exec-6] service.ODFService (none:none:none:none) (ece95d7a-ae2f-40e4be5cdb8c) processRequest Exception
java.lang.NullPointerException
 at com.niku.odf.object.ODFAbstractObjectImpl.setupAutonumberedAttributes(ODFAbstractObjectImpl.java:3507)

Cause

Orphan records in auto-numbering related tables in the DB.

Resolution

1. Check for attribute records in the ODF_ATTRIBUTE_AUTONUMBERING table against object_code 'resource'
2. Compare the list here with attributes available in the 'Resource' object. Move onto the next steps only if you find that there is an attribute missing in the 'Resource' object
3. Recreate the attribute referred to by the table in step 1. Notice that the auto-numbering is already enabled against this attribute. The attribute would be of data type 'String'
4. Remove auto-numbering from this attribute
5. Remove the attribute again from the object.