Full and Incremental Load Data Warehouse Job Fails On DWH_TME_SHEET

Products

• Clarity PPM SaaS

Issue/Introduction

The BG DWH log shows error:

ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_TME_SHEET. null value in column "timesheet_key" of relation "dwh_tme_sheet" violates not-null constraint
23502
INSERT INTO DWH_TME_SHEET (ADJUSTMENT_KEY, APPROVED_BY, APPROVED_BY_KEY, CLARITY_TIMESHEET_KEY, CLARITY_UPDATED_DATE, IS_ADJUSTMENT, PERIOD_FINISH_DATE, PERIOD_START_DATE, POSTED_DATE, RESOURCE_KEY, RESOURCE_NAME, SUBMITTED_BY, SUBMITTED_BY_KEY, TIME_PERIOD_KEY, TIMESHEET_KEY, TIMESHEET_STATUS_KEY, dw_updated_date) SELECT ADJUSTMENT_KEY, PRAPPROVEDBY_CAPTION, APPROVED_BY_KEY, CLARITY_TIMESHEET_KEY, CLARITY_UPDATED_DATE, IS_ADJUSTMENT, PERIOD_FINISH_DATE, PERIOD_START_DATE, POSTED_DATE, RESOURCE_KEY, PRRESOURCEID_CAPTION, PRSUBMITTEDBY_CAPTION, SUBMITTED_BY_KEY, TIME_PERIOD_KEY, TIMESHEET_KEY, TIMESHEET_STATUS_KEY, TO_TIMESTAMP(**03-oct-2022 14:14:45**, **dd-mon-yyyy hh24:mi:ss**) AS dw_updated_date FROM DWH_TIMESHEET_V A WHERE CLARITY_UPDATED_DATE >= TO_TIMESTAMP(**01-jan-1910 00:00:00**, **dd-mon-yyyy hh24:mi:ss**) AND CLARITY_UPDATED_DATE <= (SELECT DISTINCT dwh_dim_start_date FROM dwh_cfg_settings) AND a.language_code = **en**

Resolution

Please contact Support to remove the null timesheet IDs.