Service Bus error in instances table in WFInstanceManagementDB

Problem

Following error is present in WorkflowStatusDetails column in Instances table for an order:

RequestorId: 43dba077-b0e2-5840-0000-000000000000. Details: An unhandled exception occurred during
the execution of the workflow instance. Exception details: System.Configuration.ConfigurationErrorsException:
Configuration is missing required information. Make sure the property 'Endpoint' is defined as part of
'Microsoft.ServiceBus.ConnectionString' key within 'appSettings' section, or Azure configuration settings.
    at Microsoft.ServiceBus.Messaging.Configuration.KeyValueConfigurationManager.Validate()
    at Microsoft.ServiceBus.Messaging.Configuration.KeyValueConfigurationManager.CreateNamespaceManager()
    at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand\`1.EnsureQueue(String serviceBusUri, String queueName)
    at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand\`1.PutCommandOnQueue(NativeActivityContext context)
    at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand\`1.OnPreComplete(NativeActivityContext context, ActivityInstance completedInstance)
    at System.Activities.Runtime.ActivityCompletionCallbackWrapper.Invoke(NativeActivityContext context, ActivityInstance completedInstance)
    at System.Activities.Runtime.CompletionCallbackWrapper.CompletionWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

This error is common when you reinstall or re-configure Workflow Manager and Service Bus or setting up a HA-solution with multiple servers.

Solution

  1. Update

    C:\Program Files\Workflow Manager\1.0\Workflow\WFWebRoot\web.config
    
    C:\Program Files\Workflow Manager\1.0\Workflow\Artifacts\Microsoft.Workflow.ServiceHost.exe.config
    

    with a correct "Microsoft.ServiceBus.ConnectionString" under appSettings key

    Use

    Get-SBClientConfiguration -Namespaces ZervicePoint | clip
    

    to get a correct Service Bus namespace

  2. Copy the config-files to the rest of the servers if needed