Difference between revisions of "AquilaServer Upgrade Instructions"

From EHS Help
Jump to: navigation, search
m
 
(44 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{ProductTopic|Technical (IT)|Instructions}}
 
{{ProductTopic|Technical (IT)|Instructions}}
  
 +
== Pre-Requisites ==
  
==Pre-requisites==
+
* Requires Windows Server 2012 or above.
 +
* Requires MS SQL Server 2008R2 or above.
 +
* Requires 30GB HD space (not including database)
 +
* Minimum 4Gb RAM.  Recommended 8Gb or above.
 +
* AquilaServer must be installed and working correctly before upgrade -- it should not be uninstalled.
  
* AquilaServer version 1.0 or 1.1 must be installed and working correctly.  This should not be uninstalled.
+
== Recovery Procedure ==
* Ensure that all client users are on desktop version 1.2.  See [[IBID Version 1.2 FAQ]] for details.
+
  
==Overview==
+
* <strong>Backup the database before upgrading to provide fall-back in the event of a failure of the upgrade</strong>.
 +
* Should a roll-back be required if the upgrade fails, restore the database and re-install the previous version of AquilaServer (available on request for download)
 +
* Ensure a database backup is taken immediately prior.
  
* The upgrade will take between 15 - 120 minutes depending on the size of your iBID database.
+
== Downtime ==
* Replacing the necessary files only takes 10-20 seconds, during which time the application will be unavailable.
+
* The upgrade re-calculates all the analysis data in the database in order to implement new and changed formulae. 
+
  
==Instructions==
+
* All users should be off the system.
 +
* The file replacement part of the upgrade, should take less than a minute.
 +
* The database schema upgrade (command window) should take less than 30 minutes, usually no more than 5-10 minutes. Users should be offline whilst this is happening.
 +
* The upgrade also triggers a recalculation of the iBID Analysis data - to cater for updated formula - this may take several hours and is dependant on the number of cases in the database. **The application is available for use during this process**
  
* '''Backup the IBID database to provide fall-back in the event of a failure'''.
+
== Running the Upgrade ==
* Download the "iBID Server v1.2 Upgrade (32-bit)" (filename aquilaserver_upgrade32.exe) from ibidb.org.
+
 
* On the machine where AquilaServer is currently installed, run the aquilaserver_upgrade32.exe
+
* Download the correct version of AquilaServer Upgrade from [https://www.evolutionhealthcaresystems.co.uk/downloads https://www.evolutionhealthcaresystems.co.uk/downloads]  (login required)
* Follow on-screen instructions. You will see:
+
* Run the upgrade executable and check the introductory screens for further information
** a console window appear immediately before copying files - this is the stopping of the AquilaServer service
+
* During the file replacement stage, the server will be unavailable to end users - this should take no more than a few minutes
** a console window appear immediately after copying files -- this is the restarting of the AquilaServer service (after which the application is available for use)
+
<!-- [ [File:AqServerUpgrade 3.png] ] -->
** a final console window will appear that makes any necessary metadata changes to the database & recalculates the iBID analysis data
+
* AquilaServer is stopped, files are replaced and AquilaServer is restarted (2-3 minutes):
* Grant user permissions as required, see [[Managing Users#User Permissions]] for info on permissions.
+
<!-- [ [File:AqServerUpgrade 4.png] ] -->
 +
* Database upgrade starts in a command window (this should take 5-10 minutes, 30 minutes at most for larger updates):
 +
 
 +
[[File:AqServerUpgrade 5.png]]
 +
 
 +
* '''CAUTION''': If there are any issues with the database upgrade, they will appear here
 +
** Do not proceed with the installation
 +
** Report any issues to the help desk immediately on 01964 503400 or see [[Getting support]]
 +
 
 +
== Analysis Recalculations ==
 +
 
 +
* Following the upgrade the internally calculated analysis data may be recalculated to reflect any changes in the formula.
 +
* These recalculations will take some time, depending on the amount of data, hardware specifications, etc.
 +
* The system is available whilst these calculations are running, although users may perceive a slight performance hit.  Depending on your available resources, you may prefer to wait until this has completed.
 +
* If you want to allow user access during the Calculatoins, re-open port 8099 on the server if you closed it initially - otherwise wait until the calculations have completed.
 +
 
 +
[[File:AqServerUpgrade 6.png]]
 +
 
 +
* Calculations completed:
 +
 
 +
[[File:AqServerUpgrade 7.png]]
  
 
== Rollback ==
 
== Rollback ==
Line 28: Line 55:
 
In the event of a problem during the server upgrade, the roll-back process is as follows:
 
In the event of a problem during the server upgrade, the roll-back process is as follows:
  
* Restore the database from the backup taken immediately before the upgrade process.
+
1) Contact EHS who will be able to supply files for the previous version of AquilaServer.
* Uninstall the AquilaServer product completely.
+
2) Use the [[Aquila Server Configuration]] tool to make a careful note of your settings.
* Contact EHS who will provide the version of AquilaServer prior to the upgrade for re-installation.
+
3) Uninstall the AquilaServer product
 +
4) Restore the database from the backup taken immediately before the upgrade process.
 +
5) Install the previous version of AquilaServer as supplied, using the settings you noted in step 2.
 +
 
  
 
==Support==
 
==Support==
  
 
See [[Getting support]]
 
See [[Getting support]]

Latest revision as of 13:24, 4 February 2025

This is a Technical (IT) Instructions topic

Pre-Requisites

  • Requires Windows Server 2012 or above.
  • Requires MS SQL Server 2008R2 or above.
  • Requires 30GB HD space (not including database)
  • Minimum 4Gb RAM.  Recommended 8Gb or above.
  • AquilaServer must be installed and working correctly before upgrade -- it should not be uninstalled.

Recovery Procedure

  • Backup the database before upgrading to provide fall-back in the event of a failure of the upgrade.
  • Should a roll-back be required if the upgrade fails, restore the database and re-install the previous version of AquilaServer (available on request for download)
  • Ensure a database backup is taken immediately prior.

Downtime

  • All users should be off the system.
  • The file replacement part of the upgrade, should take less than a minute.
  • The database schema upgrade (command window) should take less than 30 minutes, usually no more than 5-10 minutes. Users should be offline whilst this is happening.
  • The upgrade also triggers a recalculation of the iBID Analysis data - to cater for updated formula - this may take several hours and is dependant on the number of cases in the database. **The application is available for use during this process**

Running the Upgrade

  • Download the correct version of AquilaServer Upgrade from https://www.evolutionhealthcaresystems.co.uk/downloads (login required)
  • Run the upgrade executable and check the introductory screens for further information
  • During the file replacement stage, the server will be unavailable to end users - this should take no more than a few minutes
  • AquilaServer is stopped, files are replaced and AquilaServer is restarted (2-3 minutes):
  • Database upgrade starts in a command window (this should take 5-10 minutes, 30 minutes at most for larger updates):

AqServerUpgrade 5.png

  • CAUTION: If there are any issues with the database upgrade, they will appear here
    • Do not proceed with the installation
    • Report any issues to the help desk immediately on 01964 503400 or see Getting support

Analysis Recalculations

  • Following the upgrade the internally calculated analysis data may be recalculated to reflect any changes in the formula.
  • These recalculations will take some time, depending on the amount of data, hardware specifications, etc.
  • The system is available whilst these calculations are running, although users may perceive a slight performance hit. Depending on your available resources, you may prefer to wait until this has completed.
  • If you want to allow user access during the Calculatoins, re-open port 8099 on the server if you closed it initially - otherwise wait until the calculations have completed.

AqServerUpgrade 6.png

  • Calculations completed:

AqServerUpgrade 7.png

Rollback

In the event of a problem during the server upgrade, the roll-back process is as follows:

1) Contact EHS who will be able to supply files for the previous version of AquilaServer. 2) Use the Aquila Server Configuration tool to make a careful note of your settings. 3) Uninstall the AquilaServer product 4) Restore the database from the backup taken immediately before the upgrade process. 5) Install the previous version of AquilaServer as supplied, using the settings you noted in step 2.


Support

See Getting support