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.

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"}.

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:

1. Uninstall the app:
   1. Navigate to Apps > Manage apps.
   2. Spot the JCMA app in the list.
   3. Click Uninstall.
   4. A notice appears indicating that the app was successfully uninstalled.
2. Stop the Jira On-Premise instance (Start and Stop Jira applications).
3. Back up your database.

4. Run the following commands on your Jira On-Premise database to obtain new commands:

   • PostgreSQL
   • MySQL
   • MSSQL
   • Oracle

   SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';

   SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';

   SELECT CONCAT('DROP TABLE "', table_name, '";') FROM information_schema.tables WHERE table_name LIKE 'AO_6FF49D_%';

   SELECT CONCAT(CONCAT('DROP TABLE ', table_name), ';') FROM USER_TABLES WHERE TABLE_NAME LIKE 'AO_6FF49D_%';

5. Run the commands resulting from the previous step to drop the JCMA tables.
6. Start your Jira On-Premise instance (Start and Stop Jira applications).
7. Reinstall the JCMA app (Install the Jira Cloud Migration Assistant).