EEE Upgrade Installation Notes
From EnablerWiki
Created: 23 January 2009. Last Reviewed: 07 May 2009
Enabler Enterprise Edition Upgrade Installation Procedures
Enabler Enterprise Installation
Figure 1 shows the Enabler Enterprise main setup screen. You should start by running the Enabler Enterprise Database Upgrade Wizard and then run the setup option for other installed components in sequence.
Enabler Enterprise Setup should be executed under a logon with local and domain administrative privileges. (E.g. Logon as Administrator before running EEE Setup).
Important Note Before commencing the upgrade, you should stop the DataLoader and Query Server services and ensure that EEE Exporter isn’t running and that scheduled exports which may occur during the upgrade are disabled.
Figure 1 Enabler Enterprise main setup screen
Enabler Enterprise Database Upgrade (Database Upgrade Wizard)
When you run the Upgrade EEE Database option, the setup program will first copy necessary files to the nominated directory on your hard disk, then launch the EEE Database Upgrade Wizard, shown in figure 2.
Enter the information required on into each field, and press Next. Figure 2 shows example values for these fields.
Figure 2 EEE Database Upgrade Wizard
Specify the name of the SQL Server and Database that you want to upgrade. It is strongly recommended that the “Backup database before upgrade” option be left on. Only switch this off if you have a full database backup that is current at the time of upgrading. If the upgrade encounters errors, you may need to restore the backup.
The backup file path is the path on the server. The default .\ causes the backup to be written to the default SQL Server backup directory – typically C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
Select the database version to upgrade to, from the target database version drop down box. Normally you should select the version which matches the CD from which you are installing. You would only select a lower version in the event that an upgrade across several versions is problematic.
Specify logon credentials and click OK to begin the upgrade. The backup will be made first (assuming this option is selected – which is the default). Then the necessary SQL Server scripts are applied against the database.
In the event of an error during the database upgrade, details of the error are logged to disk and can be reviewed – the upgrade wizard will tell you where to find these errors. If the upgrade wizard created a backup before the upgrade, it will offer to restore the backup. Otherwise, you must recover manually.
The database upgrade wizard, like the database creation wizard, connects to the database via the OSQL SQL Server command line tool. Ensure this tool is available and in the PATH when running database upgrades.
Enabler Enterprise Configuration Utility
The EEE Tools Configurator upgrade is straightforward. Ensure the configuration utility is closed before beginning the upgrade.
Enabler Enterprise Data Loader Service
When you select the option to install the EEE Data Loader Service, setup first checks whether this service is already installed. If it is, the service is stopped if it is running and the installation/upgrade proceeds.
After the upgrade, the service is automatically restarted. If the service was not running when the upgrade began, you will be prompted if you want to start the service. If you say no, you must manually start the service later (or reboot the system).
Enabler Enterprise Data Exporter
The EEE Tools Data Exporter upgrade is straightforward. Ensure the exporter is closed before beginning the upgrade and ensure that it is not scheduled to execute in batch mode during the upgrade.
Microsoft .NET Framework Version 3.5 SP1
Starting from release 1.41 of EEE, Microsoft .NET framework 3.5 is required. If this hasn’t been installed on the server, please use this menu option to update your .NET framework to version 3.5 SP1. You maybe requested to reboot your server to complete the .NET framework installation.
Enabler Enterprise Web Application
When you choose Enabler Enterprise Edition Web Application you enter the services logon information – use the same information that was entered during initial setup of the Enabler Enterprise Web Application. As the password is stored only in hash form, EEE setup cannot retrieve this password – this is why is must be re-entered during EEE upgrades.
Setup will detect if the EEE web application has been previously installed.
Click Next…
You should generally use the same virtual directory name and port as in the initial installation.
When the installation is complete, the following message should be displayed. This could take a few minutes to appear as other tasks are completed. The tasks being performed will appear in this window, prior to the Setup is completed message. Click Exit to return to the Enabler Enterprise Edition main setup window.
Install/Upgrade Enabler Enterprise Reports
This wizard will upgrade the EEE reports on the Reports Server.
Select “Upgrade” from the drop-down box. Next select the SQL Server to upgrade – if the upgrade is being run on the same server containing the EEE SQL database/s, select (local) from the list. Select the database to upgrade from the drop-down box. Note: If you have more than one EEE database (eg: EEE and EEETest) each database will need to have its reports module upgraded separately. For “EEE Reports source directory” use the “…” button to browse to \EEEReports on the Installation/Upgrade CD. The Reporting Services URL and EEE Reports Folder fields will be filled in automatically.
Once you are satisfied that you have all settings correct, click on the “Upgrade” button to upgrade the EEE reports. A progress box will now open and will report back on the number of reports successfully upgraded.
Enabler Enterprise Query Server Service
When you select the option to install the EEE Query Server Service, setup first checks whether this service is already installed. If it is, the service is stopped if it is running and the installation/upgrade proceeds.
After the upgrade, the service is automatically restarted. If the service was not running when the upgrade began, you will be prompted if you want to start the service. If you say no, you must manually start the service later (or reboot the system).
Enabler Enterprise Configurator
Enabler Enterprise Configurator upgrade is straightforward. Ensure Configurator is closed before beginning the upgrade. Make sure that the upgrade installs to the correct directory. The default installation directory is C:\EEE\ESQL. This component is only required if you are using Enabler SQL.
Enabler Enterprise POS
Enabler Enterprise POS upgrade is straightforward. Ensure POS is closed before beginning the upgrade. Make sure that the upgrade installs to the correct directory. The default installation directory is C:\EEE\ESQL. This component is only required if you are using Enabler SQL.
Multi Server Installation
For larger clients, it is common to split the installation of EEE over two servers. This helps spread the resource utilisation by running the database and associated components on a database server, and the EEE application on another server. The database server will have SQL Server and IIS installed and the application server will have IIS installed.
When you are upgrading this type of installation, you need to ensure that the upgrade of each component of EEE is run on the correct server.
Database Server
The following components are normally installed on a database server, and should be upgraded on this server.
- Upgrade EEE database
- Enabler Enterprise Tools Configurator
- Enabler Enterprise Data Exporter
- Enabler Enterprise Data Load Service
- Enabler Enterprise Reports
- Enabler Enterprise Query Server Service
Application Server
- Enabler Enterprise Tools Configurator
- Enabler Enterprise Edition Web Application
