Ensim Unify MS SQL 2005 Service 3.0.0 Rollup Hotfix 1 Release Notes

Introduction

These release notes provide information about Ensim Unify MS SQL 2005 Service 3.0.0 rollup resolved issues, prerequisites, and installation instructions. 

Rollup hotfix information

Download:  ftp://ftp.ensim.com/download/unify/mssql2k5/3.0.0/hotfix/1/

Note:Please note this is a hidden, password-protected directory. As a result, the above URL is not accessible via a Web browser, please use a ftp client which will prompt you for username and password (given to you when you intially received the software). If you need a new login, please contact Ensim at : operations@ensim.com.

Prerequisites

Before installing this rollup hotfix, ensure that your Ensim Unify system has the following:

Time requirements and customer impact

It takes a few minutes to apply the rollup hotfix. During this time, new customers cannot be provisioned, and all Ensim Unify control panels are unavailable. However, existing customers can continue to use services without interruption.

Installing the rollup hotfix

This section explains how to install the rollup hotfix.

Pre-installation instructions

Before installing the rollup hotfix, you need to disable PE server applications and backup the database (in some cases). This section describes the pre-installation instructions.

  1. Ensure that all the requirements mentioned in the prerequisites section are satisfied unless they are marked as optional.
  2. Disable the Provisioning Engine and Queue Manager services by performing the following steps on each PE server:
    1. Log in to the PE server as domain administrator.
    2. Click Start > Programs > Microsoft Provisioning Server, then click Provisioning Manager.
    3. In the Provisioning Manager window, expand Provisioning Servers, then click Provisioning Engines.
    4. Right-click the name of the PE server, then click Deactivate.
    5. Under Provisioning Servers, click Queue Managers.
    6. Right-click the name of the PE server, then click Deactivate.
    7. Close the Provisioning Manager window.
    8. If the CronJob service is running on this server, open a command window and run the following command:
      net stop "Ensim CronJob Service"
  3. Optional: If the PE and CP software is installed on the same server, perform the following steps on each of these servers:
  1. Log in to the server as domain administrator.
  2. Open a command window and run the following command:
    iisreset /stop
  1. Back up the Unify databases as follows:

If MS SQL 2000 server

  1. Log in to the SQL Server as domain administrator.
  2. Click Start > Programs > Microsoft SQL Server, then click Enterprise Manager.
  3. Expand Microsoft SQL Servers > SQL Server Group > (local), then click Databases.
  4. d.      Right click Ensim_ResourceManager2 and select All tasks > Backup database. A popup window is displayed.
  5. Click Add in the popup window.
  6. Enter the file name where you want to backup this database, then click OK.
  7. g.       Click OK to start the backup.
  8. Repeat steps d to g for Ensim_WVH_Configuration, Ensim_Statistic and Ensim_Exchange

If MS SQL 2005 Server

  1. Log in to the SQL 2005 Server as domain administrator.
  2. Click Start > Programs > Microsoft SQL Server 2005, then click SQL Server Management Studio.
  3. Select Server Type: Database Engine, Server Name : Ensim Unify SQL Server name/IP, Authentication : Windows Authentication and then click on Connect button.
  4. Expand Microsoft SQL Servers then click Databases.
  5. m.     Right click Ensim_ResourceManager2 and select Tasks > Back up.... A popup window is displayed.
  6. Click Add in the popup window.
  7. Enter the file name where you want to backup this database, then click OK.
  8. p.      Click OK to start the backup.
  9. Repeat steps e to h for Ensim_WVH_Configuration, Ensim_Statistic and Ensim_Exchange

 

The pre-installation procedure is complete.

Installation instructions

After performing the steps in the pre-installation section, complete the following steps to install the rollup hotfix.

On Provisioning Engine (PE) servers
 

Perform the following steps on each PE server:

  1. Log in to the PE server as domain administrator.
  2. Unzip the rollup hotfix zip file to a temporary directory.
  3. Browse to the temporary directory, where you have unzipped the rollup hotfix files.
  4. Double-click the Autorun_PE.bat file.
  5. Click OK to complete the installation.
    A log file named Install.log is created in the same directory. Open this log file and verify that there are no errors reported in the file. If there are any errors reported for a hotfix packaged in the rollup hotfix, open and check the Install.log and RegisterHotfix.log files located in the Data\Hotfix<number>\PE directory for detailed information about the errors.

    Important: If the rollup hotfix installation fails on a server, you need to manually uninstall the rollup hotfix from all other servers on which you have successfully installed it.

The rollup hotfix installation on the PE server is complete.

  On Control Panel (CP) servers
 

Perform the following steps on each CP server:

  1. Log in to the CP server as domain administrator.
  2. Unzip the rollup hotfix zip file to a temporary directory.
  3. Browse to the temporary directory, where you have unzipped the rollup hotfix files.
  4. Double-click the Autorun_CP.bat file.
  5. Click OK to complete the installation.
    A log file named Install.log is created in the same directory. Open this log file and verify that there are no errors reported in the file. If there are any errors reported for a hotfix packaged in the rollup hotfix, open and check the Install.log and RegisterHotfix.log files located in the Data\Hotfix<number>\CP directory for detailed information about the errors.
    Important: If the rollup hotfix installation fails on a server, you need to manually uninstall the rollup hotfix from all other servers on which you have successfully installed it.

The rollup hotfix installation on the CP server is complete

 

On Hosting servers

There is no change on the Hosting server.

Post-installation instructions

After installing the rollup hotfix as described in the preceding section, perform the following step to complete the rollup hotfix installation:

  1. Enable the Provisioning Engine and Queue Manager services by performing the following steps on each PE server:
    1. Log in to the PE server as domain administrator.
    2. Click Start > Programs > Microsoft Provisioning Server, then click Provisioning Manager.
    3. In the Provisioning Manager window, expand Provisioning Servers, then click Provisioning Engines.
    4. Right-click the name of the PE server, then click Activate.
    5. Under Provisioning Servers, click Queue Managers.
    6. Right-click the name of the PE server, then click Activate.
    7. Close the Provisioning Manager window.
    8. If you have stopped the CronJob service on this server before installing the rollup hotfix, open a command window and run the following command:
      net start "Ensim CronJob Service"
  2. Optional: If the PE and CP software is installed on the same server, perform the following steps on each of these servers:
  1. Log in to the server as domain administrator.
  2. Open a command window and run the following command:
    iisreset /start
  1. Perform the Post-installation instructions mentioned in the release notes of the following hotfixes:
  1. Hotfix 1 release notes

The rollup hotfix installation is complete.

Contents of the rollup hotfix

The rollup hotfix includes all the Unify MS SQL 2005 Service version 3.0.0  hotfixes released prior to this hotfix. Depending upon the hotfixes that you have already installed on your Unify setup, the rollup hotfix installs all the remaining hotfixes on the setup.

Please refer to the release notes of all the hotfixes to determine the issues resolved in the hotfixes:

Removing the rollup hotfix

You can remove (or roll back) the installed rollup hotfix by performing the following steps, then restoring the old databases:

Before you begin, perform step 2 and 3 mentioned in the Pre-installation instructions section to disable PE and CP server applications.

On Provisioning Engine (PE) servers
 

Perform the following steps on each PE server.

  1. Log in to the PE server as domain administrator.
  2. Open a command window and change to the temporary directory, where you have unzipped the rollup hotfix files.
  3. Run the following command:
    cscript.exe Scripts\RollupScript.vbs RollupConfigPE.xml -u
    During the uninstallation, if an error occurs, it is displayed in a popup window. Click OK in the popup window to resume the uninstallation.
  4. Click OK to complete the uninstallation.
    A log file named Uninstall.log is created in the same directory. Open this log file and verify that there are no errors reported in the file. If there are any errors reported for a hotfix packaged in the rollup hotfix, open and check the Uninstall.log and RegisterHotfix.log files located in the Data\Hotfix<number>\PE directory for detailed information about the errors.

The rollup hotfix uninstallation on the PE server is complete.

On Control Panel (CP) servers
 

Perform the following steps on each CP server.

  1. Log in to the CP server as domain administrator.
  2. Open a command window and change to the temporary directory, where you have unzipped the rollup hotfix files.
  3. Run the following command:
    cscript.exe Scripts\RollupScript.vbs RollupConfigCP.xml -u
  4. Click OK to complete the uninstallation.
    A log file named Uninstall.log is created in the same directory. Open this log file and verify that there are no errors reported in the file. If there are any errors reported for a hotfix packaged in the rollup hotfix, open and check the Uninstall.log and RegisterHotfix.log files located in the Data\Hotfix<number>\CP directory for detailed information about the errors.

The rollup hotfix uninstallation on the CP server is complete.

On Hosting servers

There is no change on the Hosting server.

On the SQL server

Perform the following steps on the SQL server if you updated the Unify database after installing the rollup hotfix.

  1. Log in to the SQL Server as domain administrator.
  2. Click Start > Programs > Microsoft SQL Server, then click Enterprise Manager.
  3. Expand Microsoft SQL Servers > SQL Server Group > (local), then click Databases.
  4. Right click Ensim_ResourceManager2 and select All tasks > Restore database.
  5. Locate the backed up database, then select the Restore check box for that record.
  6. Click OK to restore the database.
  7. Repeat steps 4 to 6 for Ensim_WVH_Configuration, Ensim_Statistic and Ensim_Exchange.

The old databases are restored successfully.

After uninstalling the rollup hotfix from all the servers, perform the procedure mentioned in the Post-installation instructions section to complete the rollup hotfix uninstallation.

The rollup hotfix rollback is complete.