問題 

The Bamboo deployments are missing in the JIRA issue development panel following server migration. 

診断

Deployment data are not stored in the remotelink table, it seems to be the only development data that are stored with a URL. This may explain why it's not working. To verify if it's still using the URL from the old server, we can run this SQL query.

select * from "AO_575BF5_DEV_SUMMARY" where "JSON" like '%"ABC-1"%' and "PROVIDER_SOURCE_ID" = '4290c6tg-e21b-3f8i-b04e-hj270c4a84e5';

where ABC-1 is the affected issue key and '4290c6tg-e21b-3f8i-b04e-hj270c4a84e5' is the application key. To know the application key, run:

SELECT SUBSTR(a.property_key,16,36) as "Application Key", b.propertyvalue as "Application Name" FROM propertyentry a join propertystring b on a.id=b.id where a.property_key like 'applinks.admin%name';

原因

The deployments may still be using the old URL thus, it failed to show in the new environment. 

ソリューション

1. Delete the applinks between JIRA and Bamboo.
   
   
2. Shut down JIRA and back up the database.
   
   
3. Run this SQL query in JIRA database:

delete from "AO_575BF5_DEV_SUMMARY" where "PROVIDER_SOURCE_ID" = '4290c6tg-e21b-3f8i-b04e-hj270c4a84e5';

This will delete the development data, from Bamboo only, in all JIRA issues (they're just caches and will be repopulated)

     4. JIRA を起動する

    5. Recreate the application link

    6. Visit the issue and verify if the deployments are now visible.