Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
8.20.0
-
8.2
-
1
-
Severity 3 - Minor
-
1
-
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
- Create a Plan with a test Epic
- Create a Program and link it to the Plan created
- Update AO_D9132D_SOLUTION row for the Plan and set State = 'RUNNING'
- 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.
- 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');
- Finally, remove the Solution rows that are stuck in the RUNNING state
DELETE FROM "AO_D9132D_SOLUTION" WHERE "STATE" = 'RUNNING';
- Refresh the Program. Check that the program is now able to be calculated