Considering using a scheduled automation to make 50,000 edits over night

Question

We have the desire to move all the data in Field A (custom field) to Field B (system field). It looks to be in excess of 50,000 issues using data in Field A.

One plan I had considered was writing one base Automation Rule, and then splitting it up into pieces to run in [~15] minute intervals, each with their own JQL to limit the number of issues closer to 2,000 issues.

There are other configurations (Screens, Boards, Dashboards, Automations) that I need to make as part of this switchover.

My thought is making 50,000 edits is the biggest challenge of the project, and if I could get those to fire overnight when our users are not working and outside the bounds of other Automations, it allows me to do the hardest part in the middle of the night (without actually being awake), and I can make my two sets of configuration changes the night before and first thing in the morning.

Thoughts? Has anyone done this? My backup is creating a number of import files but that makes me nervous and I'd likely have to sit at my computer fiddling my thumbs for large periods of time watching each import.

Mikael Sandberg · Accepted Answer

You would have to divide your rules up in no more then 1000 issues, if you go above 1000 issues in your rule it will be throttled. You can learn more about the service limits here.

I have done this in the past where I had to update about 20k issues, and used a JQL that returned no more then 1000 issues.

Bill Sheboy · Accepted Answer

Hi @Alex Hall

Adding to Mikael's suggestions:

Here is the cloud version of the automation limits and packaging guidelines:

* https://support.atlassian.com/cloud-automation/docs/automation-service-limits/
* https://www.atlassian.com/blog/announcements/cloud-automation-packaging-update

A rule like this needs caution regarding at least the Issue Searched limit and the Daily Processing Time per day limit.

First thing: I recommend adding a global rule to your instance, triggered on the Service Limit Breached trigger, and which sends you an email as the limit approaches.  With that, the site admins can proactively log in and disable the rule if something goes wrong.  https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Service-limit-breached

It is probably a good idea to leave this rule in place at all times, including the smart values of {{breachedSummary}} and {{breachedRules}} in the email alert, to watch for problems in usage and rule execution.

Next, I recommend running a scheduled trigger rule with JQL to test for a value in your Field B (i.e., destination value), and so the rule will stop processing issues when all of the issues are updated, and then the rule may be disabled.

One key is the scheduling frequency to prevent throttling.  To check this, I recommend:

* check the Atlassian status pages to confirm there are no outages before trying the data migration: https://status.atlassian.com/
* create the rule, enabling it with a schedule of once per day
* manually trigger the rule, and confirm the actual processing time
* decide what an appropriate buffer would be, and then change the rule frequency to that schedule

Kind regards,
Bill