I'm in the process of doing some trial upgrades from SharePoint 2007 to 2010 and the workflows in my 2007 environment started failing. When a previously running workflow attempted to do something it'd error:
@WorkflowData is not a parameter for procedure AddWorkflowProgress
Any attempts to restart workflow give the message:
@WorkflowData is not a parameter for procedure CreateWorkflowInstance
I also noticed that in the 2007 environment the Database Version (Central Admin --> Nintex Workflow Management --> Database Setup) showed 2.0.1.4 instead of 1.something. Turns out I forgot to change the server and database name in the Nintex Workflow database in the 2010 environment. I quickly changed it in the 2010 environment and restarted IIS.
To fix the 2007 environment I opened up the Database Setup clicked Edit, verified the server and database then clicked OK. It must have worked since my database version was back to 1.0.4.0 and when I started workflows they actually started instead of erroring. I terminated errored workflows (including scheduled) and restarted the necessary ones.
