Edit

Upgrade from v9.3.3 to v9.3.4

The guide describes the upgrade from 9.3.3 to 9.3.4 version of WorkFusion SPA.

Prerequisites

• You have WorkFusion SPA 9.3.3 up and running.
• No Business Processes are running.

Preparation steps

Before you start:

On the DB server, ensure that WorkFusion's nexus.user and nexus.password secure properties correspond to configuration variables workfusion_nexus_admin and workfusion_nexus_admin_pass.

To verify this, on the DB server execute the following commands as runtime user (wf_user):

$ loader.sh workfusion review | grep nexus.user
$ loader.sh workfusion review | grep nexus.password

If the returned values are not the same as workfusion_nexus_admin and workfusion_nexus_admin_pass:

1. Create the workfusion-secure.properties file that will contain these values. Example: nexus.user=admin nexus.password=adminpassword.

2. Run the following command. For more details, see Manage secure properties.

   $ loader.sh workfusion workfusion-secure.properties
   

Download and extract patch

Connect to the APP and DB servers via SSH and run the following commands as runtime user (wf_user):

1. Change the directory, create the patches directory, and download the patch:

   $ export INSTALL_DIR=/opt/workfusion
   
   $ cd $INSTALL_DIR
   $ mkdir patches
   $ cd patches/
   $ curl -o 'patch_9.3.3-9.3.4.tar.gz' '<patch download url>'
   

   If the Internet access is not available on the APP server, download the patch to the patches directory with any available method.

2. Extract the patch:

   $ tar xzf patch_9.3.3-9.3.4.tar.gz
   

   After the extraction, you'll see the patch_9.3.3-9.3.4 directory with two files inside:

   $ ls -la
   drwxrwxr-x.  2 wfuser wfuser        58 Oct 21 17:06 patch_9.3.3-9.3.4
   -rw-rw-r--.  1 wfuser wfuser 247901699 Oct 21 17:06 patch_9.3.3-9.3.4.tar.gz
   
   $ ls -la patch_9.3.3-9.3.4/
   -rwxrwxr-x. 1 wfuser wfuser 4255 Nov 20 14:01 patch_9.3.4.sh
   drwxrwxr-x. 2 wfuser wfuser  168 Nov 20 09:06 sources
   

Apply patch 9.3.4

To apply the patch:

1. On the DB server, create backup directories:

   $ cd patch_9.3.3-9.3.4
   $ mkdir -p ../../_migrations/workfusion/environments/
   $ mkdir ../../backup
   

2. Open the development.properties.sample file and specify your MySQL credentials in it:

   $ vi sources/development.properties.sample
   

   Also, in the file, replace the driver_path=/opt/workfusion/_migrations/drivers line to:

   driver_path=$install_dir/_migrations/workfusion/drivers #here $install_dir - is path to the folder where WF is installed)
   

3. Copy the contents of the development.properties.sample file to development.properties.

   $ cp -p sources/development.properties.sample ../../_migrations/workfusion/environments/development.properties
   

4. On the DB server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh update_db
   
   ## You will see the similar output:
   Wed Nov 20 14:03:17 UTC 2019 Copying new db migrations
   Wed Nov 20 14:03:20 UTC 2019 Running db migrations
   ------------------------------------------------------------------------
   -- MyBatis Migrations - pending
   ------------------------------------------------------------------------
   WARNING: Running pending migrations out of order can create unexpected results.
   ------------------------------------------------------------------------
   -- MyBatis Migrations SUCCESS
   -- Total time: 0s
   -- Finished at: Wed Nov 20 14:03:21 UTC 2019
   -- Final Memory: 20M/479M
   ------------------------------------------------------------------------
   Wed Nov 20 14:03:21 UTC 2019 DB migrations update complete. Proceed with Control Tower steps.
   

5. On the APP server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh update_ct
   
   ## You will see the similar output:
   Wed Nov 20 13:56:43 UTC 2019 Updating to version: 9.3.4
   Wed Nov 20 13:56:46 UTC 2019 Stopping Control Tower
   workfusion: stopped
   Wed Nov 20 13:57:02 UTC 2019 Updating Control Tower artifact...
   Wed Nov 20 13:57:06 UTC 2019 Cleanup Control Tower Tomcat context directory...
   Wed Nov 20 13:57:09 UTC 2019 Update automation bp configs
   Wed Nov 20 13:57:12 UTC 2019 Updating Control Tower properties file
   Wed Nov 20 13:57:15 UTC 2019 Updating nginx configuration file
   

6. On the APP server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh start_ct
   
   ## You will see the similar output:
   Wed Nov 20 14:03:50 UTC 2019 Starting Control Tower
   nginx: stopped
   nginx: started
   workfusion: started
   Wed Nov 20 14:03:56 UTC 2019 Patch complete. It might take Control Tower about 5 minutes for startup.
   

Verify update

To verify that the update is successful:

1. Go to Control Tower UI and verify that a test business process can be successfully executed.
2. In a web browser, go to the URL <CT host>/workfusion/secure/task/new?actTab=usecase and ensure that there is the CMT Automation use case group with two use cases inside.
3. In a web browser, go to the URL <CT host>/workfusion/secure/business-process/new and ensure that there is the CMT Automation use case group with one use case inside.

Roll back to 9.3.3

To roll back to a previous version:

1. On the APP server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh rollback_ct
   
   ## You will see the similar output:
   Wed Nov 20 14:10:49 UTC 2019 Rollback to version: 9.3.3
   Wed Nov 20 14:10:52 UTC 2019 Ensure Control Tower is stopped...
   workfusion: stopped
   Wed Nov 20 14:11:05 UTC 2019 Restore Control Tower from backup...
   Wed Nov 20 14:11:06 UTC 2019 Cleanup Control Tower Tomcat context directory...
   

2. On the DB server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh rollback_db
   
   ## You will see the similar output:
   Wed Nov 20 14:12:38 UTC 2019 Rolling back db migrations
   ------------------------------------------------------------------------
   -- MyBatis Migrations - down
   ------------------------------------------------------------------------
   ========== Undoing: 20190408194310_Add_MachineConfigBundle#checksum.sql ========
   
   ------------------------------------------------------------------------
   -- MyBatis Migrations SUCCESS
   -- Total time: 0s
   -- Finished at: Wed Nov 20 14:12:38 UTC 2019
   -- Final Memory: 20M/479M
   ------------------------------------------------------------------------
   Wed Nov 20 14:12:39 UTC 2019 DB migrations rollback complete. Proceed with Control Tower steps.
   

3. On the APP server, go to the patch_9.3.3-9.3.4 directory and run the following command:

   $ ./patch_9.3.4.sh start_ct
   
   ## You will see the similar output:
   Wed Nov 20 14:03:50 UTC 2019 Starting Control Tower
   nginx: stopped
   nginx: started
   workfusion: started
   Wed Nov 20 14:03:56 UTC 2019 Patch complete. It might take Control Tower about 5 minutes for startup.