How to stop a cloud migration that is stuck on App migration?

[Adam Beck]

Started a trial migration yesterday of Confluence to the cloud, the migration of our data went well however one of the apps has sat at 0% for over 24 hours.

Im not sure how to stop this process at this point so I can keep moving forward? Is there a process on the server I can kill? The migration assistant has a stop button that is grayed out. Would I also need to do anything on the cloud server?

[Lance Carnow]

There are multiple other posts about 3rd party apps being stuck during migration, and the commonality is that you should contact Atlassian support:   

https://support.atlassian.com/contact so they can assist in providing support.  While each vendor may have their resolution, it is best to log a case with Atlassian first. 

In our case, our app Zephyr Squad required help from Smartbear to diagnose via files on our server.

[Robert Wen_ReleaseTEAM_]

@Adam Beck 

Have you taken a look at the resources on the vendor's site pertaining to Cloud migration?

https://help.k15t.com/scroll-word-exporter/latest/server/migration-path-182785529.html

https://help.k15t.com/scroll-word-exporter/latest/server/migrate-export-templates-using-the-atlassian-migration-assistant-193397199.html

[Adam Beck]

Hello Robert,

I have read through this, and my plan is to attempt their alternate method that doesnt use the Cloud migration assistant for future deployments, however their site doesnt address how to stop a migration assistant run that is currently occuring on my server

[Robert Wen_ReleaseTEAM_]

You should probably contact the app vendor.  Support information is below

https://marketplace.atlassian.com/apps/24982/scroll-word-exporter-for-confluence?hosting=cloud&tab=support

Good luck!

[Adam Beck]

To give more context:

I have googled this, multiple pages point back to this link:

https://confluence.atlassian.com/cloudkb/how-to-fix-plans-that-are-stuck-and-cannot-be-stopped-during-migration-in-confluence-cloud-migration-assistant-ccma-1095245292.html

which is dead/doesnt exist

There are no errors/feedback I have seen from the assistant/logs. Nothing has popped up. The other apps migrated successfully. This one sat and didnt progress.

[Robert Wen_ReleaseTEAM_]

Which app?  If you identify it, we could probably give more assistance.

[Adam Beck]

Hello Robert, sorry didnt know the actual app mattered, just thought it was an overall process to kill. The app in question is: Scroll Word Exporter for Confluence

[Joshua Keller]

You can always use the waybackmachine website to look at archived versions of dead pages, it's saved my butt a few times: https://web.archive.org/web/20220126075345/https://confluence.atlassian.com/cloudkb/how-to-fix-plans-that-are-stuck-and-cannot-be-stopped-during-migration-in-confluence-cloud-migration-assistant-ccma-1095245292.html

Anyways, here's an improved version of the code from that page, this might help someone later if they need to set running or created (queued) migration plans to FAILED:

SELECT * FROM jira.scheduler_clustered_jobs WHERE job_runner_key LIKE '%migration%';
--DELETE FROM scheduler_clustered_jobs WHERE job_runner_key LIKE '%migration%';
SELECT * FROM MIG_WORK_ITEM
--DELETE FROM MIG_WORK_ITEM
SELECT * FROM MIG_STEP WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'
--UPDATE MIG_STEP SET executionStatus = 'FAILED' WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'
SELECT * FROM MIG_TASK WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'
--UPDATE MIG_TASK SET executionStatus = 'FAILED' WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'
SELECT * FROM MIG_PLAN WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'
--UPDATE MIG_PLAN SET executionStatus = 'FAILED' WHERE executionStatus = 'CREATED' OR executionStatus = 'RUNNING'