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

Document ID : KB000130616
Last Modified Date : 08/04/2019
Show Technical Document Details
Issue:
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)
 
 
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.