Issue Summary

When creating an automation rule that assigns the "Current Sprint" value to issues, the rule fails with 'Some Errors', and the audit logs show the following error message, even though the sprint can be manually assigned to the issue.

"No fields or field values to edit for issues (could be due to some field values not existing in a given project)"

This happens because the board from which the "Active Sprint" was selected, is not the board that originated the sprint, and thus A4J cannot properly handle the configuration.

Example:

In this scenario a sprint was created on the DEVP board and is currently the active sprint on it and also on Board2.

• If the selected value is "Active Sprint (Board2)", it will trigger the error message.
• If the selected value is "Active Sprint (DEVP board)", it will not trigger the error message.
  

Steps to Reproduce

1. Create board 1 and board 2.
2. Create an issue on each board.
3. Create a sprint on board 1.
4. Assign both issues created on step 2 to the sprint from step 3.
5. Start the sprint.
6. Now create an automation rule that has an action to "Edit an issue", and select the Sprint Field.
7. On the Sprint field select "Active Sprint (board 2)".
8. Run the rule and check the results.

Expected Results

• The rule should add the issue onto the sprint.

Actual Results

• The rule fails to add the issue to the sprint and throws an error.
• If the Edit Issue action has another field that is successful, the rule fails to add the issue to the sprint, but doesn't thrown an error in the audit logs. This specific behavior is handled in JIRAAUTOSERVER-315: When there are two fields being edited on the Edit Issue action, the audit log doesn't mention the errored field if the other field is successfully updated

Workaround

To confirm which board the sprint was created on, you can use the SQL query below:

When running this query, be sure to swap 'your Active Sprint name here' with actual active Sprint name (this query is case sensitive).

SELECT s."NAME" AS Sprint_Name, r."NAME" AS Original_Board_Name
FROM "AO_60DB71_SPRINT" s 
JOIN "AO_60DB71_RAPIDVIEW" r ON s."RAPID_VIEW_ID" = r."ID"
WHERE s."NAME" = 'your Active Sprint name here';

With the information from the above query, adjust your rule to use select the active sprint for the board in which it was created on (eg. "Active Sprint (Board_where_the_sprint_was_created)", which in the above example would be 'DEVP board').