Upgrade fails with error java.lang.NullPointerException on com.ca.clarity.object.datawarehouse.DataWarehouseObjectBuilder.getInternalName
Article ID: 130616
Clarity PPM SaaSClarity PPM On Premise
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)
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.
Rollback to prior version
Updated the DWH views on PPM database
Ran Load Data Warehouse successfully
Ran the upgrade
The Load Data Warehouse job must be ran successfully prior to starting upgrade.