Hello! So the problem that I'm facing is that on a JIRA Cloud instance I am unable to assign a workflow to a project. The procedure that I am following is:
When I do this the whole screen is disabled and I get the following error: "The JIRA server was contacted but has returned an error response. We are unsure of the result of this operation."
Thanks for any help you may offer and let me know if I can provide more information.Screenshot from 2015-09-17 14:17:10.png
So I was getting the same issue for this problem after doing a restore of a system. However, here is what I did to resolve my issue.
1. I went and checked the atlassian-jira.log file. (This location will vary depending on the OS you are using. I am using Windows OS which that file is located at: C:\Program Files\Atlassian\Application Data\JIRA\log\ )
2. I replicated the error and then went to the bottom of the log file. Towards the bottom I found a possible culprit.
There are more than one workflows associated with 'BACKUP of TEST' in the database!
3. Since my DB is running in a MSSQL instance I used SQL Server Management Studio and looked into the tables that the JIRA installer created. I found the following table [jiraworkflows] and used the following query:
select * from [A].[jiraworkflows]
***MAKE NOTE OF THE RECORD ID WHICH IS THE DUPLICATE RECORD***
4. I found the duplicate record entry and then ran the following query to delete one of the duplicate record ids:
delete from [A].[jiraworkflows] where id = 10508
5. After deleting that record ID I refreshed the page to see the workflows, and voila....it worked!
This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs