In clarity PPM once a Datawarehouse enabled attribute is deleted from PPM studio the subsequent partial and full load jobs fail.
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 7, column 1188:PL/SQL: ORA-00904: "xxxx": invalid identifier ORA-06550: line 6, column 1:PL/SQL: SQL Statement ignored
The metadata for attributes included for Datawarehouse is stored in both PPM and DWH schema. When the attribute metadata goes out of sync the load Datawarehouse job tends to fail with the invalid identifier indication in the bg-dwh logs.
Clarity PPM 15.8.1 and supported releases