Portlets displaying Error attribute deletion

Products

• Clarity PPM SaaS

Issue/Introduction

After removing some custom attributes from Project object, we have noticed that some portlets that retrieve data from the view 'ODF_PROJECT_V2' display error 500 messages and no data is shown.

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Cause

A glitch occurred during the deletion of the custom attributes from Project object in the user interface.

The data got removed from 'ODF_CA_PROJECT' table but the deletion did not cascade to the 'ODF_PROJECT_V2' view level and so there was reference to an invalid column.

Resolution

Executed the following Sql statement.

 

SQL> show errors view ODF_PROJECT_V2;
Errors for VIEW ODF_PROJECT_V2:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-00904: "ODF_CA_PROJECT"."AAAA_IA_OAO_RT": invalid identifier

 

select table_name, owner, status from dba_tab_cols where table_name='ODF_CA_PROJECT' and column_name='AAAA_IA_OAO_RT';

SQL> select table_name, owner from dba_tab_cols where table_name='ODF_CA_PROJECT' and column_name='AAAA_IA_OAO_RT' and owner='UK25';

no rows selected

 

The view 'ODF_PROJECT_V2' seems to be trying to access the column AAAA_IA_OAO_RT on the table ODF_CA_PROJECT that is not present

To resolve the issue, DBA should remove invalid references to the column 'AAAA_IA_OAO_RT' from the view 'ODF_PROJECT_V2' and the recomplie it.