DWH - Invalid Object DWH_TRD_SUM_TREND_BY_PER_MV
search cancel

DWH - Invalid Object DWH_TRD_SUM_TREND_BY_PER_MV

book

Article ID: 276389

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The view DWH_TRD_SUM_TREND_BY_PER_MV remains in invalid state. The recompilation of the view also doesn't make the view valid. The execution of the query related to the view in database directly returns records without any issue.

Steps to Reproduce:

  1. Perform fresh installation of 16.1.3
  2. Configure the environment with Oracle vanilla DB for DWH and Clarity
  3. Check the status of materialized view DWH_TRD_SUM_TREND_BY_PER_MV and it should be in valid status
  4. Execute the load datawarehouse job and make sure that it completes successfully

Expected Results
The view DWH_TRD_SUM_TREND_BY_PER_MV should remain in valid state.

Actual Results:
The view DWH_TRD_SUM_TREND_BY_PER_MV goes to invalid state. 

Environment

Version: 16.1.3.

Cause

DE78604

Resolution

DE78604 is fixed in  v16.2.1.