When running the Report BlackBerry | Users | Top Message Senders and Receivers | By Messages it returns the following error and SQL query on screen:
"Unexpected error while attempting to read from the database."
"View or function 'dbo.V_BB_UsersRaw' has more column names specified than columns defined."
SELECT SUM([TotalMessages]) AS [TotalMessages (Total)], AVG([TotalMessages]) AS [TotalMessages (Avg)], SUM([TotalBytes]) AS [TotalBytes (Total)], AVG([TotalBytes]) AS [TotalBytes (Avg)], SUM([AverageMessageSize(Bytes)]) AS [AverageMessageSize(Bytes) (Total)], AVG([AverageMessageSize(Bytes)]) AS [AverageMessageSize(Bytes) (Avg)], COUNT(*) AS [_Count] FROM (SELECT TOP 10 DisplayName, GroupName, ServerName, BBDomainName, BESServerHost, MailboxSMTPAddr, MailboxDN, MailboxStoreDN, BBModelName, BBPlatformVersion, BBHomeNetwork, BBIMEI, BBPIN, CreationTime, TotalMessages, TotalBytes, [AverageMessageSize(Bytes)] FROM (SELECT T_BB_UserMessages.BBUserGUID, SUM(CAST(MessagesSent AS BIGINT)) AS TotalMessages, SUM(BytesSent) / 1024.0 AS TotalBytes, ISNULL((SUM(BytesSent)) / NULLIF(SUM(MessagesSent), 0), 0) AS [AverageMessageSize(Bytes)] FROM T_BB_UserMessages WHERE (MessagesSent > 0) AND ((([AggregateDay] >= '2012-01-01' AND [AggregateDay] < '2012-03-24'))) GROUP BY T_BB_UserMessages.BBUserGUID) AS InnerQuery INNER JOIN dbo.V_BB_UsersRaw ON dbo.V_BB_UsersRaw.BBUserGUID = InnerQuery.BBUserGUID INNER JOIN dbo.T_BB_Servers ON dbo.V_BB_UsersRaw.BESServerGUID = dbo.T_BB_Servers.BESServerGUID LEFT OUTER JOIN dbo.T_BB_MailboxStores ON dbo.V_BB_UsersRaw.BBMailboxStoreGUID = dbo.T_BB_MailboxStores.BBMailboxStoreGUID INNER JOIN dbo.T_BB_ConfigDatabases ON dbo.T_BB_Servers.BESConfigDbGUID = dbo.T_BB_ConfigDatabases.BESConfigDbGUID ORDER BY TotalMessages DESC) [_IntResult]
(0x80040217)
BlackBerry Report pack needs to be upgraded to the current version that is bundled with the MessageStats Full Package in the Platforms directory. This could also mean that the MessageStats Database that contains Blackberry Report Pack information needs to be updated manually due to a clustered SQL server.
RESOLUTION 1
Upgrade MessageStats to the latest version along with the Blackberry Report pack that is found in the Platforms directory of the full unzipped package.
RESOLUTION 2
If already on the latest version of MessageStats, Uninstall and Reinstall the Blackberry Report Pack and ensure the database is updated correctly.
RESOLUTION 3
Rerun the Blackberry Script manually "QmsBlackberryDatabase.sql” against the MessageStats database that is found in the unzipped package at this location:
\SQL\Platforms\BlackBerry
