SQL Zombie Transaction
I am having a issue with a workflow that pulls data from a database and then inserts a new line and deletes the old one. What happens is the users update a Sub Task in our Project workflow, this first time they do this it just takens them right to the fill in you details (Work Done) Field, any time they go to this sub task after that they get a drop down list asking them to select the last comment they entered (We have done this due to a problem we where having with when going back into sub task some times the last entered thing would be there and some time it would be gone) this works fine for the first 5 times they do this but every time on the 6th attempt they get a error message "Error in Reassignment SmartTask" when looking at the logs the error message reads
"System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.SaveObject(Object o)"
I have had a look about on the web for a soulition and althought i can find a lot about what a Zombie task is i can't find much in the way of resolving the issue.
Workflow Version 7.1.1401.59