Hi,
I am getting a sql timeout errors (see trace) when running some reports using the server exporter
How do I change the query timeout ?
Thanks
Wayne
Error in DataSource RetailerDataSource. at Infragistics.Reports.Engine.Data.ReportDataSourceManager.GetReportDataSource(DataSource reportDataSource) at Infragistics.Reports.Engine.Planner.ComputeDataSourceBasedOnPlan(IQueryable records, IDataProcessingScheme dataProcessingScheme, IEnumerable`1 rootGroupPath) at Infragistics.Reports.Engine.Planner.GetDataSourceFor(IDataRegion dataRegion, IReportDataSourceCursor dataCursor) at Infragistics.Reports.Engine.ReportItemProcessorHost.GetReportDataSourceCursor(ReportItem reportItem) at Infragistics.Reports.Engine.Processing.ReportInstanceModelBuilder.BuildInit() at Infragistics.Reports.Engine.Processing.ReportInstanceModelBuilder.BuildReport() at Infragistics.Reports.Engine.ReportProcessor.ProcessReportInternal() at Infragistics.Reports.Server.ServerExporter.Export(Stream output, String exportFormat) Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at Infragistics.Reports.Engine.Data.QueryHelper.RunQuery[T](String dataProvider, String connectionString, Query query, IDictionary`2 parameterValues, Func`2 action, CommandBehavior behavior) at Infragistics.Reports.Engine.Data.SqlReportDataProvider.Execute() at Infragistics.Reports.Engine.Data.ReportDataSourceManager.GetReportDataSource(DataSource reportDataSource)
Hi Leo,
How do I change the timeout through the ServerExporter, I have been unable to find this.
I am currently loading the igr file into an XmlDocument and manipulating it before passing it to the ServerExporter to make changes to the datasources and report layout. As I am dynamically modifing the query in the datasource I must use a SqlDataSource
Hi Wayne,
Currently there is no way to change the query timeout (we will allow it soon). As a workaround you can do the query yourself (setting the timeout you need) and pass the data source using the DataSources properties of the ServerExporter.
Hope it helps.
Thanks,
Leo