When adding a Static Lookup attribute to an object such as Department to be included in Data Warehouse it fails the Load Data Warehouse job with error message ORA-00904: "LAST_UPDATED_DATE": invalid identifier.
Steps to Reproduce:
Expected Result: Load Data Warehouse Job to completed successfully.
Actual Result: Load Data Warehouse fails with error ORA-00904: "LAST_UPDATED_DATE": invalid identifier on DWH_DEPARTMENT_V.
ERROR 2015-12-10 16:08:03,600 [DWH_DIM_FIELD_MAPPING - Table input 2] dwh.event Table input 2 - org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
when exists (SELECT 1
FROM DWH_DEPARTMENT_V src
( LAST_UPDATED_DATE is null or LAST_UPDATED_DATE >= to_date('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss') )
end) as record_exists
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "LAST_UPDATED_DATE": invalid identifier
Caused by CLRT-79485
This issue applies to CA PPM 14.2 and 14.3
This issue has been fixed in CA PPM 14.4
Remove the custom attribute based on Static Lookup from the Department view.