Invalid Materialized View DWH_TRD_SUM_TREND_BY_PER_MV

Products

• Clarity PPM On Premise

Issue/Introduction

The Materialized View DWH_TRD_SUM_TREND_BY_PER_MV in the Data Warehouse schema (Oracle) is invalid and cannot be recompiled.

Steps to Reproduce:

1. Check the current compile status for DWH_TRD_SUM_TREND_BY_PER_MV (at this point, it may be valid or invalid).
2. Try to compile the MV via SQL Developer.

Expected Results: The view is compiled successfully and remains valid.

Actual Results: The view is compiled successfully, but it is marked as invalid. Compiling with "admin db compile -db.id datawarehouse" also returns this view as invalid.

Environment

Release : 16.1.0

Cause

DE68519

Resolution

This issue has been fixed in Clarity 16.1.2.

Any Load Data Warehouse or Datawarehouse Trend jobs that fail in the middle of execution (and are not completed successfully) could make these objects in an invalid state in Oracle. For those, re-run it for a successful run and the views will be in a valid state.