IT Consultant Everyday Notes

Just some problems/solutions storage

Category Archives: Monitoring

Lync 2010: User activity report failed with “An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘CallList’. (rsErrorExecutingCommand)”

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.”

 

Resolution:

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 Winking smilehttp://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.