Transaction (Process ID 187) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

System.Data.SqlClient.SqlException: Transaction (Process ID 187) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while reading from the store provider's data reader. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 187) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.HandleReaderException(Exception e)
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Unisoft.PFC.Data.Companies.PFC.DataAccess.Quotes.QuoteSearchPersist.Unisoft.PFC.Data.Interfaces.IPFCQuoteSearchDAO.GetSavedQuotes(Int32 AgentNumber) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Data\Companies\PFC\DataAccess\Quotes\QuoteSearchPersist.cs:line 318
   at Unisoft.EFinance.Presentation.Processing.AgentQuotes.AgentQuoteProcessing.GetSavedQuotes(IDataTablesRequest requestModel) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.Efinance.Presentation\Processing\AgentQuotes\AgentQuoteProcessing.cs:line 126
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass7_0.<BeginInvokeActionMethodWithFilters>b__1(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_6.<BeginInvokeAction>b__4()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult)

Logged on Friday, June 6, 2025 at 1:37:15 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CONNECTION:close HTTP_CONTENT_LENGTH:2191 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded; charset=UTF-8 HTTP_ACCEPT:application/json, text/javascript, */*; q=0.01 HTTP_ACCEPT_ENCODING:gzip, deflate, br, zstd HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.9 HTTP_COOKIE:ASP.NET_SessionId=xx0aipj1ujiwhjig4keowstn; _gid=GA1.2.158468011.1749062372; .ASPXAUTH=72EB61648288E1747D5F37E8DD73729F4CB1CD9A3E0DF93FDF7CBEA4E3F749323525FA861CAC6C8120F1AFFA156D8FADF03427C1F21BFF75A2A558AEE1E84EBA008A093C9F51303DDC10E5EED013C74F98299BEAF54174D37404111FCCB9898E; _gat_gtag_UA_123756894_2=1; _ga_C9J6ENXM06=GS2.1.s1749228071$o75$g1$t1749231432$j56$l0$h0; _ga=GA1.1.824044422.1746118981 HTTP_HOST:www.etifinance.com HTTP_REFERER:https://www.etifinance.com/AgentQuotes/Saved HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 HTTP_SEC_CH_UA_PLATFORM:"Windows" HTTP_X_REQUESTED_WITH:XMLHttpRequest HTTP_SEC_CH_UA:"Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24" HTTP_SEC_CH_UA_MOBILE:?0 HTTP_ORIGIN:https://www.etifinance.com HTTP_SEC_FETCH_SITE:same-origin HTTP_SEC_FETCH_MODE:cors HTTP_SEC_FETCH_DEST:empty HTTP_PRIORITY:u=1, i
ALL_RAWConnection: close Content-Length: 2191 Content-Type: application/x-www-form-urlencoded; charset=UTF-8 Accept: application/json, text/javascript, */*; q=0.01 Accept-Encoding: gzip, deflate, br, zstd Accept-Language: en-US,en;q=0.9 Cookie: ASP.NET_SessionId=xx0aipj1ujiwhjig4keowstn; _gid=GA1.2.158468011.1749062372; .ASPXAUTH=72EB61648288E1747D5F37E8DD73729F4CB1CD9A3E0DF93FDF7CBEA4E3F749323525FA861CAC6C8120F1AFFA156D8FADF03427C1F21BFF75A2A558AEE1E84EBA008A093C9F51303DDC10E5EED013C74F98299BEAF54174D37404111FCCB9898E; _gat_gtag_UA_123756894_2=1; _ga_C9J6ENXM06=GS2.1.s1749228071$o75$g1$t1749231432$j56$l0$h0; _ga=GA1.1.824044422.1746118981 Host: www.etifinance.com Referer: https://www.etifinance.com/AgentQuotes/Saved User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 sec-ch-ua-platform: "Windows" x-requested-with: XMLHttpRequest sec-ch-ua: "Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24" sec-ch-ua-mobile: ?0 origin: https://www.etifinance.com sec-fetch-site: same-origin sec-fetch-mode: cors sec-fetch-dest: empty priority: u=1, i
APPL_MD_PATH/LM/W3SVC/4/ROOT
APPL_PHYSICAL_PATH\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\
AUTH_PASSWORD*****
AUTH_TYPEForms
AUTH_USERrwhite
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERIALNUMBER
CERT_SERVER_ISSUERC=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECTOID.1.3.6.1.4.1.311.60.2.1.3=US, OID.1.3.6.1.4.1.311.60.2.1.2=Florida, OID.2.5.4.15=Private Organization, SERIALNUMBER=P96000055531, C=US, S=Florida, L=Miami, O="Unisoft Communications, Inc.", CN=www.etifinance.com
CERT_SUBJECT
CONTENT_LENGTH2191
CONTENT_TYPEapplication/x-www-form-urlencoded; charset=UTF-8
GATEWAY_INTERFACECGI/1.1
HTTP_ACCEPTapplication/json, text/javascript, */*; q=0.01
HTTP_ACCEPT_ENCODINGgzip, deflate, br, zstd
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.9
HTTP_CONNECTIONclose
HTTP_CONTENT_LENGTH2191
HTTP_CONTENT_TYPEapplication/x-www-form-urlencoded; charset=UTF-8
HTTP_COOKIEASP.NET_SessionId=xx0aipj1ujiwhjig4keowstn; _gid=GA1.2.158468011.1749062372; .ASPXAUTH=72EB61648288E1747D5F37E8DD73729F4CB1CD9A3E0DF93FDF7CBEA4E3F749323525FA861CAC6C8120F1AFFA156D8FADF03427C1F21BFF75A2A558AEE1E84EBA008A093C9F51303DDC10E5EED013C74F98299BEAF54174D37404111FCCB9898E; _gat_gtag_UA_123756894_2=1; _ga_C9J6ENXM06=GS2.1.s1749228071$o75$g1$t1749231432$j56$l0$h0; _ga=GA1.1.824044422.1746118981
HTTP_HOSTwww.etifinance.com
HTTP_ORIGINhttps://www.etifinance.com
HTTP_PRIORITYu=1, i
HTTP_REFERERhttps://www.etifinance.com/AgentQuotes/Saved
HTTP_SEC_CH_UA"Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24"
HTTP_SEC_CH_UA_MOBILE?0
HTTP_SEC_CH_UA_PLATFORM"Windows"
HTTP_SEC_FETCH_DESTempty
HTTP_SEC_FETCH_MODEcors
HTTP_SEC_FETCH_SITEsame-origin
HTTP_USER_AGENTMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36
HTTP_X_REQUESTED_WITHXMLHttpRequest
HTTPSon
HTTPS_KEYSIZE256
HTTPS_SECRETKEYSIZE2048
HTTPS_SERVER_ISSUERC=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECTOID.1.3.6.1.4.1.311.60.2.1.3=US, OID.1.3.6.1.4.1.311.60.2.1.2=Florida, OID.2.5.4.15=Private Organization, SERIALNUMBER=P96000055531, C=US, S=Florida, L=Miami, O="Unisoft Communications, Inc.", CN=www.etifinance.com
INSTANCE_ID4
INSTANCE_META_PATH/LM/W3SVC/4
LOCAL_ADDR10.10.0.24
LOGON_USERrwhite
PATH_INFO/AgentQuotes/SavedContinued
PATH_TRANSLATED\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\AgentQuotes\SavedContinued
QUERY_STRING
REMOTE_ADDR72.179.71.147
REMOTE_HOST72.179.71.147
REMOTE_PORT35854
REMOTE_USERrwhite
REQUEST_METHODPOST
SCRIPT_NAME/AgentQuotes/SavedContinued
SERVER_NAMEwww.etifinance.com
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/AgentQuotes/SavedContinued