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)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center