Version
7.x
Issue
Server upgrade failed.
Symptoms
Error on the screen shows:
A critical database script (migrate.sql) needed to install Bit9 Server failed.
Example:
Upgrade log shows the following lines, but the indexes mentioned below will be different-
UPGRADEDB: Msg 5074, Level 16, State 1, Server TPSECBIT91, Line 1
UPGRADEDB: The index 'ix_events_DBA1' is dependent on column 'process'.
UPGRADEDB: Msg 5074, Level 16, State 1, Server TPSECBIT91, Line 1
UPGRADEDB: The index 'ix_events_dba2' is dependent on column 'process'.
UPGRADEDB: Msg 4922, Level 16, State 9, Server TPSECBIT91, Line 1
UPGRADEDB: ALTER TABLE DROP COLUMN process failed because one or more objects access this column.
UPGRADEDB: A critical database script (migrate.sql) needed to install Bit9 Server failed.
On the example above, the index are for ix_events_dba2 and ix_events_DBA1.
Cause
The index is in use and need to be drop prior to the upgrade.
Solution
Find the table where the index need to be dropped from using this SQL script:
SELECT OBJECT_NAME(object_id) FROM sys.indexes WHERE name = ‘index here’
example: SELECT OBJECT_NAME(object_id) FROM sys.indexes WHERE name = 'ix_events_DBA1'
Use the object name result from the above SQL script for this next SQL script:
drop index [index here] on object name here;
GO
example: drop index [ix_events_DBA1] on dbo.events;
Once the index is dropped, proceed with the upgrade.