How to fix incomplete MSSQL DB Migration

Owned by Dimi
Last updated: Feb 13, 2022
1 min read

Affecting only migrations from old version of plugin and only MSSQL DB

The problem:
Some of the MSSQL DB versions don’t support migration field type and the plugin doesn’t have direct access to the database, only through the active objects, which leads to incomplete migration.

Symptom:
After the update to the newest version plugin shows “you have no permission to access the plugin“.

The fix:
1. Execute this command on your Jira DB. The AO* tables are the plugin tables so no data will be corrupted/lost.

alter table AO_338ACC_TASK drop constraint df_AO_338ACC_TASK_GRADE;

2. Re-install the plugin.