ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

dwh_inv_team_sum_facts_u1 - Load Data Warehouse job failure

book

Article ID: 240056

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Incremental Load Data Warehouse fails with the following error message:

ENCOUNTED EXCEPTION WHILE CREATING INDEX could not create unique index "dwh_inv_team_sum_facts_u1"

Environment

Version: 16.0.1

Resolution

  • Run a full load of the job before running an incremental load
  • Apply Patch 1 of 16.0.1 if not done already