Upgrade to VM 5.5 fails at the end when importing Unix checks. (NETIQKB47058)

fact
NetIQ Vulnerability Manager 5.5

symptom
Upgrade to VM 5.5 fails at the end when importing Unix checks.

symptom

Error: 'jre\bin\java.exe -cp 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\dbimport.jar;mk.jar;lib\ext\collections-2.1.jar;lib\ext\coredb.jar;lib\ext\jdom-1.0.jar;lib\ext\JSQLConnect.jar;lib\ext\Una2000.jar;lib\ext\velocity-1.3.1.jar;modules\coreagent.jar;modules\gladiator.jar' com.pentasafe.core.gladiator.content.ImportCheck mk.options etc\vdal.properties "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\ChecksUNIX' 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\ChecksUNIX.log'
Return code from dbimport is: 1

fix

To resolve this issue:

• Download the .zip file at: https://download.netiq.com/kb/files/VM55UpgradeFix.zip

These instructions are to be executed on the machine running Core Services.  They assume that NetIQ Vulnerability Manager is installed in the default location.  If you have not installed in the default location, adjust these instructions accordingly.

1. Open the Core Services Utility,
2. Open the Database and set the following to:

           Use Windows Authentication: = False

3. Click OK
   Note: A warning message will appear stating, "You must restart Core Services for some settings to take effect." Close the Warning message.
4. Open the Services program, from the Control Panel.
5. Stop and Restart NetIQ Core Services.
      
6. Copy the VM55UpgradeFix.zip to C:\Program Files\NetIQ\Vulnerability Manager\Core Services

7. Unzip VM55UpgradeFix.zip.
   This will copy the following files into the Core Services\bin folder.

   osql.exe
ImportChecks.bat
ImportTemplates.bat
VM55UpgradeFix.bat
VM55UpgradeFix.sql

   Also it will create 2 other directories

   core Services\checks    - contains 172 checks
   core Services\Templates - contains 19 templates

8. Start a command prompt.
9. Change to the Core Services\bin directory.

           cd C:\Program Files\NetIQ\Vulnerability Manager\Core Services\bin

10. Run VM55UpgradeFix.bat

            VM55UpgradeFix DBServer SAPassword

        Where

            DBServer = SQL server instance name
            SAPassword = SA password for the SQL server specified

11. When completed, run the VM 5.5 install again.
    Note: Run as a new production install and select ONLY the Vulnerability Manager Console.

12. Core Services was set to run as a local system account.  Follow the instructions in the Vulnerability Manager Installation Guide to setup Windows Authentication again.

Formerly known as NETIQKB47058