Clarity Health Report Export Failing

book

Article ID: 208659

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

While trying to export Health Report via UI or Command prompt fails 

Steps to Reproduce 

  1. Log in to Classic PPM with administrative access rights.
  2. Click the Administration menu. Under Security and Diagnostics, select Health Report.
  3. To export the complete health report to Excel, click the Download Health Report button on the Summary tab. Open the HealthReport.xlsx.zip file to view the HealthReport.xlsx file in Excel.
  4. To run the health report from a command line, enter the following command from Clarity_home\bin:   admin healthreport

Expected Result: The health report will export to excel

Actual Result: Download of health report fails with below errors 

ava.lang.InternalError: java.lang.reflect.InvocationTargetException
        at java.desktop/sun.font.FontManagerFactory$1.run(FontManagerFactory.java:86)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at java.desktop/sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
        at java.desktop/java.awt.Font.getFont2D(Font.java:497)
        at java.desktop/java.awt.Font.canDisplayUpTo(Font.java:2246)
        at java.desktop/java.awt.font.TextLayout.singleFont(TextLayout.java:469)
        at java.desktop/java.awt.font.TextLayout.<init>(TextLayout.java:530)
        at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:275)
        at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:250)
        at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:235)
        at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:549)
        at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:531)
        at com.ca.ppm.nmc.util.StyledExcelWorkbook.autoResizeColumn(StyledExcelWorkbook.java:310)
        at com.ca.ppm.nmc.util.StyledExcelWorkbook.addTableToSheet(StyledExcelWorkbook.java:146)
        at com.ca.ppm.nmc.util.StyledExcelWorkbook.addTableToSheet(StyledExcelWorkbook.java:158)
        at com.ca.ppm.nmc.util.StyledExcelWorkbook.populateWorkbook(StyledExcelWorkbook.java:185)

Cause

The error comes because the export to excel fails as its unable to find the needed fonts to export the file HealthReport.xlsx

Environment

Release : All supported clarity version 

 

Resolution

  • For Non Windows

    • Install the JDK Fonts package by running:  sudo apt-get install fonts-dejavu-core

  • For Windows
    • Follow the document provided by Microsoft and install the dejavu font family