Saturday, January 23, 2016

An error has occurred during report processing in SSRS

I have created a report and started creating subscriptions and used to get this error and wasn’t sure what’s going on.

Best way to trouble shoot this error is to check the SSRS logs under C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles for the default install location else which ever location SQL Server has been installed.

The Log files are of max size of 32MB and a new file gets created after reaching that size and the file name will look like ReportServerService__02_15_2010_12_56_37.log where 02_15_2010_12_56_37 refers to “MM_DD_YYYY_HH_mm_SS” format.

http://blogs.msdn.com/b/deanka/archive/2010/02/16/troubleshooting-subscriptions-part-ii-using-the-report-services-trace-log-file.aspx

Technorati Tags: ,