Negative Duration in Task Manager / te_task table
Hello PA Team,
I've encountered a strange issue where some tasks in the Task Manager display a negative duration. It looks like the task "ended" before it even "started".
Observed Behavior:
When I check the te_task table in the repository (or look at the Task Manager UI), I see records where the End Date is earlier than the Start Date.
Example from DB:
I used the following query to identify these tasks:
select distinct task_id, start_date, end_date, end_date - start_date
from te_task
where end_date - start_date < '00:00:00.000'This returns multiple rows with negative time differences (e.g., -4000 seconds).
Context:
This issue has persisted across multiple versions (currently on 2023.14.100).
It happens sporadically for different tasks.
My Question:
What could be the cause of this timestamp mismatch?
Could this be related to:
Time zone differences between cluster nodes (Task Servers vs Repository)?
Clock synchronization issues on the servers?
Or is there some other logic in how Start Date and End Date are recorded?
Any guidance on how to troubleshoot and fix this would be appreciated.
Thanks!