Why do I get an error when upgrading from NetIQ Vulnerability Manager 5.0 to 5.5? (NETIQKB47838)

  • 7747838
  • 02-Feb-2007
  • 21-Nov-2007

Resolution

goal
Why do I get an error when upgrading from NetIQ Vulnerability Manager 5.0 to 5.5?

goal
Why is the upgrade unable to drop the VigRoles.RoleScope column?

goal
How do I correct a RoleScope error that occurs during upgrade?

goal
What causes the upgrade to NetIQ Vulnerability Manager 5.x to fail?

fact
NetIQ Vulnerability Manager 5.0  5.5

fact
NetIQ Vulnerability Manager 5.x

fact
NetIQ Vulnerability Manger 5.0

symptom

Error upgrading from NetIQ Vulnerability Manager 5.0 to 5.5



symptom

ERROR: "[ODBC SQL Server Driver][SQL Server]The objectll'DF_VigRoles_RoleScope_1' is dependent on column 'RoleScope'. [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE DROP COLUMN RoleScope failed because one or more objects access this column."



cause
The upgrade is trying to drop the VigRoles.RoleScope column.  Due to the presence of a default constraint called DF_VigRoles_RoleScope_1 that was not dropped, it cannot drop the VigRoles.RoleScope column.

The upgrade script assumes that the constraint is named DF_VigRoles_RoleScope (Without the "_1").

In most cases the constraint is named DF_VigRoles_RoleScope, but in one particular case it might be named DF_VigRoles_RoleScope_1. There is a step in the version 3.0 to version 4.0 upgrade script that adds the constraint named as DF_VigRoles_RoleScope_1. This will probably be true for all customers that have upgraded from version 3.0 to version 4.0.


fix

To solve the problem:

  1. Back up the NVM database.
  2. In MSSQL Query Analyzer, run the following script immediately before running the upgrade:

Use VigilEnt

Go

--

-- Fix for ENG164140

--

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].[DF_VigRoles_RoleScope_1]'))

IF (OBJECT_ID('dbo.DF_VigRoles_RoleScope_1') IS NOT NULL) AND

(OBJECTPROPERTY(OBJECT_ID('dbo.DF_VigRoles_RoleScope_1'), 'IsDefaultCnst') = 1)

BEGIN

-- Drop constraint that was not taken care of in upgrade script

ALTER TABLE dbo.VigRoles Drop Constraint DF_VigRoles_RoleScope_1

END



Additional Information

Formerly known as NETIQKB47838