Applications Systems

No data displayed in DPA charts

What to do if charts in DPA do not display trend data.

First published date

11/2/2018 3:58 PM

Last published date

11/2/2018 3:58 PM

Overview

Charts in DPA do not display trend data. This may happen if you are in a time zone with recent changes related to daylight savings. This causes the data in the Java Runtime Envorinment (JRE) and the Joda-Time library to be outdated.

Product section

Database Performance Analyzer

Cause

The data in the database does not match the expected calculated beginning of the day.

DPA uses the Joda-Time library for managing date and time. It is best to keep the time zone (TZ) data updated to the same version in the Joda-Time library as the JRE used to run the DPA.

For information about TZ data changes, see this article from Oracle. (© 2017 Oracle and/or its affiliates, available at http://www.oracle.com, obtained on September 28, 2017)

Resolution

Only update the TZ data if you are experiencing an issue as described above.

Update Joda-Time and JRE to the latest TZ data 

  1. Update the TZ data in the Joda-Time library.
    • Follow the instructions on the Joda-Time site. (© 2017 Joda.org, available at http://www.joda.org, obtained on September 28, 2017)
    • You can use a Joda-Time version up to 2.9.7 with DPA.
  2. Stop DPA.
  3. Navigate to \DPA_installation_folder\iwc\tomcat\webapps\WEB-INF\lib\.
  4. Replace the existing joda-time-2.x.jar file with the one you updated in the first step.
  5. Update the TZ data in the JRE.
    • Follow the instructions in this article from Oracle (© 2017 Oracle and/or its affiliates, available at http://www.oracle.com, obtained on September 28, 2017).
    • Make sure you run the tool with the same JRE that is used to run DPA.
  6. Start DPA.

Update only the Joda-Time library 

This is a quick fix for DPA versions 10.2.x.

  1. Update the Joda-Time library to version 2.9.1.
    • Download from the Joda-Time GitHub repository (© 2017 Joda.org, available at http://www.joda.org, obtained on September 28, 2017).
    • This contains the same TZ data as the JRE embedded in DPA (TZ data version 2015g, not the latest version).
  2. Stop DPA.
  3. Navigate to \DPA_installation_folder\iwc\tomcat\webapps\WEB-INF\lib\.
  4. Replace the existing joda-time-2.x.jar file with the one you downloaded in the first step.
  5. Start DPA.
Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.