Error Message from above image in text:

A MySQL upgrade is required on before you can continue.  Return to upgrade this appliance once this remote database has been updated.  IMPORTANT!!!  The appliance is connected to a remote database server:  You must upgrade MySQL on this remote server to MySQL 5.6.16.  The user must use DBMS utility installer to upgrade the remote database server FIRST no matter the database configuration is configured on the same server or on the remote server before they can upgrade Clearwell product.  Otherwise upgrade installation will fail.

Error Message from log:

cluster-admin_upgradeBootInfo log

cluster-admin:
     [echo] Starting Cluster Admin utility
     [echo] Args = upgradeBootInfo ${build.arg2} ${build.arg3} ${build.arg4}
     [java] error:
     [java] com.teneo.esa.cluster.ClusterException: [#156001] Unable to read cluster boot entry for PRIMARY boot mode of namespace
     [java] at com.teneo.esa.cluster.ClusterException.errorRetrievingBootInfo(ClusterException.java:64)
     [java] at com.teneo.esa.cluster.BootInfo.upgradeBootInfo(BootInfo.java:665)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.upgradeBootInfo(ClusterAdminTool.java:220)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:729)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:1208)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:1224)
     [java] Caused by: com.teneo.esa.common.database.PersistenceException: [#80031] JDBC get connection failed : Communications link failure

 

Cause

When upgrading a clustered environment where the database is remote the new database version has to be installed before the upgrade takes place.

Solution

Install DBMS for the Shared Remote Database
Prepare the shared remote database server

1. Ensure that the Clearwell appliance and MySQL remote database server are configured with the same date/time, and time zone.
     Note: If the time zone on the appliance, MySQL remote database, and local database are not all set correctly, issues can occur during migration of the local database data to the shared remote database.

2. (Optional) If your configuration has the shared remote database server and the cluster master are on the same machine, go to the Windows control panel > Administrative Tools >Services and stop EsaApplicationService.

3. Locate and run the DBMSDistArchConfig.exe remote database installer to install the Database from the Clearwell folder: \\utilities\DBMS
     Note: Run the remote database installer even if it is located on the same node as the cluster master.

Running this installer will also install MySQL.

Error Message from log:

cluster-admin_upgradeBootInfo log

cluster-admin:
     [echo] Starting Cluster Admin utility
     [echo] Args = upgradeBootInfo ${build.arg2} ${build.arg3} ${build.arg4}
     [java] error:
     [java] com.teneo.esa.cluster.ClusterException: [#156001] Unable to read cluster boot entry for PRIMARY boot mode of namespace
     [java] at com.teneo.esa.cluster.ClusterException.errorRetrievingBootInfo(ClusterException.java:64)
     [java] at com.teneo.esa.cluster.BootInfo.upgradeBootInfo(BootInfo.java:665)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.upgradeBootInfo(ClusterAdminTool.java:220)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:729)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:1208)
     [java] at com.teneo.esa.cluster.ClusterAdminTool.main(ClusterAdminTool.java:1224)
     [java] Caused by: com.teneo.esa.common.database.PersistenceException: [#80031] JDBC get connection failed : Communications link failure

 

Cause

When upgrading a clustered environment where the database is remote the new database version has to be installed before the upgrade takes place.

Solution

Install DBMS for the Shared Remote Database
Prepare the shared remote database server

1. Ensure that the Clearwell appliance and MySQL remote database server are configured with the same date/time, and time zone.
     Note: If the time zone on the appliance, MySQL remote database, and local database are not all set correctly, issues can occur during migration of the local database data to the shared remote database.

2. (Optional) If your configuration has the shared remote database server and the cluster master are on the same machine, go to the Windows control panel > Administrative Tools >Services and stop EsaApplicationService.

3. Locate and run the DBMSDistArchConfig.exe remote database installer to install the Database from the Clearwell folder: \\utilities\DBMS
     Note: Run the remote database installer even if it is located on the same node as the cluster master.

Running this installer will also install MySQL.

When upgrading a clustered environment where the database is remote the new database version has to be installed before the upgrade takes place.

Install DBMS for the Shared Remote Database
Prepare the shared remote database server

1. Ensure that the Clearwell appliance and MySQL remote database server are configured with the same date/time, and time zone.
     Note: If the time zone on the appliance, MySQL remote database, and local database are not all set correctly, issues can occur during migration of the local database data to the shared remote database.

2. (Optional) If your configuration has the shared remote database server and the cluster master are on the same machine, go to the Windows control panel > Administrative Tools >Services and stop EsaApplicationService.

3. Locate and run the DBMSDistArchConfig.exe remote database installer to install the Database from the Clearwell folder: \\utilities\DBMS
     Note: Run the remote database installer even if it is located on the same node as the cluster master.

Running this installer will also install MySQL.

There is a potential for an issue upgrading a clustered environment when the database is a shared remote database. During the install a warning may pop up: A MySQL upgrade is required on <dbname> before you can continue.
Return to upgrade this appliance once this remote database has been updated. Important!!!
The appliance is connected to a remote database server:
<dbname>
You must upgrade MySQL on this remote server to My SQL 5.6.16 The user must use DBMS utility installer to upgrade the remote database server FIRST no matter the database is configured on the same server or on the remote server before they can upgrade Clearwell product. Otherwise upgrade installation will fail.

Error Message from above image in text:

A MySQL upgrade is required on <dbname> before you can continue. Return to upgrade this appliance once this remote database has been updated. IMPORTANT!!! The appliance is connected to a remote database server: You must upgrade MySQL on this remote server to MySQL 5.6.16. The user must use DBMS utility installer to upgrade the remote database server FIRST no matter the database configuration is configured on the same server or on the remote server before they can upgrade Clearwell product. Otherwise upgrade installation will fail.

JIRA: ESA-41292