search cancel

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

book

Article ID: 254673

calendar_today

Updated On:

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

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