Subscription fails - SQLException: Operation cancelled by user

• Jon Hunt-371355

  SSC Enthusiast

  Points: 147

  More actions

  September 29, 2006 at 8:29 am

  #170522

  Hi,

  I have a SQL 2000 Reporting Services job that has been running for more than a year, and last week it just stopped.  I checked the log files and saw this error, where a SQLException was causing a user cancellation.  I read another thread on here from last year an saw that it may be related to a timeout, but the report runs in a few seconds in the local browser.  I have set the execution properties to 'No timeout' for this report, yet the problem still happens.

  Anyone got any ideas?

  aspnet_wp!processing!820!9/29/2006-05:19:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TechnologyReview_Versions'., ;

   Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TechnologyReview_Versions'. ---> System.Data.SqlClient.SqlException: Operation cancelled by user.

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

     at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.ReportProcessing.a2.v()

     --- End of inner exception stack trace ---

  aspnet_wp!processing!820!9/29/2006-05:19:25:: e ERROR: An exception has occurred in data source 'TechnologyReview_Versions'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TechnologyReview_Versions'. ---> System.Data.SqlClient.SqlException: Operation cancelled by user.

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

     at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.ReportProcessing.a2.v()

     --- End of inner exception stack trace ---

     at Microsoft.ReportingServices.ReportProcessing.a2.v()

     at Microsoft.ReportingServices.ReportProcessing.ax.c()

     at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)

     at Microsoft.ReportingServices.ReportProcessing.ax.b()

     at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)

  aspnet_wp!processing!820!9/29/2006-05:19:25:: e ERROR: An exception has occurred. Trying to abort processing. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TechnologyReview_Versions'. ---> System.Data.SqlClient.SqlException: Operation cancelled by user.

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

     at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)

     at Microsoft.ReportingServices.ReportProcessing.a2.v()

     --- End of inner exception stack trace ---

     at Microsoft.ReportingServices.ReportProcessing.a2.v()

     at Microsoft.ReportingServices.ReportProcessing.ax.c()

     at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)

     at Microsoft.ReportingServices.ReportProcessing.ax.b()

     at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)

  aspnet_wp!processing!820!9/29/2006-05:19:25:: i INFO: Some other thread has already aborted processing.

  aspnet_wp!processing!ccc!9/29/2006-05:19:25:: 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.

  aspnet_wp!processing!ccc!9/29/2006-05:19:25:: e ERROR: Data source 'test': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user.

     at Microsoft.ReportingServices.ReportProcessing.b.c()

     at Microsoft.ReportingServices.ReportProcessing.z.af()

     at Microsoft.ReportingServices.ReportProcessing.s.a()

  aspnet_wp!processing!ccc!9/29/2006-05:19:25:: w WARN: Data source 'test': Report processing has been aborted.

  aspnet_wp!processing!ccc!9/29/2006-05:19:25:: 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.

  aspnet_wp!library!ccc!09/29/2006-05:19:25:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.

  aspnet_wp!webserver!ccc!09/29/2006-05:19:25:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Report processing has been canceled by the user.  ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user.

     at Microsoft.ReportingServices.ReportProcessing.b.c()

     at Microsoft.ReportingServices.ReportProcessing.z.af()

     at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)

     at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, ax A_4, DateTime A_5, z& A_6)

     at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)

     at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)

     at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)

     at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

     at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()

     at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

     --- End of inner exception stack trace ---

     at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

     at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

     at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)

     at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()

     at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)

     at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()

   

  Cheers,

  Jon