The Recovery Procedure for a Site Server That Was Part of a Spooler Controller Group

This page describes the recovery of a single Site Server from a Spooler Controller group which was installed using a Server installer package – the Site Server deployment scenario. It is expected that the server is no longer functional and a new one will be used to replace it.

This guide assumes that you have a backup of databases and a backup of configuration (and binary) files available.

Jobs stored on the non-functional server will be lost and users will need to submit them again.

Site Server Recovery

  1. Prepare a server (or a virtual machine) with the same hostname/IP as the original Site Server had used.

  2. Check the backup of the configuration files and note the following:

    1. Which optional features were installed:

      1. Mobile Print Server – the MPS folder is available in backup files.

      2. Dispatcher Paragon Payment System – the YPS folder is available in backup files.

    2. Site Server GUID (SPOC GUID). It is noted in the guid.conf file as the value of the LocalGUID option. For example:

      backup\SPOC\conf\modules\guid.conf
      localGUID = ectp5o8ep0op3hzi
  3. Reinstall Site Server using the same build installation package.

    1. Enable optional features if they were used before (see step 2.a).

    2. Configure the connection to Management Server(s) the same way as was configured before.

    3. Provide the wizard with the same Site Server GUID that was used before (see step 2.b).

    4. Finish the installation.

      See Site Server Deployment for a detailed procedure.

  4. If Dispatcher Paragon Payment System with an embedded PostgreSQL database was installed on the Site Server that is being restored, perform the following steps:

    1. Stop almost all Dispatcher Paragon services after installation is finished.

      1. Leave only the YSoft Bundled PostgresSQL 11 service running.

      2. Stop all other Dispatcher Paragon services.

        • You can use the following PowerShell script to perform the task:

          Get-Service *YSoft* | Where-Object {$_.Name -notmatch 'YSoftPGSQL'} | Stop-Service
    2. Run the pgAdmin administration tool <DispatcherParagon_DIRECTORY>\PGSQL\bin\pgAdmin4.exe (e.g., c:\DispatcherParagon\PGSQL\bin\pgAdmin4.exe)

    3. In the Object browser window, double-click the SafeQ 6 item and connect to the server

      1. Delete the current SQDB6_YPS database:

        images/download/attachments/284928355/YPS-version-1-modificationdate-1630589444857-api-v2.png


      2. Create a new SQDB6_YPS database:

        1. Right-click Databases > Create > Databese...
          images/download/attachments/284928355/Recovering_2-version-1-modificationdate-1630589444843-api-v2.png

        2. Create a new SQDB6_YPS database with Owner set to postgres:

          images/download/attachments/284928355/YPS_2-version-1-modificationdate-1630589444830-api-v2.png


      3. Restore SQDB6_YPS database from the backup file:

        1. Right-click the database name and select Restore... option.

          images/download/attachments/284928355/YPS_3-version-1-modificationdate-1630589444823-api-v2.png


        2. Select your backup file

          images/download/attachments/284928355/YPS_4-version-1-modificationdate-1630589444810-api-v2.png


        3. Click Restore.

        4. The backup will be restored.

        5. Popup appears with information that procedure ended successfully

          images/download/attachments/284928355/YPS_6-version-1-modificationdate-1630589444773-api-v2.png
        6. Click on More details to see log.

    4. Start Dispatcher Paragon services with the Automatic startup type again.

      Do not start the Dispatcher Paragon Spooler Controller Group Service. It will be started by the Dispatcher Paragon Spooler Controller service when the proper configuration is ready.

      • You can use the following PowerShell script to perform the task:

        Get-Service *YSoft* | Where-Object {$_.Name -ne 'YSoftSQ-SPOCGS'} | Start-Service


  5. Restore the customized configuration:

    1. If you had services running under a specific domain account, set it up again.

    2. If you used customized scripts on the server (e.g., for batch files launched by Rule-Based Engine or customized batch files used by Workflow Processing System), restore those scripts from backup.

    3. If you used a customized configuration (such as your own certificates for the web services), seek the relevant documentation and set up the configuration again.

  6. Check the Management Web interface, the Spooler Controller must be correctly shown as online.

  7. Reinstall all Dispatcher Paragon Embedded Terminals that are managed by the affected Spooler Controller.

Spooler Controller Group Verification

If the failover for Embedded Terminals is being used and the parameter enableEtcd is enabled, then the etcd cluster in Terminal Server must also be reconfigured

  1. Follow Reconfiguring or Recovering an etcd Cluster in Terminal Server.

Check the number of Site Servers forming the Spooler Controller group using JConsole

Please do no change anything in the MBeans tab. Just check the values in the Attributes leaf.

  1. Run <DispatcherParagon_DIRECTORY>\SPOC\utilities\sqjconsole.bat

  2. Connect to a Site Serverthat is a member of the target Spooler Controller group on port 9999.

    images/download/attachments/284928351/New_Connection-version-1-modificationdate-1526911661830-api-v2.PNG
  3. Confirm the Insecure connection.

    images/download/attachments/284928351/Insecure-version-1-modificationdate-1519828196597-api-v2.PNG
  4. Switch to MBeans tab.

  5. Expand distCache > CacheManager > DefaultCacheManager > CacheManager and select Attributes.

  6. Check the value of clusterSize – it must correspond to the number of Site Servers in the desired Spooler Controller group.

    images/download/attachments/284928351/clusterSize_highlighted-version-1-modificationdate-1519828196413-api-v2.PNG