Incremental DWH Load Fails on DWH_RES_RESOURCE on Postres for customers having larger number of resources

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Incremental DWH Load Fails on DWH_RES_RESOURCE on Postgres for customers having larger number of resources.

STEPS TO REPRODUCE:
1. Login to Clarity.
2. Create more than 300K resources.
3. Additionally make sure that there are around 400K+ records in DWH_CMN_MV_LOOKUP.
4. Run the DWH Full Load.
5. Update few resources.
6. Run the incremental DWH load.

 

Expected Results :- Incremental Load completes successfully
Actual Results :- Incremental Load fails while populating DWH_RES_RESOURCE

Environment

Clarity 16.3.1, 16.3.2

Cause

DE170038

Resolution

DE170038

Fixed in 

• • Clarity 16.3.3
  • Clarity 16.3.2 Patch 1 (16.3.2.1)