Post reply

Data driven subscription errors when running

  • February 11, 2010 at 3:22 am

    #215556

    Hi folks,

    Recently there has been several of our data driven subscription errors and due to this, a lot of our subscriptions are either failing completely or partially, i.e. they are only sending some reports to some of our email recipients and then failing with the errors listed below. I've looked at the error logs and the main information I'm receiving is:

    Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set Supplier

    Or

    System.Data.SqlClient.SqlException: A time out occurred while waiting for memory resources to execute the query. Rerun the query.

    As time goes on, more subscriptions are failing and each of them use different stored procs for the report datasource and each use different queries for the data driven subscription; to pull the emails.

    Where the error mention that they cannot read the next dataset, suggest that it's the datasource sproc that it cannot read and NOT the query that contains the emails for the data driven subscription.

    Below is a part of the log that is pertinent to this error (I've highlighted the more important parts in blue):

    ReportingServicesService!processing!20!10/02/2010-18:45:48:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set sp_Ladbrokes_AllSupplierOutstandingCalls., ;

    Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set sp_Ladbrokes_AllSupplierOutstandingCalls. ---> System.Data.SqlClient.SqlException: A time out occurred while waiting for memory resources to execute the query. Rerun the query.

    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()

    depending on the data driven subscription, the same error appears but lists a different datasource sproc.

    Does anyone know why this might be happening, they were working fine before and now more subscriptions are having problems.

    Thanks in advance for any help

    P

  • March 16, 2010 at 9:24 am

    #1134546

    Hi there,

    Have you tried changing the time out for your report.

    In report manager under the properties for the report under execution, change the report execution timeout from default to 'do not timeout report execution'.

    Do your reports work fine when using report manager or intelligence studio?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply