Data Warehouse job failing "Invalid Identifier"

Products

• Clarity PPM On Premise

Issue/Introduction

After attempting to run a Data Warehouse Full Load in an upgraded environment, the following error is seen:

 

Error occurred while processing domain attributes.

SQL error code: 904

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ATTRIBUTE_NAME": invalid identifier

Data warehouse is not up to date, DWH meta column ATTRIBUTE_NAME is not in DWH table TABLE_NAME hence quiting from domain updates

 

When reviewing the DWH database, the column is missing. It was not created by the Data Warehouse Full Load.

 

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Resolution

Attempt to run the "Restore Domains" job to resolve the problem.