-
Title
Opening console gives error: "Invalid object name 'dbo.T_MBIConfiguration' 80040E37.8" -
Description
When opening the MessageStats console and see the below error on screen:
"Unable to connect to QMS Server . Error executing SQL SELECT TOP 1 URL, WebsiteServerName FROM dbo.T_MBIConfiguration. Invalid object name 'dbo.T_MBIConfiguration' 80040E37.8"
-
Cause
The MessageStats Business Insights node in the MessageStats console uses the T_MBIConfiguration table to get the Business Insights website URL. It displays product information and instructions on how to create a link to Business Insights if it is installed. If this table does not exist in the database you will see this error.
This can also be an indication that the MessageStats database was not upgraded correctly from versions prior to 7.x as this table is now required.
Last, if you moved your MessageStats 6.x database to another SQL server and then upgraded it to 7.x, you may have forgot to update the MessageStats console to point to the new location of the database.
-
Resolution
Rerun the MessageStatsMigration.sql script again against the MessageStats database to ensure it was upgraded correctly and verify that the T_MBIConfiguration table exists.
If you moved your MessageStats database from one SQL server to another and then upgraded it ensure that the database location was updated in the Console.