Views invalid and not compiling in 16.2.1

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After upgrading or installing Clarity 16.2.1 the following views appear as invalid:

• ODF_ODF_UI_ACTIONS_V2
• ODFSEC_ODF_UI_ACTIONS_V2

Environment

Clarity 16.2.1

Cause

Object "odf_ui_actions" was introduced in 16.2.0, based on one of the attributes named "object_api_alias", which was later renamed to "Type" in 16.2.1 in OMD & column name in DB was also updated.

With this change in 16.21, The views in Oracle and MSSQL would appear as invalid. In the PostgreSQL databases, the views are compiled properly, though the view column alias name is still pointing to the old name. This problem is Database-agnostic.

Resolution

These views were created but not needed because the object odf_ui_actions itself is not available for consumption. Dropping the views would have no impact on Clarity functionality. 

Please use the below statements to remove those database views. 

drop view odfsec_odf_ui_actions_v2;
drop view odf_odf_ui_actions_v2;

This issue is currently tracked by engineering, and a code change is being explored to restrict the view creation.