-
Title
Numerous "Invalid object name" and "Cannot find the object" errors are displayed when trying to m -
Description
Errors similar to the following are displayed when trying to manually upgrade the MessageStats database:
"Invalid object name 'T_Configuration'"
"Cannot find the user '<MESSAGESTATS_SERVICE_ACCOUNT>', because it does not exist or you do not have permission"
"Cannot find the object 'T_Organizations' because it does not exist or you do not have permissions"These errors are repeated for different tables and objects
-
Cause
These errors can occur if the MessageStats migration SQL script is not run against the MessageStats database or the MessageStats database is offline.
-
Resolution
Ensure the MessageStats migration SQL script is run against the MessageStats database and the MessageStats database is online:
1. Prior to running the SQL script select the MessageStats database from the dropdown box in the top left corner of the SQL Server Management Studio
2. If the MessageStats database is offline it will display "(Offline)" next to the database name. Right click the database and select Tasks | Bring Online