Error Message in Service Desk when Respond to Customer

Getting an intermittent error message in JIRA SD (online version)   

This occurs when hitting the respond to customer button.  I thought I'd messed up the workflow, but I just built a brand new Service Desk project and it happens there too.  

"could not find workflow instance #.........." 

 

It's an intermittent problem, or at least I cannot figure out the sequence yet. 

any help on what's going on would be appreciated. 

 

 

Capture.PNG

Could not find workflow instance #32555: root cause: SQL Exception while executing the following:SELECT NAME, INITIALIZED, STATE FROM public.OS_WFENTRY WHERE ID=? (ERROR: current transaction is aborted, commands ignored until end of transaction block)

Could not find workflow instance #32555: root cause: SQL Exception while executing the following:SELECT NAME, INITIALIZED, STATE FROM public.OS_WFENTRY WHERE ID=? (ERROR: current transaction is aborted, commands ignored until end of transaction block)

4 answers

0 vote
Boris Berenberg Community Champion Dec 18, 2014

My guess is something is wrong with your DB config which is causing DB inconsistency. Please file a support request at: https://support.atlassian.com/ and we can dig deeper into the issue. Please provide a full set of logs by going to Administration -> System -> Atlassian Support Tools -> Support Zip -> Create. Please make sure that the boxes for all the log files are checked. This helps to reduce the amount of back and forth to get the information we need to resolve your problem. 

0 vote

Try to run the Integrity Checker and see if it reports any workflow integrity issues. You can fix the error on the UI if it finds any.

If integrity checker is not finding any, raising a support request is the best option.

0 vote

We had one similar case where the database was encoded in another encoding than UTF8.

Can you confirm if that's not the culprit here?

Cheers,
Andre 

Can you suggest a solution or workaround for this issue? We are experiencing the same issue, but not in JIRA Service Desk.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

70 views 0 5
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you