search cancel

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


Article ID: 201723


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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 ). 


Release : Any


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


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: