Configure Web Client to Support SQL "AlwaysOn" Setup
About this task
Procedure
- Navigate to the installation directory, and then go to the Configuration folder:<installation-path>/plantapps-web-docker/mnt/configfiles/work-order-service/prod/2.2.2/.
-
Update this file work-order-service-prod.properties for
the following:
ConnectionStrings.PlantAppsConnection=Server=${plant.apps.db.dotnet.server};Database=${plant.apps.db.name};User Id=${plant.apps.db.username};Password=${plant.apps.db.username.password};connect timeout=100
ConnectionStrings.WorkOrderConnection=Server=${plant.apps.db.dotnet.server};Database=${plant.apps.db.name};User Id=${plant.apps.db.username};Password=${plant.apps.db.username.password};connect timeout=100
-
Replace with the following:
ConnectionStrings.PlantAppsConnection=Server=${plant.apps.db.dotnet.server};Database=${plant.apps.db.name};User Id=${plant.apps.db.username};Password=${plant.apps.db.username.password};connect timeout=100;MultiSubnetFailover=Yes
ConnectionStrings.WorkOrderConnection=Server=${plant.apps.db.dotnet.server};Database=${plant.apps.db.name};User Id=${plant.apps.db.username};Password=${plant.apps.db.username.password};connect timeout=100;MultiSubnetFailover=Yes
-
Enter the following commands to Restart Work order services:
sudo docker service scale PAworkorder_workorder=0
sudo docker service scale PAworkorder_workorder=1