Search This Blog

Tuesday, November 13, 2012

Lync Monitoring: An error has occurred during report processing. (rsProcessingAborted)

You get following error when trying to view the "all incidents reports" in Lync reporting services:


“An error has occurred during report processing. (rsProcessingAborted) Query Execution Failed for Dataset “GetAll”. (rsErrorExecutingCommand) Error convirting data type nvarchar to Datatime.”  

The problem is caused by the language settings within Internet Explorer. More particular the date formatting that is used in different parts of the world. In my case Belgium/Europe we use the following formatting: dd/mm/yyyy while in the US the date format is mm/dd/yyyy. This date formating causes the report to fail, therefore following error is displayed:
"Error convirting data type nvarchar to Datatime."

In order to get the correct date formating which the report is expecting, you need to add the EN-US language to Internet Explorer: 

Open Internet explorer, Go to Internet Options, Appearance and select language.

Move En-US to first place and click ok.




1 comment: