16.0.3 - Advanced Reporting errors based on materialized view "dwh_sec_inv_inst_security_mv"

Products

• Clarity PPM SaaS

Issue/Introduction

Post upgrade to 16.0.3, clarity SAAS customers are noticing different issues related to a need to refresh materizalized views "dwh_sec_inv_inst_security_mv".

Creating adhoc views (based on custom and OOTB domains) getting 5500 ERROR: materialized view "dwh_sec_inv_inst_security_mv" has not been populated.

The OOTB reports also fail with mentions of the same:

 

 

Environment

Clarity Release 16.0.3 Advanced Reporting 

Cause

As part of DE63862 the materizalized view "dwh_sec_inv_inst_security_mv" was introduced to address performance issues noticed for DWH queries which were using DWH security views DWH_INV_SECURITY_V and DWH_INV_RESOURCE_V.

Resolution

For the time being SAAS operations rolled back the security view definitions for DWH_INV_SECURITY_V and DWH_INV_RESOURCE_V to the original version.

DE66648 is created to populate the MV from the Load DWH Access rights job.