search cancel

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

book

Article ID: 228743

calendar_today

Updated On:

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, @[email protected](i.odf_blueprint_id, b.id ) AS active_blueprint_id
 FROM @[email protected] i
LEFT JOIN odf_blueprints b on b.type = @[email protected]( i.odf_object_code ) AND b.is_default = 1
 WHERE i.id IN (@[email protected])
        </text>
    <param name="odf_pks" type="long" direction="IN" expressionListTag="@[email protected]" 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: @[email protected] SQL:odf_ca_zz_cam

 

Cause

This is reported as DE63232 

Environment

Release : 16.0.0

Component : CLARITY STUDIO

Resolution

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

 

 

 

Attachments