Load Data Warehouse job failed with exception column "id" does not exist
search cancel

Load Data Warehouse job failed with exception column "id" does not exist

book

Article ID: 225927

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We are running the Load Data Warehouse job, and encountering an issue with it. It fails with the following error message (in the bg-dwh.log):

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_ODF_RANDOM_CUSTOM_OBJECT. column "id" does not exist
  Where: PL/pgSQL function inline_code_block line 22 at RAISE

Cause

There is meta data in the DWH_META_COLUMNS table, against a specific custom object, for a column called "ID". While in fact the application does not let an attribute be created with this ID.

Resolution

  1. Open the custom object and exclude it from Data Warehouse
  2. Run a Full Load to completion - meta data reference to a column called "ID" will be dropped by doing this
  3. Mark the object to be enabled for Data Warehouse
  4. Run a Full Load of Data Warehouse
Powered by Wolken Software