Load Data Warehouse fails ERROR: column "last_updated_date" does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We added a custom atttribute lookup field to Department Object and the Load Data Warehouse - Full fails with error:

SELECT CASE WHEN a.record_count > 0 THEN 1 ELSE 0 END record_exists
FROM  (SELECT COUNT(1) record_count
       FROM   DWH_DEPARTMENT_V src
    WHERE (LAST_UPDATED_DATE::TIMESTAMP IS NULL OR LAST_UPDATED_DATE::TIMESTAMP >= to_timestamp('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss'))) a
ERROR: column "last_updated_date" does not exist

 

Note: This may happen on other objects and other types of fields

Environment

Release : Any

Component : CA PPM SAAS DATA WAREHOUSE

Cause

The exact cause of this is unknown

Resolution

1. Query the DWH_META_TABLES to confirm the field shows wrong:

           select * from dwh_meta_tables where src_table_name ='dwh_department_v'

2. Note if the field shows wrong for dwh_fin_department_ln, it should be clarity_updated_date not last_updated_date. Note the ID

3. If it's wrong, update the value as follows:

   update dwh_meta_tables

           set src_date_column ='clarity_updated_date'

where src_table_name ='dwh_department_v' and ID ='<xxxxxxxx>'

commit

4. Run a Full Load to completion.