Configure Web Client to Support SQL "AlwaysOn" Setup

About this task

Be sure to follow the steps below to enable SQL "AlwaysOn" support. Even if not setup across multiple subnets, you still should configure the SQL Always On option. With this setup, the MultiSubnetFailover parameter should always be set to Yes. If the DNS returns multiple names, without this option configured, you might run into issues.

Procedure

  1. 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/.
  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
  3. 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
  4. Enter the following commands to Restart Work order services:
    sudo docker service scale PAworkorder_workorder=0
    sudo docker service scale PAworkorder_workorder=1