Upgrade fails with error java.lang.NullPointerException on com.ca.clarity.object.datawarehouse.DataWarehouseObjectBuilder.getInternalName

book

Article ID: 130616

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Error message during upgrade:
 
Applying post-bootstrap xog-seeddata for component = database
Applying BLUEPRINT_AUTONUMS.xml
Applying BOARD_AUTONUMS.xml
Error Applying XOG: Failure occurred while applying BOARD_AUTONUMS.xml
Check $clarity/logs/xog-seeddata/out/database/BOARD_AUTONUMS_out.xml for errors
ERROR: Upgrade failed for tenant
$clarity/.setup/scripts/db.xml:2368: The following error occurred while executing this line:
$clarity/.setup/scripts/db.xml:571: The following error occurred while executing this line:
$clarity/.setup/scripts/db.xml:563: The following error occurred while executing this line:
$clarity/.setup/scripts/db.macros.xml:105: Java returned: 2
 
In the file BOARD_AUTONUMS_out.xml we can see :
Description>XOG-3360: Custom attribute record has not been inserted com.niku.union.odf.exception.ODFException: java.lang.NullPointerException at com.ca.clarity.object.datawarehouse.util.DataWareHouseUtil.executeDWViewsHelper(DataWareHouseUtil.java:723)
at com.niku.odf.object.Utils.createObjectViews(Utils.java:12
 
Caused by: java.lang.NullPointerException at com.ca.clarity.object.datawarehouse.DataWarehouseObjectBuilder.getInternalName(DataWarehouseObjectBuilder.java:192)at com.ca.clarity.object.datawarehouse.DataWarehouseObjectBuilder.getCode(DataWarehouseObjectBuilder.java:620)at com.ca.clarity.object.datawarehouse.util.DataWareHouseUtil.executeDWViewsHelper(DataWareHouseUtil.java:698)
 
 

Environment

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

Turned out customer's Load Data Warehouse job did not run successfully prior to the upgrade. Load Data Warehouse was failing with errors, which turned out to be due to few DWH views that were not having the latest DWH column names.The DWH views were not having CLARITY_UPDATED_DATE field as they should have done.
 
  1. Rollback to prior version
  2. Updated the DWH views on PPM database
  3. Ran Load Data Warehouse successfully
  4. Ran the upgrade

The Load Data Warehouse job must be ran successfully prior to starting upgrade.