Post Upgrade to 16.1.0, Load DWH Rights Job is running longer and consuming large Temp

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

SUMMARY: Post Upgrade to 16.1.0, Load DWH Rights Job is running longer and consuming large Temp

This may also cause some resources missing access DWH rights in dwh_inv_security_v and dwh_res_security_v

Steps to Reproduce: 

1. Upgrade to 16.1.0
2. Run DWH rights job 

Expected Results:  The job should complete quickly

Actual Results: The job is running way longer and consuming lot of temp space while executing a procedure dwh_security_views_refresh_sp

 

Environment

Release : 16.1.0

Cause

DE67413 

Resolution

• On Premise
  • DE67413 is targeted to be fixed in 16.1 patch 1 
• Broadcom SaaS
  • DE67413 - For Non production this is targeted to be fixed by end of this week 25th November
  • DE67413 - For Production this will be taken care as part of production