API-1019 Error while editing an attribute post upgrade to 16.0.0

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Post Upgrade to Clarity 16.0.0 manually trying to edit any field (custom or OOB) keep getting the following error in UX

STEPS TO REPRODUCE: 

1. Create Custom Object
2. Create an instance of the object
3. Go to studio and change the custom object (for example, change name, add attribute etc)
4. Now go back to the instance list and try to change any instance and you will get the error.

Expected Results: User should be able to edit edit any field (custom or OOB) 

Actual Results: User gets the below error and error shown in app ca log 

ERROR 2021-11-18 13:52:02,610 [http-nio-80-exec-60] ppm.rest (clarity:user:session:PPM_REST_API) An exception occurred while running API pre process rules.
com.niku.union.persistence.PersistenceException:
SQL error code: 0
Error message: ERROR: column i.odf_object_code does not exist
  Position: 158
Executed:
 SELECT i.id AS odf_pk, COALESCE(i.odf_blueprint_id, b.id ) AS active_blueprint_id
 FROM odf_ca_zz_cam i
LEFT JOIN odf_blueprints b on b.type = UPPER( i.odf_object_code ) AND b.is_default = 1
 WHERE i.id IN (5000002)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="all" tsvTemplateAttrCode="">
    <text>
       SELECT i.id AS odf_pk, @NVL@(i.odf_blueprint_id, b.id ) AS active_blueprint_id
 FROM @table_name@ i
LEFT JOIN odf_blueprints b on b.type = @UPPER@( i.odf_object_code ) AND b.is_default = 1
 WHERE i.id IN (@odf_pks@)
        </text>
    <param name="odf_pks" type="long" direction="IN" expressionListTag="@odf_pks@" expressionListDelimiter=","/>
  </sql>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="odf.getActiveBlueprintIDs_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>

Using input:
{odf_pks=5000002, table_name=odf_ca_zz_cam}
Using dynamic SQL:
tag: @table_name@ SQL:odf_ca_zz_cam

 

Environment

Release : 16.0.0

Component : CLARITY STUDIO

Cause

This is reported as DE63232 

Resolution

This defect is fixed in patch1 16.0.0.1 and future version 16.0.1.