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
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
=============================================================================
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.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead)
   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.Common.Internal.Materialization.Shaper`1.Finally()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.Dispose()
   at System.Linq.ParallelEnumerable.ToList[TSource](ParallelQuery`1 source)
   at eTurns.DAL.ItemLocationDetailsDAL.GetCachedDataeVMIForTransfer(Guid ItemGUID, Int64 RoomID, Int64 CompanyID, List`1 serialNumbers, List`1 lotNumbers)
   at eTurns.DAL.ItemLocationDetailsDAL.GetAllRecordseVmi(Int64 RoomID, Int64 CompanyId, Guid ItemGUID, Nullable`1 OrderDetailGUID, String ColumnName, List`1 serialNumbers, List`1 lotNumbers)
   at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType)
ClientConnectionId:721751ad-88ba-4443-98ff-9d3b51359848
Error Number:-1,State:0,Class:20
Date :11/28/2019 7:06:56 PM
=============================================================================