Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-24836

Program fails to calculate if associated Plan stuck on state 'RUNNING'

    XMLWordPrintable

Details

    Description

      Issue Summary

      If a Program has a AO_D9132D_SOLUTION record with STATE == 'RUNNING', the Program will not be able to be Synced. 

      Instead of the “Calculate” / "Sync" button appearing, instead “Calculate program… 0% completed” / "Syncing program... 0% completed" appears.

      In addition, when configuring the program, Jira raises the following exception message:

      Exception Details
      this.ui.calculationStatus.hide is not a function
      TypeError: this.ui.calculationStatus.hide is not a function
      at a.showCalculationInProgress <snip> 

       

       

      Steps to Reproduce

       While we have seen this issue present in the wild, it is currently unknown how this issue manifests with normal use. So far, we have only been able to cause the symptoms by manually editing the AO_D9132D_SOLUTION table

      1. Create a Plan with a test Epic
      2. Create a Program and link it to the Plan created
      3. Update AO_D9132D_SOLUTION row for the Plan and set State = 'RUNNING'
      4. Attempt to sync the Program

      Expected Results

      The plan is able to be synced, as per normal. 

      Actual Results

      Instead of the “Calculate” / "Sync" button appearing, instead “Calculate program… 0% completed” / "Syncing program... 0% completed" appears. The condition is not cleared even if all plans are removed from the program and re-added. 

       

      Workaround

      Clear the problematic rows from the database using the following queries.

      1. Remove Assignment_Ext records from the database that are associated with the problematic Program
        DELETE FROM "AO_D9132D_ASSIGNMENT_EXT"
        WHERE "SOLUTION_ID" IN (SELECT "ID"
             FROM "AO_D9132D_SOLUTION"
             WHERE "STATE" = 'RUNNING');
      1. Finally, remove the Solution rows that are stuck in the RUNNING state
        DELETE FROM "AO_D9132D_SOLUTION" WHERE "STATE" = 'RUNNING';
      1. Refresh the Program. Check that the program is now able to be calculated

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              allewellyn@atlassian.com Alex [Atlassian,PSE]
              Votes:
              9 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated: