search cancel

Load DWH job not completing (bad DB execution plan)

book

Article ID: 252531

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Clarity is not completing the DWH load, as it stops at DWH_INV_PICKLIST_POSITION or DWH_INV_PICKLIST_POSITION_LN tables

Cause

Looked at the extracts of the DWH_GATHER_METRICS table and could see excessive time taken on populating those tables.
The query that is running in the DWH schema to populate DWH_INV_PICKLIST_POSITION_LN and DWH_INV_PICKLIST_POSITION tables is being assigned a bad execution plan by the DB.

 

Resolution

Check with a DBA to monitor this query while it runs, and baseline a better execution plan