Error received in the log file when running a stored procedure and gatherings are not updating the Exchange at a Glance website.
"Server Name: '<LOCALHOST>
'Error: EOleException Source:LPMFramework.LPMHost Message:Framework
error in TMailboxReviewDataObjectSourceDataObjectSource.ExecuteFramework error in C:\PROGRAM FILES\QUEST
SOFTWARE\MESSAGESTATS\MailboxReview.LPM.TMailboxReviewTaskProcessor.Task Processor.ProcessObject Framework error in C:\PROGRAM FILES\QUEST SOFTWARE\MESSAGESTATS\Database.LPM.TSQLv1LogDataStore.DataStore.StoreObject Error in Executing SQL Statement - Message: User does not have permission to perform this operation on table 'T_ServersAtAGlance';; SQLStatement = EXEC PR_CalculateAggregates;; Param List ="
The account running the gathering doesn't have rights to run the SQL Statement = EXEC PR_CalculateAggregates on the T_ServersAtAGlance table, which would cause the Exchange at a Glance not to update correctly.
The MessageStats Admin Group doesn't have the right to truncate tables in the database, which is what the PR_CalculateAggregates is doing.
Confirm the permissions on the T_ServersAtAGlance table, under Properties, to confirm that the MessageStats_Admin Role has, SELECT, INSERT, UPDATE, DELETE and check the PR_CalculateAggregates Store Procedure for MessageStats_Admin Role has, EXEC.
TSQLv1LogDataStore.DataStore.StoreObject Error in Executing SQL Statement - Message: User does not have permission to perform this operation on table 'T_ServersAtAGlance';; SQLStatement = EXEC PR_CalculateAggregates;; Param List =
Confirm that the MessageStats Admin Group in SQL Enterprise Manager, Security, Logins under the properties has Public, db_ddladmin and MessageStats_Admin Roles assigned.
In SQL Enterprise Manager, check the actual privileges on the T_ServersAtAGlance table. Right-click on the T_ServersAtAGlance table and select All Tasks | Manage Privileges. If it's not set, execute the stored procedure PR_SETPERMISSIONS via query analyzer:
Then execute the PR_CalculateAggregates stored procedure to update the Exchange at a Glance web page via query analyzer::
Solution applies to MessageStats v5x and v6x.