Error when updating Hierarchy description with length > 256 chars

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When updating a hierarchy description with a value greater than 256 chars in length the following error is seen:
! Creating instance of: odf_hierarchy

The following errors are written into the app-ca.log:

ERROR 2024-07-29 16:04:40,387 [http-nio-8080-exec-1795] object.CustomObjectInstanceClass (clarity:[email protected]:7476143__5ED43B09-F4E9-456E-8A4A-F564871CDF8B:PPM_REST_API) (3466c3da-5458-4f80-95c1-bc550c7bc3b3) Exception on update
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: value too long for type character varying(256)
..
ERROR 2024-07-29 16:04:40,388 [http-nio-8080-exec-1795] rest.validation (clarity:[email protected]:7476143__5ED43B09-F4E9-456E-8A4A-F564871CDF8B:PPM_REST_API) (3466c3da-5458-4f80-95c1-bc550c7bc3b3) ExceptionInfo ::  Could not update resource. Resource name: hierarchies. Error code: null Error message: Creating instance of: odf_hierarchy

The Description attribute of the Hierarchy object has a Maximum Size of 1333.

Steps to Reproduce: 

1. In the MUX, make a copy of the Standard Investment Hierarchy blueprint.
2. In the newly created blueprint, add the Description attribute and publish the blueprint.
3. Create a new Hierarchy and assign it to the newly created blueprint.
4. Go to the Properties tab and enter a description value with a length greater than 256 characters

Expected Results: 
The description value is updated successfully  

Actual Results:
The error 'Creating instance of: odf_hierarchy' is seen and the above errors are written to the app-ca.log

Environment

Clarity 16.2.2

Cause

DE116397

Resolution

Fix will be included in the 16.3.0 release of Clarity.