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 has been fixed in CA PPM 14.4
Remove the custom attribute based on Static Lookup from the Department view.