Load DWH job error "Could not add attribute code of sub object XXXXX to domain"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Load Data Warehouse job Incremental or full load is failing with error: "Could not add attribute code of sub object XXXXX to domain (dwh table:dwh_odf_XXXXXX dwh column:id ). 

Environment

Release : Any

Cause

This issue can happen:

• If you deleted any subobject from the Data Warehouse which is part of a domain
• An attribute is deleted and has an orphan that still exists in the Data Warehouse

Resolution

This issue can be fixed by one of the below methods: 

Method 1: Recreate the object

1. Unmark / exclude from Data Warehouse before deleting 
2. Recreate the object

Method 2:  Uncheck / recheck object in DWH

1. Uncheck the custom object from DWH
2. Run a successful full load DWH job
3. Check custom object back to DWH
4. Run another full load DWH job

Method 3: Restore Domains

1. Run the restore domain job
2. Run the load data warehouse job full load

Additional Information

More information about the Data Warehouse: Install and Configure the Data Warehouse

Reference also:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures