Details
-
Fix
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
2.7.1
-
None
-
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