Load Data Warehouse (Full Load) Job is Failing after New Custom String Attribute is Created in the Project Object and Checked for Include in Data warehouse.
We validated DWH_INV_PROJECT table on DWH schema and the newly created attribute is not present, which means it was not created.
Release : 15.9
Component : CLARITY DATA WAREHOUSE
Issue is with the DB link on DWH schema which is pointing to the Prod PPM schema(got carried over with the refresh). So the attributes created on Dev are not being synched to DWH.
1. DROP DATABASE LINK DBLINK.
2. CREATE DATABASE LINK DBLINK CONNECT TO NIKU IDENTIFIED BY <PASSWORD OF PPM SCHEMA> USING '<CONNECTION STRING>';
3. Connect to DWH schema and truncate tables DWH_META_COLUMNS and DWH_META_TABLES.
4. Re-run DWH Full Load