Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djorre
Yak Posting Veteran
94 Posts |
 Posted - 2010-01-19 : 08:02:04
|
| Hi,I got a question.I know there is the log-files located atC:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFilesIn this logfiles I can find the errors that I want to check, errors like:w3wp!processing!8!1/4/2010-21:14:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DSHistorianTotaliser'., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DSHistorianTotaliser'. ---> System.Data.SqlClient.SqlException: The OLE DB provider "PIOLEDB" has not been registered.The problem is I want this errors to be viewed via the event logger, because it is a huge work to always search all the log files for errors. Is this possible? I read something about 'RSExecRole' and the reportserver databases but I can't find any specific way to do it.Please help, it would be very very usefull.Thanks, Joris |
|
|
|
|
|
How to log SSRS-report load errors to event viewer