Error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Code=-2146232060 Proc= Line=0 Inner ex=The wait operation timed out Stack Trace= 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 HSP.Models.CSQL.GetDataSet(Int32& iPageNumberA, Int32 iPageSizeA, Boolean bRetainNullValuesA) in D:\HSP\Dev\HSP\Models\CSQL.cs:line 311 Source=.Net SqlClient Data Provider Extra info=EXEC @RC = hsp_Parts_FindByPartProductId @RetValue=Nothing, @RecordId=141028, @TotalRows=Nothing OUT ******** Dump of Http Request ******** Dumping Session variables... UserLocation=3.215.182.36, Ashburn, United States, US IsCrawlByBot=Y End of Session variable dump Dumping Request variables... id=141028 ASP.NET_SessionId=fvev52yncmeruqbhhxs1rnvt ALL_HTTP=HTTP_CONNECTION:Keep-Alive ALL_HTTP=HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q =0.9,*/*;q=0.8 ALL_HTTP=HTTP_ACCEPT_ENCODING:gzip ALL_HTTP=HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.5 ALL_HTTP=HTTP_HOST:www.heatingspareparts.com ALL_HTTP=HTTP_IF_MODIFIED_SINCE:Tue, 20 Aug 2019 09:14:35 MSK ALL_HTTP=HTTP_USER_AGENT:CCBot/2.0 (https://commoncrawl.org/faq/) ALL_RAW=Connection: Keep-Alive ALL_RAW=Accept: text/html,application/xhtml+xml,application/xml;q=0.9, */*;q=0.8 ALL_RAW=Accept-Encoding: gzip ALL_RAW=Accept-Language: en-US,en;q=0.5 ALL_RAW=Host: www.heatingspareparts.com ALL_RAW=If-Modified-Since: Tue, 20 Aug 2019 09:14:35 MSK ALL_RAW=User-Agent: CCBot/2.0 (https://commoncrawl.org/faq/) APPL_MD_PATH=/LM/W3SVC/9/ROOT APPL_PHYSICAL_PATH=d:\inetpub\wwwroot\HSP\ CERT_KEYSIZE=256 CERT_SECRETKEYSIZE=2048 CERT_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc. ", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certifi cate Authority - G2 CERT_SERVER_SUBJECT=OU=Domain Control Validated, CN=www.heatingsparepa rts.com CONTENT_LENGTH=0 GATEWAY_INTERFACE=CGI/1.1 HTTPS=on HTTPS_KEYSIZE=256 HTTPS_SECRETKEYSIZE=2048 HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc .", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certif icate Authority - G2 HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, CN=www.heatingsparep arts.com INSTANCE_ID=9 INSTANCE_META_PATH=/LM/W3SVC/9 LOCAL_ADDR=109.228.9.185 PATH_INFO=/boiler-spares/partno/753023 PATH_TRANSLATED=d:\inetpub\wwwroot\HSP\boiler-spares\partno\753023 QUERY_STRING=id=141028 REMOTE_ADDR=3.215.182.36 REMOTE_HOST=3.215.182.36 REMOTE_PORT=55082 REQUEST_METHOD=GET SCRIPT_NAME=/boiler-spares/partno/753023 SERVER_NAME=www.heatingspareparts.com SERVER_PORT=443 SERVER_PORT_SECURE=1 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/8.5 URL=/boiler-spares/partno/753023 HTTP_CONNECTION=Keep-Alive HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*; q=0.8 HTTP_ACCEPT_ENCODING=gzip HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5 HTTP_HOST=www.heatingspareparts.com HTTP_IF_MODIFIED_SINCE=Tue, 20 Aug 2019 09:14:35 MSK HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/) End of Request variable dump ******** End of Http Request Dump ******** ******** Start of Stack Trace ******** D:\HSP\Dev\HSP\Models\DBUtils.cs, GetStackTrace: Line 568: Column 17 D:\HSP\Dev\HSP\Models\CSQL.cs, GetDataSet: Line 311: Column 29 D:\HSP\Dev\HSP\Models\PartsRepository.cs, FindByPartProductId: Line 534: Column 21 D:\HSP\Dev\HSP\Controllers\SparesController.cs, PartNo: Line 49: Column 13 ******** End of Stack Trace ********