Problem

An upgrade from NetBackup 8.0 or 8.1 to NetBackup 8.1.1 (or equivalent NetBackup Appliance version upgrade) may fail during the attempt to upgrade the NBDB (EMM) database. 

Error Message

ERROR:  Unable to create/upgrade the NB database. Refer to the log

        file in /usr/openv/netbackup/logs/nbdb for more information.

        Rerun /usr/openv/netbackup/bin/install_bp when the problem

        has been resolved.A check of the nbdb log reports:

<16> run_sql_from_file: ErrMsg [Sybase][ODBC Driver][SQL Anywhere]Column 'userIdTag' in table 'ACTL_User_Details' cannot be NULL, ErrCode -1, Sqlstate 23000

<4> run_sql_from_file: Exiting. rc = 13

<16> runUpgradeScripts(): Failed running SQL script, C:\Program Files\Veritas\NetBackupDB\scripts\NBDB.8.1.sql.

Cause

The issue is a result of configuring a user in NBAC. In previous versions (NetBackup 8.0 – 8.1) adding a user put an entry in the ACTL_User_Details database table. This table is for RBAC and the table is not currently used. RBAC (Role Based Access Control) is a feature planned for a future release of NetBackup. For now, only the "root" (and optionally the "nonroot") user name(s) are the only entries the table should have. However, the installer checks the table, finds other usernames, and that prevents updating of the database, which in turn fails the upgrade to 8.1.1. The additional user names were added with a NULL character in the last 3 fields of the table (userIdTag, userIdInt, userIdStr) and the upgrade of the NBDB database cannot proceed when the table contains a NULL character in those fields.

Solution

Hotfixes are attached to this document. Please download and apply the appropriate hotfix. This hotfix would be best applied prior to the attempt to install NetBackup 8.1.1.

Note: On Windows upgrades, if this issue occurs, the installer should rollback the installation to the previous version of NetBackup. The hotfix can then be applied and the upgrade to 8.1.1 should now succeed.

On UNIX upgrades, the installer does not roll back. If the issue occurs, manually start the NBDB database server (NB_dbsrv) and then apply the hotfix. 

To start the server, execute the following command:

/usr/openv/db/bin/nbdbms_start_server

Once the hotfix is installed, run /usr/openv/netbackup/bin/install_bp which should update the database and complete the upgrade.

Hotfix information:

Bug ID: ET 3941845

Version: NetBackup_8.1.1

Installation Location: EMM (master) server

Installation Instructions:

Windows:

Download and apply the Attached hotfix NB_8.1.1_ET3941845_2.zip.

To update the EMM database you will need to know:

        a) The NetBackup server name  (e.g. NB_SERVERNAME: where SERVERNAME=the name of the EMM server)

        b) The EMM database password

        c) The location of the NetBackupDB directory (if other than the default which is C:\)

To update the EMM database follow these steps:

1.  Run the EEB installer with the -extractonly <destination directory> option (Directory must already exist).

Example:

     C:\temp\eebinstaller_3941845_2_AMD64 -extractonly <destination_dir>

this should extract two files:

ET3941845_fix_180222-001043.sql

nbdb_run_sql.cmd

2. Copy the extracted files into \VERITAS\NetBackupDB\scripts directory.

3. Verify that the database is up and running:

     C:\<install_path>\Veritas\NetBackup\bin> nbdb_ping

        Output of the above command will be similar to: Database [NBDB] is alive and well on server [NB_SERVERNAME]

4. Before proceeding, ensure that you have a current online backup of the database:

    C:\>mkdir \temp\nbdb

     C:\>cd \Program Files\Veritas\NetBackup\bin

     <install_dir>\Veritas\NetBackup\bin>nbdb_backup.exe -dbn NBDB -online \temp\nbdb

5. Update the database:

     cd <install_path\VERITAS\NetBackupDB\scripts\

     nbdb_run_sql.cmd -db_server <server name> -dba <dba passwd> -sql ET3941845_fix_180222-001043.sql [ -db_home <database_home> ]

where:

        <server name> = the database server name (e.g. NB_myserver)

        <dba passwd> = the EMM database password (e.g. "nbusql")

        <database_home> = the path to the NetBackupDB directory (you may omit if this is C:\Program Files\VERITAS\NetBackupDB)

        Note: Command should be all on one line

        Note: The NetBackupDB directory is the one that contains WIN64 not the one where NBDB is if they are different.

6. Once the above steps have been performed, verify that the failing operations now complete successfully.

UNIX/Linux:

Download and apply the Attached hotfix NB_8.1.1_ET3941845_1.zip.

To update the EMM database you will need to know:

        a) The EMM database password

To update the EMM database follow these steps:

1.  Run the EEB installer with the -extractonly <destination directory> option (Directory must already exist).

Example:

     bash-3.00# ./eebinstaller_3941845_1_solaris -extractonly <destination_dir>

2.  Copy the extracted files into /usr/openv/db/scripts/ directory.

3.  Verify that the database is up and running:

     # cd /usr/openv/db/bin

     # ./nbdb_ping

        Output of the above command will be similar to:

     Database [NBDB] is alive and well on server [NB_SERVERNAME]

4.  Before proceeding, ensure that you have a current online backup of the database:

    # cd /usr/openv/db

     # mkdir nbdb_backup_online

     # ./bin/nbdb_backup -dbn NBDB -online /usr/openv/db/nbdb_backup_online

5.  Update the database:

    # cd /usr/openv/db/scripts

     # ./nbdb_run_sql -dba <dba passwd> -sql ET3941845_fix_180222-001043.sql -out ET3941845_fix_180222-001043.out

where:

        <dba passwd> = the EMM database password (e.g. "nbusql")

        Note: Command should be all on one line

6. Once the above steps have been performed, verify that the failing operations now complete successfully.

Recommended service state: NetBackup services can remain running while applying this hotfix.For NetBackup Appliances, please contact Veritas technical support, referencing this article and Etrack 3941845 for further guidance.If on version 8.0 intending to upgrade to 8.1.1, please contact Veritas Technical Support and request the EEB appropriate for version 8.0 (Etrack 3943191).

Package Contents:

eebinstaller_3941845_1_hpia64                HP-UX Itanium Installation

eebinstaller_3941845_1_linuxR_x86            RedHat x64 Installation

eebinstaller_3941845_1_linuxS_x86            Suse x64 Installation

eebinstaller_3941845_1_rs6000                AIX Installation

eebinstaller_3941845_1_solaris               Solaris SPARC Installation

eebinstaller_3941845_2_AMD64.exe             Windows x64 Installation

Checksums:

3257445580 703 hpia64/ET3941845_fix_180222-001043.sql

645343543 2144 hpia64/nbdb_run_sql

3257445580 703 linuxS_x86/ET3941845_fix_180222-001043.sql

645343543 2144 linuxS_x86/nbdb_run_sql

3257445580 703 linuxR_x86/ET3941845_fix_180222-001043.sql

645343543 2144 linuxR_x86/nbdb_run_sql

3257445580 703 rs6000/ET3941845_fix_180222-001043.sql

645343543 2144 rs6000/nbdb_run_sql

3257445580 703 solaris/ET3941845_fix_180222-001043.sql

645343543 2144 solaris/nbdb_run_sql

3257445580 703 AMD64/ET3941845_fix_180222-001043.sql

1432472396 2369 AMD64/nbdb_run_sql.cmd