JIRA Agile is currently unavailable error when Restoring the JIRA Cloud backup to JIRA 6.4.5 with JIRA Agile 6.7.4

Summary

When restoring JIRA Cloud backup to JIRA 6.4.5 and JIRA Agile 6.7.4, the following error message was shown in the UI.

Steps to reproduce

1. Setup JIRA 6.4.5 with JIRA Agile 6.7.4
2. Restore the Cloud Backup

Expected Result

The data is restored and Agile is working

Actual Result

JIRA Agile is not working, the below error is thrown

Workaround

1. Stop JIRA
2. Reset the upgrade tasks for JIRA Agile plugin to number 47, which is the task BEFORE version 6.7.5:

   UPDATE propertynumber SET propertyvalue = 47
   WHERE id = (SELECT id FROM propertyentry WHERE property_key = 'GreenHopper.Upgrade.Latest.Upgraded.Version');
   UPDATE propertystring SET propertyvalue = '47'
   WHERE id = (SELECT id FROM propertyentry WHERE property_key = 'com.pyxis.greenhopper.jira:build');
   

3. Restart JIRA

Kindly remember to generate JIRA Backup before performing any changes in the database