Details
-
Fix
-
Status: Dismissed (View Workflow)
-
Minor
-
Resolution: Works as designed
-
2.7.1
-
None
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
Maintainer Notes
The issue is dismissed as it is preferable to have any exported data using the same UTC time zone instead of an individual server time zone.
Attachments
Issue Links
- mentioned in
-
Page Loading...