Active Administrator 5.6 - Unable to upgrade database from 5.5x to 5.6x (SL3432)

Active Administrator 5.6 - Unable to upgrade database from 5.5x to 5.6x

After upgrading Active Administrator Server Management from version 5.5x to 5.6x the messages “Database upgrade failed”, and “Configuration completed with errors. See log file for details…” are displayed, and shown below: 

The log file can also report “Failed to connect to server….”, as shown below: 

This can occur with large databases, or if the database is remote, and particularly with databases that haven’t been maintained.

Run an upgrade script directly in SQL to resolve this issue.

First, if you are unsure that the current version of your database is 5.5, you can find what the current version is within SQL. (SQL 2005 is used in this example). Expand the AA database | Programmability | Functions | Scalar-valued Functions and right click on “dbo.GetDBVersion”. Next, select Script Function as | SELECT TO | New Query Editor Window, as shown below: 

Then, “Execute” the command and you will see the current version of the database in the lower pane.

If the database is at version 5.5, as shown above, please follow the steps below:

• Backup the database.

• The agents should already have been deactivated when beginning the upgrade, but if they aren’t, deactivate them via the Active Administrator Server Management Console, Collection Agents tab:

.

• On the machine where Active Administrator (AA) is installed, copy the contents of “UpdateDatabase_5.5_5.6.sql” located in C:\Program Files\ScriptLogic Corporation\Active Administrator 5\Server.

• Open SQL Management Studio where the AA Database resides. The default AA version 5.x database name is “ActiveAdministrator.

• Right click on the AA database and select “New Query”.

• Then “Execute” the query making sure that it is only run against the Active Administrator database, as shown below:

• To confirm the version of the database run “dbo.GetDBVersion” again and the database should now be 5.6, as shown below: