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 fails with error "ORA-00904: "BUSINESS_ALIGNMENT": invalid identifier"

book

Article ID: 36444

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The Load Data Warehouse (DWH) job fails with the following error message related to an Investment object attribute in Reports and Jobs > Jobs > Log

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_INVESTMENT
	at Processor.processRow(Processor.java:64)
	at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
	at java.lang.Thread.run(Thread.java:722)
User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_INVESTMENT
	at Processor.processRow(Processor.java:64)
	at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
	at java.lang.Thread.run(Thread.java:722)

The bg-dwh.log contains the corresponding error:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "BUSINESS_ALIGNMENT": invalid identifie

Environment

Release: Any
Component: Load Data Warehouse

Resolution

  1. Go to Administration, Studio: Objects, Open 'Investment' object, Attributes tab
  2. Find the attribute: Business Alignment (obj_alignment)
  3. Checkmark "Include in Data Warehouse"
  4. Click the 'Save and Return' button
  5. Run the Load Data Warehouse job - with the 'Full Load' option checked

Additional Information

Reference also: