Home > Uncategorized > Fix Workflow Manager issue with SP 2013

Fix Workflow Manager issue with SP 2013

September 5, 2014 3:30 pm Leave a comment Go to comments

Error processing management request. Method: GET, RequestUri: http://abcuniversity:12291/$Workflows/$Instances?$skip=0&$top=100&monitoringParameter=a6749fb1-2c34-48e0-917f-23ddfd291bb8, Error: System.Data.SqlClient.SqlException (0x80131904): The procedure “GetInstances” has no parameter named “@OtherWorkflowStatus”.

at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result)

at Microsoft.Workflow.Gateway.HttpAsyncResult.End[TAsyncResult](IAsyncResult result)

at Microsoft.Workflow.Gateway.WorkflowServiceGateway.<>c__DisplayClass9d.<EndGetInstances>b__9c()

at Microsoft.Workflow.Gateway.WorkflowServiceGateway.ExceptionFilter[T](Func`1 body)

at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)

ClientConnectionId:ef622ba6-f4b9-4713-8437-dd7926fb089b

  • Leave the WFM (Workflow Manager) farm using the WFM config tool
  • Uninstall WFM, Service Bus, and the CU’s from control panel
  • Uninstall Workflow Manager Client if it exists in the control panel, it didn’t in mine
  • Delete the following databases in SQL Server:
    • SbGatewayDatabase
    • SbManagementDB
    • SBMessageContainer01
    • WFInstanceManagementDB
    • WFManagementDB
    • WFResourceManagementDB
  • Delete the workflow proxy service in Central Admin (important)
    • Application Management > Manage Service Applications
    • Highlight (select) the Workflow Service Application Proxy service (don’t click the hyperlink)
    • Select “Delete” from the ribbon.
  • Restart the server

ReInstall using

http://msdn.microsoft.com/en-US/library/dn201724

 

  • Enable the workflow proxy service in CA for the web app, the 2013 workflow option will not show up in SPD unless you do this.
  • Application Management > Manage Web Applications
  • Select your web app
  • Select “Service Connections” from the ribbon
  • Check the Workflow Service Application Proxy item and click “OK”

Register-SPWorkflowService -SPSite “http://testmoo&#8221; -WorkflowHostUri “http://testme:12291/”  -Force

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: