Health Report throws System error on Summary and DWH page with MSSQL if environment type is OD

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

On MSSQL the Heath report is thrown NullPointerException on DWH on both Summary and Data Warehouse tabs if environment is set to OD.

STEPS TO REPRODUCE:

1. On MSSQL 2019 and Clarity 16.3.0, open the properties.xml
2. On line 10, set the environment type to OD:
   environment="OD"
3. Save and restart the services
4. Now go to Health Report

Expected Results: the Health Report to display information on Summary and Data Warehouse tab

Actual Results : System Error - Health report generation failed on SUMMARY and DATA WAREHOUSE tabs

NullPointerException in logs:

ERROR 2025-02-06 11:53:59,572 [http-nio-80-exec-1] services.HealthReportService (clarity:admin:76086172__F594F61A-1ECB-4E16-8AF2-60A5B7EAE86F:nmc.healthReport) (3497bff5-17b9-4cba-ab08-5ec4e073de4f)

java.lang.NullPointerException: Cannot invoke "com.ca.ppm.nmc.healthreport.HealthReport.addCategory(com.ca.ppm.nmc.healthreport.HealthReport)" because "databaseParameters" is null
                at com.ca.ppm.nmc.healthreport.providers.DWHDBHealthReportProvider.addHealthReportProperties(DWHDBHealthReportProvider.java:88)
                at com.ca.ppm.nmc.healthreport.providers.DWHDBHealthReportProvider.getHealthReport(DWHDBHealthReportProvider.java:46)
                at com.ca.ppm.nmc.healthreport.providers.DWHDBHealthReportProvider.getHealthReport(DWHDBHealthReportProvider.java:52)
                at com.ca.ppm.nmc.healthreport.utils.HealthReportUtil.getHealthReport(HealthReportUtil.java:683)
                at com.ca.ppm.nmc.healthreport.utils.HealthReportUtil.appendHealthReport(HealthReportUtil.java:725)
                at com.ca.ppm.nmc.healthreport.utils.HealthReportUtil.appendContextAndHealthReport(HealthReportUtil.java:8

Environment

Clarity 16.3.0, 16.3.1

Cause

DE165953

Resolution

• Fixed in Clarity 16.3.2

Workaround:

1. In properties.xml, edit line 10 and set the environment to OP environment="OP"
2. Restart services