12.5 Upgrading the Dashboard

12.5.1 About Patches

Technical Support provides updates for the Dashboard in patch bundles, which must be installed on the Dashboard server. Before installing a patch, read all correspondence sent along with the patch, including a Readme file or e‑mail.

Patch files use the naming convention nnnyyyy-mm-ddCRiiiiii‑Rxxxxx-META-DASH.jar. Table 12-1 describes the components of the patch file name.

Table 12-1 Naming Conventions

Patch File Name Component

Definition

nnn

Software version number (such as 550 for version 5.5.0).

yyyy

Current year.

mm

Current month (such as 03 for March).

dd

Current day (such as 01, 02, 03).

iiiiii

Internal reference number

xxxxx

Release number

META

If present, indicates the patch contains all interdependent patches.

DASH

Indicates that the patch is for the Dashboard. If you have a patch with the name NOC, it is for Operations Center server.

For more information on installing this patch, see the Operations Center 5.6 Server Installation Guide.

12.5.2 Installing Patches

The procedure for installing the patch is the same for UNIX and Windows. The type of file for a patch is .jar. If you receive the file with a different extension, rename it to .jar before installing it.

One or more patches can be applied at a time, but patches and rollbacks cannot be applied at the same time with the same command. When a patch has already been applied, but is a older version than what you are installing, it is necessary to rollback the patch before installing the newer version of the patch.

When a patch bundle is applied, all previously applied patches are removed before the patch is applied.

To install the patch:

  1. Copy the patch bundle to the root of the Dashboard installation directory.

    The installation directory in the file system should have a minimum free disk space of twice the size of the patch bundle file.

    For example, if the .jar file is 50 MB, then the free disk space should be at least 100 MB.

  2. At a command prompt, enter Java to verify that Java is installed.

    Patch files are issued as .jar files. The patch bundle is a Java executable file.

  3. If you receive the patch file with a different extension than .jar, such as a.zip , rename it to .jar before installing it.

  4. At the command prompt in the Dashboard installation directory, enter java –jar and the file name of the patch bundle.

    For example, if the Dashboard is installed in the C: directory and the name of the patch bundle is 5502015-03-04CR913407-R95915-DASH.jar, then the command is:

    C:/OperationsCenter_Dashboard_install_path>java -jar 55502015-03-04CR913407-R95915-DASH.jar
    

    For additional options when running the installation, enter:

    java –jar patch_bundle_filename(s) --help
    

    Where, patch_bundle_filename(s) is a list of one or more patch files separated by a space.

    This displays the following options:

    • –describe: Prints patch manifest information.

    • –prompt: Displays the Operations Center Dashboard Configuration Manager after the patch is installed.

    • –verbose: Prints detailed information to the screen as the patch is installed.

    • ‑-force: Forces a patch to install even if it has already been applied. Never use the force command unless instructed to by Support.

    Add one of these commands at the end of the java –jar patch_bundle_filename command when installing the patch bundle (for example, java -jar 5502015-03-04CR913407-R95915-DASH.jar --verbose).

    If installing on Windows and User Access Control (UAC) is enabled, you must run the command prompt as the Administrator.

  5. During installation, the following occurs:

    • A back up is automatically created for all files that are overwritten. For more information about rollback files, see Section 12.5.3, Rolling Back a Patch Installation.

    • Patches (of the same version) that have already been applied are skipped unless the --force option was set.

    • The Operations Center Configuration Manager always runs silently and applies the current settings.

    • The patch does not override the existing Operations Center Configuration Manager settings.

      For more information regarding the Operations Center Configuration Manager, see the Operations Center 5.6 Server Configuration Guide.

  6. Review the following chapter to configure and start the Dashboard.

After the patch has been installed and a rollback file is created, the patch cannot be installed again. If you attempt to run the patch bundle .jar file again, the following error messages are displayed:

ERROR: Unable to continue since rollback jar already exists
ERROR: unable to create rollback jar

12.5.3 Rolling Back a Patch Installation

As part of the patch installation process, Operations Center automatically backs up all files that are overwritten and places them in a file called patch_filename-rollback.jar, such as 5502015-03-04CR913407-R95915-DASH-rollback.jar.

If you decide to remove the changes made by the patch to Operations Center, run this rollback JAR file from the Operations Center root installation directory. The command for running the rollback file is the same as when the patch is installed. For example:

C:/OperationsCenter_install_path>java -jar 5502015-03-04CR913407-R95915-DASH-rollback.jar

When multiple rollback patches are applied using the same command, they are applied in the reverse order.

12.5.4 Upgrading the Dashboard

The following notes apply when upgrading your version of the Dashboard:

  • The Dashboard_install_path/server/webapps/root/WEB-INF/portal-ext.xml file, which might have been customized for various property settings, is overwritten during the upgrade process. A copy is automatically saved as portal-ext.xml.previous in the same directory. If you had modified this file as part of your installation, you will need to restore these changes after the upgrade installation.

    Note that the portal-ext.xml file should never be modified. Any configurations and changes should be made in the portal-ext.custom.xml file as it is never overwritten by the installer.

  • If the NetIQ Operations Center Dashboard service is not using the Local System account to connect to the dashboard database, you must re-establish the service after upgrading.

  • Custom theme content is not updated during upgrades and any static links to documentation must be changed manually.

12.5.5 Upgrading from the Dashboard Embedded Database to Oracle or SQL Server

If running an existing myMO/Dashboard implementation, you must switch from using the default Hypersonic SQL embedded database to upgrade to an Oracle or SQL Server database. If you have been using myMO/Dashboard with the embedded database, it is possible to upgrade your database and preserve existing data.

See Supported Versions and Hardware Requirements in the Operations Center 5.6 Getting Started Guide for supported database versions.

You must be running v4.7 to use an Oracle or SQL Database. During the v4.7 and v5.0 installation, the upgrade process upgrades the Hypersonic SQL embedded database and stores the files in the new default location of Dashboard_install_path/data/hsql.

IMPORTANT:myMO/Dashboard must be started at least once using the Hypersonic SQL embedded database, so that it can run a critical database verification processes. If you are installing Dashboard for the first time or have just upgraded, you must start myMO/Dashboard once before implementing the following steps to migrate the database to Oracle or SQL Server.

To migrate myMO/Dashboard to use an Oracle or SQL Server database on an existing integration:

  1. Stop myMO. See Section 2.3.2, Stopping the Dashboard.

  2. Do one of the following to create the schema for the new database:

    • Oracle: Use the Oracle SQL*Plus Client to run the Dashboard_install_path/data/scripts/create-oracle.sql file against your Oracle database.Note that the schema creation script contains some PL/SQL code which other jdbc based clients cannot execute.

    • SQL Server: Run the Dashboard_install_path/data/scripts/create-sql-server.sql file against your SQL Server database.

  3. Open the Dashboard_install_path/server/webapps/ROOT/WEB-INF/classes/portal-ext.custom.properties file and make the following changes in the Database Support section:

    1. Comment out any lines for the Hypersonic SQL embedded database.

    2. Copy and paste the lines for the desired database from the portal-ext.properties file in the same directory, and customize for your configuration. Note the following:

      • jdbc.default.driverClassName and hibernate.dialect property values should not be changed.

      • For the jdbc.default.url property, specify a valid url string for the given driver. jtds for sql server and oracle for oracle).

      • For jdbc.default.username and jdbc.default.password properties, specify the credentials of a user that has valid access writes to the database.

      • The jdbc.default.schema property is only specified for oracle and required only when running the dbmigrate script.

      Be sure the lines for the Oracle or SQLdatabase are uncommented in the portal-ext.custom.properties file.

      Optionally, you can encrypt the password. For more information about encrypting the database password, see Section 12.1, Encrypting the Dashboard Database Password.

  4. If needed, install the appropriate database drivers. Prepackaged JDCB drivers are available as part of the installation in the Dashboard_install_path/server/lib/ext/ directory. Install one of the following drivers:

    • Oracle: ojdbc6.jar

    • SQL Server: jtds-1.2.2.jar

  5. Using a command prompt, from Dashboard_install_path/bin/, do one of the following to migrate existing data from the database:

    • Windows: Run dbmigrate.bat

    • UNIX: Run dbmigrate.sh

    The migration process copies all data from the Hypersonic SQL embedded database, located in the Dashboard_install_path/data/hsql directory, to the destination database as specified in step 3.

  6. Restart myMO/Dashboard and verify that existing data is available. See Section 2.3.1, Starting the Dashboard.