Load Data Warehouse (Full Load) Job is Failing New Custom String Attribute is Created in the Project Object and Checked for Include in Data warehouse

book

Article ID: 220702

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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.

 

Cause

We validated DWH_INV_PROJECT table on DWH schema and the newly created attribute is not present, which means it was not created. 

Environment

Release : 15.9

Component : CLARITY DATA WAREHOUSE

Resolution

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