Symptom
When running Database Setup, such as after upgrading your OnGuard version, you might see an error such as:
Invalid object name 'SYS.OBJECTS'.
Invalid object name 'sys.database_principals'.
Details: Database error executing a select.
select sys.database_principals.name from sys.objects, sys.database_principals where sys.objects.type='U' and sys.objects.schema_id=sys.database_principals.principal_id and sys.objects.name='LNLCONFIG'
Resolution
You will get this error anytime your database's compatability mode is not set correctly. In OnGuard 6.4, we require the compatability mode to be 90 or higher.In this case, the database was a master and the compatability mode was set correctly. This error showed when the master tried communicating with one of the regions. You can determine which region the master has problems communicating with in the Error log, under More Details or Enable Verbose Logging.
To correct this issue:
- Update all regional servers to SQL 2005 or later, update the compatabilty mode, and then run Database Setup on the master.
- Make sure the user you are connected to in Windows does not have permission to communicate with the other databases using Windows Authentication. Create a new Windows log on that is not part of built-in administrators, and the run Database Setup. You will be prompted to log onto the regional servers, but you must skip this portion if the regions are still running SQL 2000.
Applies To
OnGuard 2009 (6.3.249)
OnGuard 2010 (6.4.500)
