DWH Load job fails - command cannot affect row a second time

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Receive below error for Full and incremental Load Data Warehouse job.

 

ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_LOOKUP_LOAD DWH_LKP_CSK_RPT_ENTITY_F_00. ON CONFLICT DO UPDATE command cannot affect row a second time
Where: PL/pgSQL function inline_code_block line 21 at RAISE

This is an Out of the Box lookup

 

Cause

Some out of the box lookups are not meant to be included in the data warehouse.

This lookup was used in an attribute in the Investment object.  

Environment

Release : 15.9

Component : CA PPM SAAS APPLICATION

Resolution

Unchecked 'Include in Data Warehouse' in the attribute and re-ran the Full Load Data Warehouse job