============================================================================= Provide Fault: The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:objDTO. The InnerException message was 'There was an error deserializing the object of type eTurnsServices.WorkOrderSVCDTO[]. The value '' cannot be parsed as the type 'double'.'. Please see InnerException for more details. StackTrace :System.ServiceModel.Dispatcher.NetDispatcherFaultException: The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:objDTO. The InnerException message was 'There was an error deserializing the object of type eTurnsServices.WorkOrderSVCDTO[]. The value '' cannot be parsed as the type 'double'.'. Please see InnerException for more details. ---> System.Runtime.Serialization.SerializationException: There was an error deserializing the object of type eTurnsServices.WorkOrderSVCDTO[]. The value '' cannot be parsed as the type 'double'. ---> System.Xml.XmlException: The value '' cannot be parsed as the type 'double'. ---> System.FormatException: Input string was not in a correct format. at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Xml.XmlConvert.ToDouble(String s) at System.Xml.XmlConverter.ToDouble(String value) --- End of inner exception stack trace --- at System.Xml.XmlConverter.ToDouble(String value) at System.Xml.XmlDictionaryReader.ReadElementContentAsDouble() at ReadWorkOrderSVCDTOFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) at System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) at System.Runtime.Serialization.XmlObjectSerializerReadContext.InternalDeserialize(XmlReaderDelegator reader, String name, String ns, Type declaredType, DataContract& dataContract) at System.Runtime.Serialization.XmlObjectSerializerReadContext.InternalDeserialize(XmlReaderDelegator xmlReader, Int32 id, RuntimeTypeHandle declaredTypeHandle, String name, String ns) at ReadArrayOfWorkOrderSVCDTOFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString , XmlDictionaryString , CollectionDataContract ) at System.Runtime.Serialization.CollectionDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) at System.Runtime.Serialization.XmlObjectSerializerReadContext.InternalDeserialize(XmlReaderDelegator reader, String name, String ns, Type declaredType, DataContract& dataContract) at System.Runtime.Serialization.XmlObjectSerializerReadContext.InternalDeserialize(XmlReaderDelegator xmlReader, Type declaredType, DataContract dataContract, String name, String ns) at System.Runtime.Serialization.DataContractSerializer.InternalReadObject(XmlReaderDelegator xmlReader, Boolean verifyObjectName, DataContractResolver dataContractResolver) at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver) --- End of inner exception stack trace --- at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver) at System.ServiceModel.Dispatcher.DataContractSerializerOperationFormatter.PartInfo.ReadObject(XmlDictionaryReader reader, XmlObjectSerializer serializer) at System.ServiceModel.Dispatcher.DataContractSerializerOperationFormatter.DeserializeParameterPart(XmlDictionaryReader reader, PartInfo part, Boolean isRequest) --- End of inner exception stack trace --- at System.ServiceModel.Dispatcher.DataContractSerializerOperationFormatter.DeserializeParameterPart(XmlDictionaryReader reader, PartInfo part, Boolean isRequest) at System.ServiceModel.Dispatcher.DataContractSerializerOperationFormatter.DeserializeParameters(XmlDictionaryReader reader, PartInfo[] parts, Object[] parameters, Boolean isRequest) at System.ServiceModel.Dispatcher.DataContractSerializerOperationFormatter.DeserializeBody(XmlDictionaryReader reader, MessageVersion version, String action, MessageDescription messageDescription, Object[] parameters, Boolean isRequest) at System.ServiceModel.Dispatcher.OperationFormatter.DeserializeBodyContents(Message message, Object[] parameters, Boolean isRequest) at System.ServiceModel.Dispatcher.OperationFormatter.DeserializeRequest(Message message, Object[] parameters) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.DeserializeInputs(MessageRpc& rpc) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet) Date :7/3/2017 8:59:51 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:00:03 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:08:19 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:08:28 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:09:14 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:09:20 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:09:39 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:09:59 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:10:09 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:13:25 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:23:30 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:23:48 AM ============================================================================= Insert WorkOrder called ============================================================================= Message : The underlying provider failed on ConnectionString. StackTrace :System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Use of key 'failover partner' requires the key 'initial catalog' to be present. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString) at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) at eTurns.DAL.RoomDAL.GetRoomByID(Int64 id) at eTurnsServices.EDIwebService.InsertWorkOrder(WorkOrderSVCDTO[] objDTO, String EnterpriseName) Date :7/3/2017 9:25:16 AM ============================================================================= ============================================================================= Enterprise : Gexpro Message : System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 273) 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:2663d498-a2d5-4068-950e-b01e62e41a00 Error Number:1205,State:52,Class:13 Date :7/3/2017 2:10:36 PM =============================================================================