Lync 2010: User activity report failed with “An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘CallList’. (rsErrorExecutingCommand)”
October 26, 2012
Posted by on
Issue: User Activity report failed with “
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘CallList’. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.”
1. It happens after CU installation. For me – after CU7, some people report it happens after CU6 too.
2. Read instructions in CU KB – you must update database! using something like :Install-CsDatabase -Update -ConfiguredDatabases –SqlServerFqdn <SQL Server without instance> –UseDefaultSqlPaths
In my case SQl FQDN did not work – I put NETBIOS name. I guess the main idea is to put how it is displayed in your Topology Builder.
3. Start Lync 2010 Deployment Wizard and redeploy Monitoring Reports. I did it from Front-End Server.
4. Above mentioned KB does not instruct you to update Monitoring Database – this is from other KB http://support.microsoft.com/kb/2703324
my command looks like: Install-CsDatabase -DatabaseType Monitoring -Update –SqlServerFqdn <Monitoring Server Name>
in my case, again, server name was just a NETBIOS name and I ran it from a Front-End server.