This error occurs during a Unify Database upgrade. The database upgrade process begins a 'Service_Broker' process on the SQL Server. If such a process is already running, the upgrade fails with the above error.
This solution involves using advanced SQL Query as well as the use of a Third Party software. Do this at your own risk or call Webgility support on 877.753.5373 for technical help.
Here is how to fix this error:
Step 1: Download the Query express Software from albahari.com.
Step 2: Connect the database of the Unify with SQL authentication.
- Username "sa"
- Password: Webgility2011
Step 3: Use UnifyDB in the sql window
Step 4: Then run the following script
- Alter database UnifyDB SET NEW_BROKER
- Alter database UnifyDB SET ENABLE_BROKER