We recently migrated from MOSS 2007 to SP 2010 platform. We have this heavily used SharePoint Designer workflow(500 and more instances per day). (uses infopath to submit data) It is basically an serial Approval workflow involving many approval levels. Post migration almost 90% of our workflow end in "Error Occurred" state with the following description of the error: The workflow could not update the item, possibly because one or more columns for the item require a different type of information.
I have searched a lot of websites and msdn, tried possibly all solutions given, but none seems to work.There is no set pattern for the workflows that result in error and restarting the workflow always resolve the issue.
We have matched all columns/content type and there is no difference in MOSS 2007 and new forms library
Permission levels of Users are not changed
A lot of sites mention introducing a pause in the workflow before update event, but I am skeptical in doing it.What could be the possible cause/solution to it? we cannot identify anything that is common or direct us to the root cause among these 90% failing workflows. Some of the workflow instance also result in error, the workflow could not update the item as it was checked out to another user.
Any help would be highly appreciated.