Error in Database Setup: ''Execution of UPGRADE_512_007_MMOBJS failed''

Symptom

The following error appears during Database Setup, most often while upgrading an existing OnGuard installation to version 5.12.110, on a machine running SQL Server 2005 Express:

"Execution of UPGRADE_512_007_MMOBJS failed"

Resolution

Important: Back up your database prior to proceeding, and verify the integrity of the backup.

This error is a result of the 'AccessControl' database exceeding the 4GB size limitation enforced in SQL Server 2005 Express.

To work around this limitation, perform one of the following steps.

1) In System Administration, perform an archive or purge of unneeded events, user transactions, etc.

2) To reduce the size of the database, type the following command in a query window in SQL Server Management Studio Express, then press to execute the query:

DBCC SHRINKDATABASE ('<database_name>')

Note: Substitute your database name for <database_name>.

3) If steps 1 and 2 do not reduce the size of your database to 4GB or less, you may need to obtain the full version of SQL Server 2005. The full version does not have the 4GB size limitation.

Applies To

OnGuard 2006 Technology Update (5.12.110)
OnGuard 2006 (5.12.012)
OnGuard 2005 Second Edition (5.11.216)
SQL Server 2005 Express

Additional Information

None