Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-2029

Issue with Incorrect Report Generation Due to UTC Time Conversion

    XMLWordPrintable

Details

    Description

      Reports are generating incorrect results due to time conversion to UTC in the CSV files.

      Steps to Reproduce:
      1. Extract the data.zip file provided under JOC_HOME/jetty_base/reporting/ and restart the JOC Cockpit service.
      2. Import the attached report configuration repo_1.report.json and run the reports from the Reports tab.
      3. Two report cards are generated: one for November 2023 and one for October 2023, each showing five workflow executions.
      4. However, upon analyzing the Order_history image (attached), all executions occurred in November 2023.
      5. Workflows executed on November 1, 2023, around 02:00 AM are incorrectly assigned to October 2023 in the reports.

      This issue occurs because, when generating the CSV files, timestamps are converted to UTC.
      Example:
      • In the CSV files, the order was saved as 2023-10-31 20:32:01 UTC. However, the actual execution time was 2023-11-01 02:02:29 local time.

      Please refer to the attached order_history and report_cards images

      Attachments

        1. data.zip
          24 kB
        2. Order_history.png
          Order_history.png
          53 kB
        3. repo_1.report.json
          0.2 kB
        4. report_cards.png
          report_cards.png
          36 kB

        Activity

          People

            gitesh-patidar Gitesh Patidar
            gitesh-patidar Gitesh Patidar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: