Load DWH job fails with error "ORA-00904: "BUSINESS_ALIGNMENT": invalid identifier"

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:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures