Cannot Delete Integration: is it possible from database ?
Hello,
I have a rather odd issue when trying to delete a synchronisation job (New Integration).
When I try to delete (or even stop) the task I get a message:
"Stopping connector instance with key CON-2-CYS"
Wich result in "Failed to stop connector instance with key INT-2 for integration CON-2-CYS: null"
This is really annoying because the synchronisation configuration is incorrect and the job is running. Any attempt to alter the configuration will result in the same error, and will not be taking into account.
I think there is an issue with the key generated: CON-2-CYS (It's not consistent with my other instances of Jira where the key is systematicaly > 10)
The best solution for me would be to find a way to delete an integration directely from the database, that would be really neat.
Alternatively, i would like to try to find this key in the database and try to change it for, let's say CON-20-CYS and see how it goes. Do you have any info on the table I need to query ?
I have limited access to the Jira instance encoutering the issue so I would like to avoid taking too many troubleshooting steps and rather adopt a more radical way of solving the issue.
Thank you for your help.
-
Okay, for anyone interested I've found the table that seem to reference this CON-2-CYS key.
The table is AO_A912D8_CONNECTOR_CONFIG.
But while watching the DB structure, I had the idea to just uninstall and re-install the plugin to check if those table aren't removed and re-created. I'll let you know how it goes.
-
Okay so I uninstalled and re-installed the plugin Backbone Issue Sync.
After that I was able to delete the synchronisation (Integration) without any issue.
Hope this will help someone.
Edit: disabling the faulty synchronisation did not make it stop. If this happens to you: change the password for your Synchronisation User. It will stop any previous synchronisation from running.
-
Hi,
Great to hear that you found a solution to your issue. Also, thanks for sharing – I'm sure it will be useful for anyone facing the same problem.
If you'd like us to have a look at why the integration couldn't be removed, please send a Backbone support ZIP to support@k15t.com and we'll investigate.
Cheers, Tom.
Please sign in to leave a comment.
Comments
3 comments