CA PPM Load DWH job fails with error with Investment object attribute

Document ID : KB000036444
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

The Load Data Warehouse job fails with the following error message 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 identifier 

Resolution:

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

Additional Information:

Reference the following Community post:  CA PPM Tech Tip: Getting Jaspersoft Advanced Reporting to work after upgrading to 14.2+