After restoring backup at a different server, Agile reports are showing incorrect data
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
After restoring XML backup at a different server, Agile reports, such as Velocity or Burndown charts are showing incorrect data, like commitment bars are missing in Velocity chart, Burndown charts not burning down or Sprint showing all issues marked with asterisk signifying them being added after spring start date.
Cause
The source and target system have different time zone configurations, causing confusion regarding when issues were added to sprints.
Resolution
Source and target system must be on the same time zone settings for the data to appear correctly. That means:
OS time zone must be the same
If Java arguments have -Duser.timezone parameter specified, its value must be the same
JIRA default user time zone must be the same
If the affected target server operating under incorrect time zone settings had users submitting new data between server restore and time zone correction, the date time data captured by the server during that time might be incorrect and in needs of rectification. There are two approaches here: either shift all date time values in database tables by the time difference to align it with existing data, or modify start and end times of sprints to account for the time difference. The latter approach will permanently make sprint time and end dates appear differently to their real start and end time, but all Agile data should appear properly after that.
Was this helpful?