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

Environment

Version: 15.9.3.

Resolution

  1. Unmarked the object for Data Warehouse
  2. Ran a full load of the job to completion
  3. Meta data reference to a column called "ID" got dropped by doing this
  4. Marked the object for Data Warehouse
  5. Noticed that the job continued to execute successfully.