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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

503 views 1 18
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