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