"There was a problem retrieving your plans" error message
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Learn what to do when you see the error message "There was a problem retrieving your plans" while using the Jira Cloud Migration Assistant (JCMA).
Overview
This error in the JCMA interface follows with the below signatures in the application log file atlassian-jira.log, and in the HTTP Archive (HAR) file.
atlassian-jira.log
1
2
3
4
5
ERROR user 1102x334925x3 ifmfvc 10.60.6.200,127.0.0.1 /rest/migration/latest/plan [c.a.j.m.plan.rest.PlanRepositoryExceptionMapper] Error occurred when working with plans
com.atlassian.jira.migration.plan.rest.FetchPlanListException: Error occurred when trying to fetch plan list
...
Caused by: java.util.concurrent.ExecutionException:
com.atlassian.jira.migration.httpclient.exceptions.UnexpectedStatusCodeException: Received an unexpected status code; expected [200], but received 401: {"code":401,"message":"Unauthorized"}.HAR
1
2
3
4
5
6
Server's response
Full response:
500 Internal Server Error:
{
"errorCode": "PLAN_LIST_FETCH_ERROR"
}Solution
Uninstall and safely delete all the app data with the below steps:
Uninstall the app:
Navigate to Apps> Manage apps.
Spot the JCMA app in the list.
Click Uninstall.
A notice appears indicating that the app was successfully uninstalled.
Stop the Jira On-Premise instance (Start and Stop Jira applications).
Back up your database.
Run the following commands on your Jira On-Premise database to obtain new commands:
PostgreSQL
1SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';MySQL
1SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';MSSQL
1SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';Oracle
1SELECT CONCAT(CONCAT('DROP TABLE ', table_name), ';') FROM USER_TABLES WHERE TABLE_NAME LIKE 'AO_6FF49D_%';Run the commands resulting from the previous step to drop the JCMA tables.
Start your Jira On-Premise instance (Start and Stop Jira applications).
Reinstall the JCMA app (Install the Jira Cloud Migration Assistant).
Was this helpful?