Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-13070

Timezone and date range inconsistencies when scheduling database reports associated with Grafana dashboards.

    XMLWordPrintable

    Details

    • Sprint:
      Horizon 2020 - Jan 6 - Jan 20, Horizon 2021 - Jan 20 - Feb 3
    • HB Backlog Status:
      Backlog CM
    • FD#:
      211

      Description

      When scheduling database reports associated with Grafana dashboards, there are two date related elements to configure:

      a) The time based on the cron-like setting when the report runs
      b) The actual "relative" report range you choose in the UI.

      When rendering the reports, that leads to inconsistencies between the time range on the X-Axis of the graphs rendered by Grafana and the time range displayed at the top of the report.

      Here is what I did to reproduce it:

      1) Configure a VM with OpenNMS 27.0.2, Grafana 7.3.4, and Helm 6.0.0. I installed the Image Renderer plugin version 2.0, with the required dependencies to have it working; something mandatory in Grafana 7 that wasn't required in Graffana 6 (which is why I didn't use Docker because of HELM-265).

      2) Set the VM's timezone to be America/Chicago (CST, to match what the customer has).

      3) Create a Dashboard with "browser" as its timezone (the default) in Grafana.

      4) Create a schedule for that dashboard. See screenshots.

      I'm trying to choose the last 24 hours with what looks like a relative time range.

      Note that on the second screenshot, the cron-like expression is based on the server's timezone (i.e., CST), not the user's timezone (America/New_York in my case) is also confusing.

      5) Wait for the PDF to be generated, and I get the attached PDF.

      See the difference between the X-Axis and the time rage, which suggests something different.

      The above leads to confusion as, unlike the ad-hoc report (i.e., a report generated without a scheduler), it is not clear how the date range will be used.

        Attachments

        1. sample-report.pdf
          178 kB
        2. settings-1-of-2.png
          settings-1-of-2.png
          151 kB
        3. settings-2-of-2.png
          settings-2-of-2.png
          66 kB

          Activity

            People

            Assignee:
            ranger Benjamin Reed
            Reporter:
            agalue Alejandro Galue
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration