Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-13996

burndown chart is missing issues in start sprint row

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Gathering Impact (View Workflow)
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 7.1.4, 8.3.1
    • Fix Version/s: None
    • Component/s: AgileBoard
    • Labels:

      Description

      Burndown chart is missing issues when issue is transitioned in the same second that issue was created.

      Steps to reproduce:
      1. create issue and immediately transition it to other status (eg. by using rest API, Automation) so that transition happens in the same second that the issue was created in
      2. use issue in the sprint
      3. close sprint
      4. go to burndown chart - the issue is not in the "start sprint" row

      Actual behaviour

      1. Issue was missing from the Burndown Chart but not Sprint Report. The issue key will appear after issue was resolved and Sprint was ended.
      2. Story points was not calculated in the Burndown Chart.

      Expected behaviour
      Issue is included in the "start sprint" row

      Possible workaround

      1. Backup JIRA
      2. Update the "created" field of offending changegroup and jiraissue
        alter table jiraissue modify column created datetime(3);
        
        alter table changegroup modify column created datetime(3);

        The SQL query is applicable for MySQL database.
         The column names are case insensitive in MySQL, but some third-party tool may store cached column names in uppercase ("CREATED"), ex. Power BI reporting tools. This will not cause any problems for Jira, but may require some schema refresh for this tools.

      1. Restart JIRA
      2. Reindex instance

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              tkanafa Tomasz Kanafa
              Votes:
              25 Vote for this issue
              Watchers:
              32 Start watching this issue

                Dates

                Created:
                Updated: