SharePoint Workflows That Are Manually Started Fail with the Error “The data source control failed to execute the insert command”

Even when you have workflows that work fine when they are fired due to an event (a new item or a change to an existing item), you may receive the error "The data source control failed to execute the insert command" when you start them manually. Usually you start workflows in a SharePoint site manually…