Hi all, I hope someone can help pinpoint to the the cause of the errors that I am getting. I have a report with a subscription that iterates through a set of values (totally 9)of a parameter. The data set query takes a long time (about half an hour) to execute. Initially I got timeout error. I increased the timeout value of the dataset and solved the problem. Now I am getting errors that give me little clue. Appended is an excerpt from the log. This seems to happen always about 30 minutes after the report generation starts. ReportingServicesService!runningjobs!b!5/5/2008-17:13:38:: i INFO: RunningJobContext.IsExpired; found expired request ReportingServicesService!processing!b!5/5/2008-17:13:38:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ... ReportingServicesService!runningjobs!b!5/5/2008-17:13:38:: i INFO: RunningJobContext.IsExpired; found expired request ReportingServicesService!runningjobs!b!5/5/2008-17:13:38:: i INFO: RunningJobContext.IsExpired; found expired request ReportingServicesService!processing!b!5/5/2008-17:13:38:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ... ReportingServicesService!runningjobs!b!5/5/2008-17:13:38:: i INFO: RunningJobContext.IsExpired; found expired request ReportingServicesService!processing!b!5/5/2008-17:13:38:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ... ReportingServicesService!processing!f!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!14!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!13!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!f!5/5/2008-17:13:39:: w WARN: Data set 'ICParam': Report processing has been aborted. ReportingServicesService!processing!c!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!c!5/5/2008-17:13:39:: w WARN: Data source 'eConsole': Report processing has been aborted. ReportingServicesService!processing!c!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!library!c!05/05/2008-17:13:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!processing!14!5/5/2008-17:13:39:: w WARN: Data set 'ICParam': Report processing has been aborted. ReportingServicesService!processing!13!5/5/2008-17:13:39:: w WARN: Data set 'ICParam': Report processing has been aborted. ReportingServicesService!processing!4!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!17!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!4!5/5/2008-17:13:39:: w WARN: Data source 'eConsole': Report processing has been aborted. ReportingServicesService!processing!17!5/5/2008-17:13:39:: w WARN: Data source 'eConsole': Report processing has been aborted. ReportingServicesService!processing!4!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!processing!17!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. ReportingServicesService!library!17!05/05/2008-17:13:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!library!4!05/05/2008-17:13:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!processing!e!5/5/2008-17:13:39:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ICParam., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ICParam. ---> System.Data.SqlClient.SqlException: Operation cancelled by user. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read() at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow() --- End of inner exception stack trace ---

How was this resolved?

Hi, I once had similar issue and resolved it by changing the report execution timeout properties in the Report Manager Site settings (Top right corner). Hope this helps.MSBI Developer

Hi, I once had similar issue and resolved it by changing the report execution timeout properties in the Report Manager Site settings (Top right corner). Hope this helps.MSBI Developer