Difference between revisions of "AquilaServer Upgrade Instructions"

From EHS Help
Jump to: navigation, search
 
(33 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.
  
* Any existing AquilaServer must be installed and working correctly.  This should not be uninstalled.
+
== Recovery Procedure ==
  
==Instructions==
+
* <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.
  
* All users should ideally be off the system.
+
== Downtime ==
* Backup the IBID database to provide fall-back in the event of a failure.  (Installations for older versions of the server are readily available, should a major roll-back be required).
+
* Download the "Aquila Server vN.N Upgrade (32-bit)" from www.ibidb.org.  (where N.N is the new version number)
+
* On the machine where AquilaServer is currently installed, run the file AquilaServer_2.2_upgrade_32-bit.exe
+
  
Introductory screens:
+
* 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**
  
[[File:AqServerUpgrade 1.png]]
+
== Running the Upgrade ==
  
[[File:AqServerUpgrade 2.png]]
+
* Download the correct version of AquilaServer Upgrade from [https://www.evolutionhealthcaresystems.co.uk/downloads 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
 +
<!-- [ [File:AqServerUpgrade 3.png] ] -->
 +
* AquilaServer is stopped, files are replaced and AquilaServer is restarted (2-3 minutes):
 +
<!-- [ [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 3.png]]
+
[[File:AqServerUpgrade 5.png]]
  
Server is stopped, files are replaced, server is restarted:
+
* '''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]]
  
[[File:AqServerUpgrade 4.png]]
+
== Analysis Recalculations ==
  
Database upgrade starts (this may take 5-10 minutes):
+
* 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.  
[[File:AqServerUpgrade 5.png]]
+
* The system is available whilst these calculations are running, although users may perceive a slight performance hitDepending 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.
Database upgrade completed - note the new version number (39.0) and the number of changes made (usually 1). The IBID Analysis calculations are now started and may take some considerable timeThe users can be on the system whilst this is happening if need be:
+
  
 
[[File:AqServerUpgrade 6.png]]
 
[[File:AqServerUpgrade 6.png]]
  
 +
* Calculations completed:
  
 
+
[[File:AqServerUpgrade 7.png]]
 
+
  
 
== Rollback ==
 
== Rollback ==
Line 41: 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:
  
* Contact EHS who will be able to supply files for the previous version of AquilaServer.
+
1) Contact EHS who will be able to supply files for the previous version of AquilaServer.
* Replace the file on your system with those provided by EHS.
+
2) Use the [[Aquila Server Configuration]] tool to make a careful note of your settings.
* Ensure the AquilaServer process is not running, either via the Services control panel app, or via the command prompt with "net stop AquilaServer".
+
3) Uninstall the AquilaServer product
* Restore the database from the backup taken immediately before the upgrade process.
+
4) Restore the database from the backup taken immediately before the upgrade process.
* Start the AquilaServer process again, either via the Services control panel app, or via the command prompt with "net start AquilaServer".
+
5) Install the previous version of AquilaServer as supplied, using the settings you noted in step 2.
 
+
== Notes ==
+
  
* The upgrade will take between 15 - 120 minutes depending on the size of your iBID database.
 
* Replacing the necessary files takes < 1 min, during which time the application will be unavailable.
 
* The upgrade also re-calculates the analysis data in the database in order to implement new and changed formulae for the national reports, dashboard reports etc.  During the analysis re-calculation, the system will be available to end-users, however performance may be affected slightly.
 
  
 
==Support==
 
==Support==
  
 
See [[Getting support]]
 
See [[Getting support]]

Latest revision as of 14: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