Aquila Server Upgrade Instructions

From EHS Help
Jump to: navigation, search

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