ODF_PROJECT_V or ODF_PROJECT_V2 with ORA-04063 - view has errors

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

You have error similar to the one below (can happen when installing PMO or just using the application):

 [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: view "PPM.ODF_PROJECT_V2" has errors
 
If you ask DBA to recompile ODF_PROJECT_V has errors and ODF_PROJECT_V does not compile with error:
ORA-00904: "ODF_CA_PROJECT"."Z_FIELD": invalid identifier
 

Environment

Release: Any Supported Release with Oracle 

Cause

The issue is with the number of custom attributes.
 
The number of custom attributes can be checked with SQL query:
select count(*) from odf_custom_attributes where object_name in('project','inv')
 

Resolution

• The total of attributes has to be reduced to under 500.
• We recommend the number of custom attributes to be kept under 100 per object as best practice, and the maximum supported is 500. Objects as project and investments should not exceed 500 as a total
• If you need more attributes, please add custom objects on the project object to hold them
• This is not Clarity but Oracle limitation. We use views to keep the columns on each object, and Oracle can only handle a limited amount of columns. They should not be over 500.