Non - Labor Resource creation error: System error. Contact system administrator.

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

System error received when creating a non-labor resource if the Resource ID field is audited for Inserts

STEPS TO REPRODUCE:

1. Go to Administration > Studio > Objects
2. Edit the User object and go to the Audit trail tab
3. Add the Resource ID field for auditing on Insert operations
4. Go to Home > Resource Management > Resources
5. Click on New and Select Resource and Type Equipment, Material or Expense
6. Populate the data and Save

Expected Results: The non-labor resource to be created successfully
Actual Results: System error received

Environment

Clarity 16.1.1

Cause

This is caused by DE69412

Resolution

Workaround: Do not add the resource ID field on the User object Audit for insert operations

This is fixed in 16.1.2

Additional Information

app-ca.log file:

ERROR 2023-04-13 07:40:22,126 [http-nio-1611-exec-391] niku.xql2 (clarity:admin:5416074__388DC226-7C61-425D-AA3C-59F6F7AFDE03:projmgr.saveResource) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 1400
Error message: ORA-01400: cannot insert NULL into ("CMN_AUDITS"."OBJECT_ID")
ORA-06512: at "T_NMC_USER_SSRM_RESOURCES", line 23
ORA-04088: error during execution of trigger 'T_NMC_USER_SSRM_RESOURCES'

Caused by: Error : 1400, Position : 12, Sql = insert into srm_resources(id,forecast_rate,DEFINED_TEAM_ID,USE_IN_FRC_BUDGET,FULL_NAME,USER_ID,PERSON_TYPE,IS_HIDDEN,EXTERNAL_ID,MANAGER_ID,EMAIL,IS_ACTIVE,LAST_NAME,entity_code,INCLUDE_FLAG,RESOURCE_TYPE,UNIQUE_NAME,SLICE_STATUS,BOOK_MANAGER_ID,FIRST_NAME,SMS_EMAIL,IS_EXTERNAL,EXTERNAL_SOURCE_ID,DATE_OF_HIRE,DATE_OF_TERMINATION,created_date,created_by,last_updated_date,last_updated_by) values(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ), OriginalSql = insert into srm_resources(id,forecast_rate,DEFINED_TEAM_ID,USE_IN_FRC_BUDGET,FULL_NAME,USER_ID,PERSON_TYPE,IS_HIDDEN,EXTERNAL_ID,MANAGER_ID,EMAIL,IS_ACTIVE,LAST_NAME,entity_code,INCLUDE_FLAG,RESOURCE_TYPE,UNIQUE_NAME,SLICE_STATUS,BOOK_MANAGER_ID,FIRST_NAME,SMS_EMAIL,IS_EXTERNAL,EXTERNAL_SOURCE_ID,DATE_OF_HIRE,DATE_OF_TERMINATION,created_date,created_by,last_updated_date,last_updated_by) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), Error Msg = ORA-01400: cannot insert NULL into ("CMN_AUDITS"."OBJECT_ID")
ORA-06512: at "T_NMC_USER_SSRM_RESOURCES", line 23
ORA-04088: error during execution of trigger 'T_NMC_USER_SSRM_RESOURCES'

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
    ... 111 more