Upgrade fails with error java.lang.NullPointerException on com.ca.clarity.object.datawarehouse.DataWarehouseObjectBuilder.getInternalName
Article ID: 130616
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)
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:
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.
The Load Data Warehouse job must be ran successfully prior to starting upgrade.
- 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.
Feedback
Yes
No
Powered by
