API-1019 error when converting Idea or creating Project

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When converting an Idea to a Project in Modern UX or when trying to create a new Project, you receive an API-1019 error.

The app-ca.log file shows errors similar to the following:

ERROR xx-xx-xx xx:xx:xx,xxx [x] niku.xql2 (clarity:x:x:PPM_REST_API) Internal Processing exception
java.lang.Exception: User 5xxxxxx not in system. Cannot grant right
    at com.niku.xql2.pmd.rules.INVInvestmentsRule.onPostUpdate(INVInvestmentsRule.java:580)

ERROR xx-xx-xx xx:xx:xx,xxx [x] niku.xql2 (clarity:x:x:projmgr.projectNewPost) (x) Internal Processing exception
java.lang.Exception: User 5xxxxxx not in system. Cannot grant right
    at com.niku.xql2.pmd.rules.INVInvestmentsRule.onPostUpdate(INVInvestmentsRule.java:597)

Cause

The ODF_DEFAULT_OVERRIDES table has an attribute with a default value.

Resolution

The default value needs to be cleared.

1. If the attribute is not known, use the following query to identify any out-of-the-box attribute that have this default value:
   SELECT *
FROM ODF_DEFAULT_OVERRIDES
WHERE OBJECT_CODE = 'project'
AND VALUE = 5xxxxxx
   (replace 5xxxxxx with the value found in the logs)
2. Use the following query to identify any custom attributes that have this default value:
   SELECT OBJECT_NAME, COLUMN_NAME, DEFAULT_VALUE
FROM ODF_CUSTOM_ATTRIBUTES
WHERE OBJECT_NAME = 'project'
AND DEFAULT_VALUE = '5xxxxxx'
3. Go to Classic Administration > Studio > Objects > Project > Attributes > [attribute] (find by the attribute_id returned by the previous query).
4. The default value may show empty. Select a new default value, and save.
5. The new default value may be removed if it is not needed (remove and save again).