After a successful upgrade from MessageStats 6.10.0 to Messagestats 7.2 and while upgrading the LyncReportPack to the 7.2 The following Error Occured.
Failed to execute the database creation script.
Error code = -2147217900
Description = An object or column name is missing or empty. for SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 42000
NativeError = 1038
SQL script file begin line = 7520
SQL script file end line = 7556
The account running the Lync Report Pack upgrade does not have the required permissions in the MessageStats Database.
If the when upgrading the MessageStats database to version 7.2 it upgraded successfully no further action is required. Starting with MessageStats 7.2 the MessageStatsMigration.sql script which upgrades the MessageStats database also upgrades the database for all the report packs.
