Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Upgrade failed: A critical database script (migrate.sql) needed to install Bit9 Server failed.

Upgrade failed: A critical database script (migrate.sql) needed to install Bit9 Server failed.

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.

Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎03-11-2015
Views:
365
Contributors