Idea Views Cannot Display Error: Could not load columns

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Idea views cannot be displayed. The following generic error is shown: Could not load columns

APP log shows errors

ERROR 2022-09-26 21:07:35,856 [http-nio-8082-exec-155] rest.validation (clarity:user:session:PPM_REST_API) ODFResourceProvider :: Could not update resource. Object code alias: [ requestUrl: http://<host>/ppm/rest/v1/ideas/5643040 , _restResourceName : ideas , _id : 5643040 , _parentInfo : null , _apiVersion : v1 , _includeLinksArray : true , _contextId : -1 , _hierarchyId : -1]
ERROR 2022-09-26 21:07:35,857 [http-nio-8082-exec-155] rest.validation (clarity:user:session:PPM_REST_API) ExceptionInfo ::  Could not update resource. Resource name: ideas. Error code: projmgr.PROJECT_DATES_OUTOFSEQUENCE Error message: PRJ-07008: Finish date earlier than start date.
ERROR 2022-09-26 21:08:11,128 [http-nio-8082-exec-162] rest.validation (clarity:user:session:PPM_REST_API) ODFResourceProvider :: Could not update resource. Object code alias: [ requestUrl: /<host>/ppm/rest/v1/ideas/5643040 , _restResourceName : ideas , _id : 5643040 , _parentInfo : null , _apiVersion : v1 , _includeLinksArray : true , _contextId : -1 , _hierarchyId : -1]
ERROR 2022-09-26 21:08:11,128 [http-nio-8082-exec-162] rest.validation (clarity:user:session:PPM_REST_API) ExceptionInfo ::  Could not update resource. Resource name: ideas. Error code: projmgr.PROJECT_DATES_OUTOFSEQUENCE Error message: PRJ-07008: Finish date earlier than start date.
ERROR 2022-09-26 21:15:05,115 [http-nio-8082-exec-117] service.ViewInstanceClass (clarity:user:session:PPM_REST_API) Failed to update Unsaved view : 5656010
com.niku.union.persistence.PersistenceException: 
SQL error code: 1
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU_TEST.ODF_UI_VIEWS_U1) violated

Executed:
 update odf_ui_views
                    set
                    name = ?,
                    is_shared = ?,
                    view_target_id = null,
                    view_mode = 'SAVED',
                    last_updated_date = ?,
                    last_updated_by = ?
                    where
                    id = ? 
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>
                    update odf_ui_views
                    set
                    name = ?,
                    is_shared = ?,
                    view_target_id = null,
                    view_mode = 'SAVED',
                    last_updated_date = ?,
                    last_updated_by = ?
                    where
                    id = ?
                </text>
    <param name="name" type="string" direction="IN" expressionListDelimiter=","/>
    <param name="is_shared" type="int" direction="IN" expressionListDelimiter=","/>
    <param replace="timestamp" direction="IN" expressionListDelimiter=","/>
    <param replace="userId" direction="IN" expressionListDelimiter=","/>
    <param name="id" type="long" direction="IN" expressionListDelimiter=","/>
  </sql>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="odf.UpdateUnsavedView_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: 
{is_shared=0, name=SAMPLE VIEW Name, id=5656010}

It happens repeatedly:

ERROR 2022-09-26 21:15:05,115 [http-nio-8082-exec-117] service.ViewInstanceClass (clarity:user:session:PPM_REST_API) Failed to update Unsaved view : 5656010
ERROR 2022-09-26 21:35:21,159 [http-nio-8082-exec-170] service.ViewInstanceClass (clarity:user:session:PPM_REST_API) Failed to update Unsaved view : 5656014
ERROR 2022-09-26 21:37:24,874 [http-nio-8082-exec-162] service.ViewInstanceClass (clarity:user:session:PPM_REST_API) Failed to update Unsaved view : 5656015
ERROR 2022-09-26 21:41:43,431 [http-nio-8082-exec-171] service.ViewInstanceClass (clarity:user:session:PPM_REST_API) Failed to update Unsaved view : 5656019

 

 

Environment

Release : 16.0.2

Component :

Resolution

This is reported as DE67127 and is resolved in 16.0.3

Workaround: Refresh the page will update the view