Task picklists don't work after Task table widget added to Status tab

book

Article ID: 237383

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Summary: Project TASKS Module Timeline View Not Loading. Task picklists don't work after the 'Tasks' table widget is added to STATUS Module. 

Steps Reproduce:

  1. Configure the Project Blueprint to have the STATUS Module to be the first tab 
  2. Add the 'Tasks' table widget to the Status Report layout 
  3. Create a new project from the Project Grid
  4. After creation you should be taken to the STATUS Module 
  5. Navigate to the new project's TASKS Module, Timeline View

Expected Results: The view should load and picklists should work as expected. 

Actual Results: The user cannot create and save new picklists. Toast error message = Could not save the view.  

The browser developer tools (Preview,Payload) and the app-ca.log file shows error messages. 

  1. The browser developer tools (Preview,Payload) error shows: 
    • {"resourceId":null,"httpStatus":"500","errorMessage":"API-1019 : Could not process the request due to internal error.","errorCode":"api.internalError"}
    • Request URL: http://server/ppm/rest/v1/private/picklistContexts/5041043/picklists?filter=((objectCode+%3D+null)+and+(attributeCode+%3D+%27prstatus%27)+and+(isPicklist+%3D+true)+and+(isActive+%3D+true))
      Request Method: GET
      Status Code: 500 
    • {resourceId: null, httpStatus: "400",…}
      errorCode: "odf.picklistValidationFailure"
      errorMessage: "Picklist validation error: Object code 'null' is not valid."
      httpStatus: "400"
      resourceId: null
  2. The app-ca.log shows the following error:
    • ERROR 2022-03-21 07:18:37,051 [http-nio-8080-exec-1280] ppm.rest (clarity:user:session:PPM_REST_API) Invalid object

 

Cause

DE64612

Workarounds:

  1. Remove the 'Tasks' Table Widget from the Status Report configuration
  2. Correct the table ODF_PICKLIST_CONTEXTS where the object_code column is null:
    • Run query:  select * from odf_picklist_contexts where code like '%::projects::tasks' and object_code is null  
    • Review the affected projects to ensure correction is done appropriately
    • Run the below query to correct: 
      update odf_picklist_contexts set object_code = 'task' where code like '%::projects::tasks' and object_code is null; 
      commit; 
    • For a specific project only (replace code accordingly):  
      update odf_picklist_contexts set object_code = 'task' where code = '5xxxxx::projects::tasks' and object_code is null; 
      commit; 

Environment

Release: 16.0.1, 16.0.2 

Resolution

In Engineering under Review. 

Attachments