=============================================================================
Enterprise : Gexpro Services
Message : 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)
   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.DbCommand.ExecuteReader()
   at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters)
   at System.Data.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, Object[] parameters)
   at eTurns.DAL.OrderDetailsDAL.ExecuteQuery(String query)
   at eTurns.DAL.OrderDetailsDAL.DB_Insert(OrderDetailsDTO objDTO)
   at eTurnsServices.EDIwebService.InsertOrder(EDIOrderMasterDTO[] objDTO, String EnterpriseName)
ClientConnectionId:97732f8c-49e2-4e40-a7ea-5c2ecc03527a
Error Number:-2,State:0,Class:11
Date :7/13/2017 7:38:23 AM
=============================================================================


=============================================================================
Enterprise : Rexel
Message : System.InvalidOperationException: Sequence contains no elements
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at eTurnsServices.AlertHelper.<>c__DisplayClass0_0.<SendMailToSupplier>b__2(NotificationDTO t)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at eTurnsServices.AlertHelper.SendMailToSupplier(SupplierMasterDTO ToSuppliers, OrderMasterDTO objOrder, eTurnsRegionInfo objCompanyConfigDTO, EnterpriseDTO objEnterpriseDTO)
   at eTurnsServices.EDIwebService.InsertOrder(EDIOrderMasterDTO[] objDTO, String EnterpriseName)
Date :7/13/2017 3:44:16 PM
=============================================================================


=============================================================================
Enterprise : Rexel
Message : System.InvalidOperationException: Sequence contains no elements
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at eTurnsServices.AlertHelper.<>c__DisplayClass0_0.<SendMailToSupplier>b__2(NotificationDTO t)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at eTurnsServices.AlertHelper.SendMailToSupplier(SupplierMasterDTO ToSuppliers, OrderMasterDTO objOrder, eTurnsRegionInfo objCompanyConfigDTO, EnterpriseDTO objEnterpriseDTO)
   at eTurnsServices.EDIwebService.InsertOrder(EDIOrderMasterDTO[] objDTO, String EnterpriseName)
Date :7/13/2017 3:44:18 PM
=============================================================================


=============================================================================
Enterprise : Gexpro
Message : System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 423) 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.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)
   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.DbCommand.ExecuteReader()
   at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters)
   at System.Data.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, Object[] parameters)
   at eTurns.DAL.OrderDetailsDAL.ExecuteQuery(String query)
   at eTurns.DAL.OrderDetailsDAL.DB_Insert(OrderDetailsDTO objDTO)
   at eTurnsServices.EDIwebService.InsertOrder(EDIOrderMasterDTO[] objDTO, String EnterpriseName)
ClientConnectionId:eaa58282-55de-41cd-a23a-1357b303c2c7
Error Number:1205,State:52,Class:13
Date :7/13/2017 7:15:27 PM
=============================================================================