e-track Online Upgrade Guide

This document details upgrading an existing version of e-track Online to 5.20.7600.1.

Both Maytas and e-track must be upgraded to 5.20 SP1 concurrently as there are updates which are not compatible with earlier versions.

It is important to uninstall any previous versions of Maytas and e-track on your system, including old training or testing versions. Leaving old versions on your system can lead to increased security risks.

If you use ebs-Link, please follow the ebs-Link Upgrade Guide instead.

Upgrade e-track Online

Extract Files

  1. On your e-track Online server, browse to the root of your e-track website and make a backup copy of the e-track folder (this is often found at C:\inetpub\wwwroot). If you are unsure of the exact location of the folder, please contact Maytas Support for assistance.
  2. In the original e-track folder, delete the bin folder and the Scripts folder.
  3. Browse to the e-track Online folder of the upgrade and open etrack.5.20.7600.1.zip.

  4. Open the etrack.5.20.7600.1 folder in the zip file and extract the contents to your e-track folder (the original, not the backup). Overwrite all existing files when prompted.

    Please note that it is the contents of etrack.5.20.7600.1 that should be extracted, not the folder itself.

  5. Open IIS and restart the Application Pool associated with your e-track Online application.
  6. Each user should refresh their browser cache after the upgrade. Instructions for each browser are as follows:

Run SQL Script

  1. In SQL Server Management Studio, click Connect at the top-left and select Database Engine.
  2. Connect to your Maytas SQL server as the Maytas3 user. Please note that you should NOT connect using Windows authentication.
  3. Go to File | Open | File.
  4. Browse to the UpgradeScripts folder of the upgrade, select etrack_Upgrade.sql and click Open.
  5. Ensure the Maytas database is selected in the dropdown box to the top-left of the screen. Also ensure that the script is connected as the Maytas3 user rather than the sa user (the easiest way to do this is to hover the mouse over the tab header for the script – the popup will display the user at the far right).
  6. Click Execute.

Upgrade Stats Service

There is an updated version of the e-track Stats Service which should be installed. First, the current version must be uninstalled:

  1. On the server where the Stats Service runs, go to Start | Control Panel | Uninstall a program.
  2. From the list of installed programs, select e-track Stats Service and click Uninstall.
  3. Click Yes to the message that appears. You may also be prompted to close the Stats Service if it is running – click OK to confirm this.

Next, install the new version:

  1. Go to the e-track Online\StatsService folder of the upgrade.
  2. Run Maytas.Service.Installer.msi.
  3. Click Next, then click Next again.
  4. Enter the Database Name and SQL Server Name for the Maytas database and click Next. Please note that the SQL Server name must include the instance if it has one.
  5. Click Install. The Stats Service will now be installed.
  6. Click Finish.

Start e-track

e-track can now be started as follows:

  1. Open a web browser such as Internet Explorer.

  2. Go to the following address:

    http://e-trackserver/instancename

    where e-trackserver is the name of the server where e-track runs, and instancename is the name of the e-track folder. The instance name is determined when the MSI installer is run (by default this will be etrack). An example URL for a server called myserver would be:

    http://myserver/etrack

  3. You will now be prompted to log in to e-track. Enter your e-track user credentials and click Log in.

Application Forms

If you use any application forms with e-track, it is important to test adding an applicant after the upgrade has been applied. If you encounter any issues, please contact Maytas Support as your database may require additional configuration.