Service broker is a communication service that is used by the Solver Private Host app. It monitors completion of tasks between multiple applications.
What causes service broker to fail and error out?
If you restored the repository database on the SQL server or turn off the SQL server service and then enable it, then service broker is disabled and would need to be enabled. You may get following error message on web portal or something related to service broker.
How Service Broker used in PH?
Here is a cycle that explain the process that Private host goes through when running a report.
How to enable Service Broker?
1. Check if service broker is enabled first before making any changes. Here is the query to verify if service broker is enabled.
SELECT is_broker_enabled FROM sys.databases WHERE name = 'Solver_Repository';
If the result is 1 then service broker is enabled and nothing needs to be done. If it returns 0 then Service Broker is disabled and needs to be enabled.
2. To enable Service Broker, it requires you to put the repository into single user mode, start service broker, and then put the repository back into multi-user mode.
NOTE: Please make a backup of the Repository database prior to making any of these changes. Please only do this when no other users is using the Solver Portal.
- Single user mode query.
- USE master; GO ALTER DATABASE Solver_Repository SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
- Run this query to enable the service broker on the database.
- ALTER DATABASE Solver_Repository SET ENABLE_BROKER;
- Multi user mode query:
- ALTER DATABASE Solver_Repository SET MULTI_USER; GO
Below is an articles that has service broker referenced.
Applies to: Private Host 5.x