Load Datawarehouse Failure with "duplicate column name" Error

Products

• Clarity PPM On Premise

Issue/Introduction

Load Datawarehouse Full load fails with "duplicate column name" error when the job is run after upgrading to latest Clarity Releases from a Legacy/Old Clarity Release.

Cause

We've identified that there are duplicate rows in DWH_META_COLUMNS table which has caused the issue with DWH Full load.

Resolution

Oracle & MSSQL Only:

1. Run the following query on PPM Schema to identified any such duplicates based on the table name.
   SELECT DWH_TABLE_NAME, SRC_COLUMN_NAME, DWH_COLUMN_NAME , count(1) FROM dwh_meta_columns
   GROUP BY DWH_TABLE_NAME, SRC_COLUMN_NAME,DWH_COLUMN_NAME HAVING count(1) > 1
2. The above query should give us the details of which tables have the issue. 
3. Take backup of DWH_META_COLUMNS table and remove one of the duplicate row(Don't remove both).
4. Once step 3 is complete, on DWH Schema Truncate both DWH_META_COLUMNS and DWH_META_TABLES.
5. Re-run the Dwh Full load.