============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 12:51:08 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 1:21:18 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 1:32:31 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 2:20:32 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 2:31:11 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 4:01:32 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 7:47:29 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 7:47:30 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 7:48:14 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 7:48:30 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 7:49:45 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 8:28:23 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 8:28:29 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 8:29:24 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 9:00:22 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 9:01:15 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 9:08:37 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 9:08:59 PM ============================================================================= ============================================================================= 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, String defaultContainerName) at eTurns.DAL.eTurnsEntities..ctor(String connectionString) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\eTurnsEntities.Designer.cs:line 132 at eTurns.DAL.CostUOMMasterDAL.GetCachedData(Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 57 at eTurns.DAL.CostUOMMasterDAL.GetRecord(Int64 id, Int64 RoomID, Int64 CompanyID, Boolean IsArchived, Boolean IsDeleted) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CostUOMMasterDAL.cs:line 252 at eTurns.DAL.ItemLocationDetailsDAL.CalculateAndGetPullCreditCost(Nullable`1 itemDetailCost, Nullable`1 costUOM, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 4576 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPull(List`1 objData, String calledfrom, String PullAction) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemLocationDetailsDAL.cs:line 2195 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 251 Date :11/2/2015 9:10:37 PM ============================================================================= ============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. 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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite) 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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.CartItemDAL.SaveCartItem(CartItemDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 920 at eTurns.DAL.CartItemDAL.<>c__DisplayClassee.b__e4(BinMasterDTO t) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3286 at System.Collections.Generic.List`1.ForEach(Action`1 action) at eTurns.DAL.CartItemDAL.AutoCartUpdateByCode(Guid ItemGUID, Int64 UserId, Int64 EnterpriseId, Boolean IsFromUI) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\CartItemDAL.cs:line 3057 at eTurns.DAL.ItemMasterDAL.Edit(ItemMasterDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\ItemMasterDAL.cs:line 2958 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4835 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :11/2/2015 9:12:11 PM =============================================================================