Convert Idea to Project error API-1019

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When converting an Idea to a project in Modern UX, I receive an API-1019 error
If I try to convert the same in the Classic Interface I get a system error
However, I am able to convert the Idea to an Application

The app-ca.log file shows the following error:
ERROR 2023-02-22 08:32:53,842 [http-nio-8080-exec-90] ppm.rest (clarity:admin:6497678__B495261C-E6B6-4E8C-BD51-1BAB5CA5213E:PPM_REST_API) Exception processing request for resource [convertIdea], query string [/private/convertIdea]
java.lang.NullPointerException
    at com.ppm.rest.function.ConvertIdeaFunctionResource.convertIdeaToProject(ConvertIdeaFunctionResource.java:242)

ERROR 2023-02-22 08:33:55,568 [http-nio-8080-exec-89] niku.xql2 (clarity:admin:6497678__B495261C-E6B6-4E8C-BD51-1BAB5CA5213E:PPM_REST_API) Internal Processing exception
java.lang.Exception: User 5032041 not in system. Cannot grant right
    at com.niku.xql2.pmd.rules.INVInvestmentsRule.onPostUpdate(INVInvestmentsRule.java:580)

Cause

The odf_default_overrides had a custom attribute (target_project_manager) entry with a default value 

The default value was referenced on the log:

java.lang.Exception: User 5032041 not in system. Cannot grant right

Resolution

The default will need to be cleared from the database. The following query can be used for this: 

delete from odf_default_overrides
where object_code='<object_id>'
and attribute_code='<attribute_id>' 

Custom attribute default values will be stored at a different table:
SELECT default_value FROM ODF_CUSTOM_ATTRIBUTES WHERE COLUMN_name ='attribute_id'