Full and Incremental Load DWH Job Data Warehouse Jobs Failing DWH_INV_TASK_TODO_SP()

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The DWH full and incremental jobs have been failing

ERROR 2023-03-15 18:45:13,216 [dwh_etl_master_pg UUID:xxx] dwh.event (none:none:none:none) Add-ins/Views PG - An error occurred executing this job entry : 
Couldn't execute SQL: CALL DWH_CFG_ADDIN_EXTRAS_SP();
CALL DWH_PROC_NEW_VIEWS_SP();
CALL DWH_INV_TASK_TODO_SP();

ERROR: value too long for type character varying(30)
  Where: PL/pgSQL function dwh_proc_new_views_sp() line 51 at FETCH

Environment

Release : 16.1.0

Cause

In reviewing the error and the stored procedure, it is suspected that one or more TODOs have more than 30 characters.

In one reported case, where it was observed that the Clarity API attribute id was equal to 32 characters, whereas the stored procedure job accepted only 30 characters.
The attributes exceeding 32 characters were corrected and the job completed, therefore the workaround was to update the attribute with IDs greater than 30 characters to be 30 characters and below.

Support was not able to reproduce the issue on 16.1.0 test server.

 

 

 

Resolution

Workaround: Update the attribute with IDs greater than 30 characters to be 30 characters and below.

Support was not able to reproduce the issue on 16.1.0 test server.