Page Load: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at CMSWebParts_MyWebParts_ChartHomePageV2Bar.generateGraph(String pvCountryCode)
at CMSWebParts_MyWebParts_ChartHomePageV2Bar.Page_Load(Object sender, EventArgs e)
ClientConnectionId:57f16deb-659c-4095-a34e-66fc3a8c2021
Error Number:-2,State:0,Class:11
SELECT [January] AS Jan,[February] AS Feb,[March] AS Mar,[April] AS Apr,[May] AS May,[June] AS Jun,[July] AS Jul,[August] AS Aug,[September] AS Sep,[October] AS Oct,[November] AS Nov,[December] AS Dec,CountryCode FROM ( SELECT [Month_Name], RateTotal / 7 as RateTotal,CountryCode FROM [cartrawler_v2].[dbo].[LocationVehicleHistoryV2] WHERE VehicleMatrixCategory in ('Compact','Economy','Fullsize','Intermediate','Luxury','Mini','Standard') AND CountryCode IN ('AU','ES','CY','FR','DE','GR','is','IT','NL','PT','ZA','ES','CH','TR','AE','GB','US') ) AverageRates PIVOT( Min(RateTotal) FOR [Month_Name] IN( January, February, March, April, May, June, July, August, September, October, November, December ) ) AS PivotTable ORDER BY CountryCode
//]]>