ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 201723

calendar_today

Updated On:

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

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

Environment

Release : Any

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: