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 votes
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 votes

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 votes

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,175 views 13 19
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot