Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Enterprise : LIVES Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.EDIwebService.InsertPull(EDIPullDTO[] Items, String Enterprise) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\EDIwebService.svc.cs:line 4146 Date :9/19/2023 4:35:36 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. StackTrace :System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'tempdb' is full due to 'ACTIVE_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, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass186_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass186_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryReliably[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext() at System.Linq.ParallelEnumerable.ToList[TSource](ParallelQuery`1 source) at eTurns.DAL.ItemLocationDetailsDAL.GetItemLocationDetailsForTransferByItemGuid(Guid ItemGUID, Int64 RoomID, Int64 CompanyID, List`1 serialNumbers, List`1 lotNumbers) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 456 at eTurns.DAL.ItemLocationDetailsDAL.GetAllRecordseVmi(Int64 RoomID, Int64 CompanyId, Guid ItemGUID, Nullable`1 OrderDetailGUID, String ColumnName, List`1 serialNumbers, List`1 lotNumbers) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 0 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Service1.svc.cs:line 153 ClientConnectionId:a3f70803-56d3-483f-9c60-032543e6a557 Error Number:9002,State:4,Class:17 Date :9/19/2023 9:39:07 AM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called ============================================================================= Message : A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable) StackTrace :System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable) 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryGetTokenLength(Byte token, TdsParserStateObject stateObj, Int32& tokenLength) at System.Data.SqlClient.TdsParser.TrySkipValue(SqlMetaDataPriv md, Int32 columnOrdinal, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TrySkipRow(_SqlMetaDataSet columns, Int32 startCol, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryCloseInternal(Boolean closeReader) at System.Data.SqlClient.SqlDataReader.Close() at System.Data.Common.DbDataReader.Dispose(Boolean disposing) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.Finally() at System.Data.Entity.Internal.LazyEnumerator`1.Dispose() at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.Dispose() at System.Linq.ParallelEnumerable.ToList[TSource](ParallelQuery`1 source) at eTurns.DAL.ItemLocationDetailsDAL.GetItemLocationDetailsForTransferByItemGuid(Guid ItemGUID, Int64 RoomID, Int64 CompanyID, List`1 serialNumbers, List`1 lotNumbers) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 456 at eTurns.DAL.ItemLocationDetailsDAL.GetAllRecordseVmi(Int64 RoomID, Int64 CompanyId, Guid ItemGUID, Nullable`1 OrderDetailGUID, String ColumnName, List`1 serialNumbers, List`1 lotNumbers) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 0 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Service1.svc.cs:line 153 ClientConnectionId:482535fe-df07-4f18-b0ed-55a60b9dc33f Error Number:-1,State:0,Class:20 Date :9/19/2023 11:58:31 PM =============================================================================