I have a SharePoint 2010 workflow set to run on item creation & change. While this workflow runs good for 90% of the time, at items it "Fails on start(retrying)". The error in Workflow history list would be "The workflow could not update the item, possibly because one or more columns for the item require a different type of information". For the same list item, it runs fine if the error instance is terminated and the workflow is restarted.
To debug I added "Log to workflow list" as 1st line of the workflow and after every action. But whenever the workflow fails, the log at 1st line doesn't get added to history list.
Does this mean the workflow fails during logging?
There are no errors if a pause is added at first. But the paused instance will restart after 5 mins only. This is unacceptable from business.
What could be the possible reason for the failure? Is there anyway I could loop within the workflow for 5-10 seconds, since a few sec pause seems to fix this?
Experts help please.
UPDATE: This workflow usually start while some other workflow makes change to the list item.