Install Decision in an existing Hub environment
We didn't add Decision when we installed/upgraded Hub to 4.7, but we now want to use it. How do we install it?
You will need to carry out the steps in Generate an SSL Certificate and Install the Blue Prism Decision Model Service. Then you need to update the Hub appsetting.json file with the Decision connection strings.
The information below describes updating the Hub appsettings.json file. Caution must be taken to only amend the information provided, any other changes may break your existing system. Changes to the appsettings.json file should be made in conjunction with Blue Prism to ensure your system is supported.
To update the appsetting.json file to include Decision:
Open Windows Explorer and navigate to C:\Program Files (x86)\Blue Prism\Hub\appsettings.json.
This is the default install location – adjust this if you have used a custom location.
- Open the appsettings.json file in a text editor.
This is not the only setting you will see under BluePrismDecision. However, it is the only one that needs to be changed.
Using the Blue Prism Data Protector Tool in PowerShell, create and encrypt the connection string for the Decision database, for example:
If you want to use SQL Authentication:Copy
.\BluePrismDataProtector.Console.exe protect -v "Data Source=[SQL Server];Initial Catalog=BluePrismDecisionDB;User Id=[user name, for example, sqladmin];Password=[password];Max Pool Size=500;MultiSubnetFailover=True;" -p ".\"
If you want to use Windows Authentication:Copy
.\BluePrismDataProtector.Console.exe protect -v "Data Source=[SQL Server];Initial Catalog=BluePrismDecisionDB;Integrated Security=True;Max Pool Size=500;MultiSubnetFailover=True;" -p ".\"
Where you replace:
[SQL Server] = The SQL Server that will host the database.
[user name, for example, sqladmin] = The SQL user name (SQL Authentication only)
[password] = The password for the SQL user (SQL Authentication only)
If required, you can enter a different database name for the Initial Catalog parameter. BluePrismDecisionDB is the default name.
The settings above are equivalent to the values you would enter on the Configure Blue Prism Decision SQL connection screen in the Hub Install Wizard.
The Decision database will be created when you install the Decision plugin in Hub.
- Copy the encrypted string between the "" next to the ConnectionString setting in the Hub appsettings.json file, shown in step 3.
- Save the file.
Locate the following section in the same appsettings.json file:Copy
Between the "" next to the CertificateThumbprint setting, enter the thumbprint for the SSL certificate.
If you are using Windows, you can find this using Manage Computer Certificates, double-click the Certificate and Thumbprint is on the Details tab.
- Between the "" next to the v1 setting, enter the URL for the Blue Prism Decision Model Service.
- Save and close the file.
Open Internet Information Services (IIS) Manager.
In the list of connections, select Blue Prism - Hub.
This is the default site name – if you have used a custom site name, select the appropriate connection.
Click Restart from the Manage Website controls.
- Add Decision to the hosts file. For more information, see Decision DNS resolution.
The next steps are to complete Install the Decision plugin and Configure access to the Decision plugin. However, before you install the plugin, you will need to temporarily provide dbcreator or sysadmin SQL Server permissions to the login used for the Application Pool Blue Prism – Hub, this login will depend on the option selected when you installed Hub:
- SQL Server Authentication – The SQL user who was specified during the install.
- Windows Authentication – The Windows service account associated with the Application Pool Blue Prism – Hub.
The Decision database is created when the Decision plugin is installed in Hub. After this, the dbcreator or sysadmin permissions can be removed.
OpenSSL script fails
If the OpenSSL script fails, add OpenSSL to Path environment variable and then try running the script again.
- From the Windows taskbar, open Control Panel.
Select System and Security, then select System, and then click Advanced system settings.
The System Properties dialog displays.
Click Environmental variables.
The Environment Variables dialog displays.
In the System variables group, select Path, and then click Edit.
The Edit environment variable dialog displays.
- Click New and on the new line, enter the path to OpenSSL. The default location is C:\Program Files\OpenSSL-Win64\bin.
Click OK to save the changes.
500 error received when using Decision
This error may be seen if you are running the Decision Model Service as a Windows service on a different server to Blue Prism Hub. It indicates that communication between the servers cannot be established and is most likely due to a firewall. You need to allow requests on the port where the Decision Model Service is running to establish communication. The way to do this will depend upon the firewall you are using. The example below describes how to create an Inbound Rule for the Windows Defender Firewall:
Open the Group Policy Management Console to Windows Defender Firewall with Advanced Security.
In the navigation pane, click Inbound Rules.
Click Action, and then click New rule.
The New Inbound Rule Wizard displays.
On the Rule Type page, select Port, and click Next.
- On the Protocols and Ports page, select TCP and enter the port that is configured for Decision Model Service, for example, 50051, and then click Next.
- On the Action page, select Allow the connection, and then click Next.
- On the Profiles page, select the network location types that should be allowed to access the service, and then click Next.
- On the Name page, enter a name and a description that allows easy identification of the rule, for example, Allow Decision Model Service Connection and then click Finish.