深圳智汇创想科技有限公司

[步骤]

(@CustomerID int,@WareHouseType int)  SELECT alias.[ID],alias.[CustomerID],alias.[WareHouseID],alias.[SKU],alias.[PositionID],alias.[WarningNum],alias.[GoodNum],alias.[BadNum],alias.[LockNum],alias.[AddAdminID],alias.[AddAdminName],alias.[AveragePrice],alias.[HistoryInNum],alias.[HistoryOutNum],alias.[Memo],alias.[AddTime],alias.[UpdateTime],alias.[AddCycle],alias.[HaulageTime],alias.[BuyTime],alias.[SafetyDays],alias.[AvgDailySales],alias.[OrderSourceSKU],alias.[OrderSourceID],alias.[ASIN],alias.[FNSKU],alias.[isHandUpdate],alias.[BatchNum],alias.[SynchronousGoodNum],alias.[RepairTrapTime],alias.[APIUpdateTime],alias.[FirstLegShippingType],alias.[UnitBuyShipFee],alias.[FBA_Reserved_CustomerOrders],alias.[FBA_Reserved_Transfers],alias.[FBA_Reserved_Processing],alias.[IsOneProductToMorePosition],alias.[PlatformWarningNum],alias.[IsEFN],alias.[EFNCountry],alias.[IsEFNWareHouse],alias.[ProtectNum],alias.[EstimatedSaleNum],alias.[ReceiptRecordSynTime],alias.[IsHandleEFN],alias.[EfnUpdateUser],alias.[StockType],alias.[IsNARF],alias.[NARFCountry],alias.[NARFUpdateUser],alias.[OnWayNum],alias.[IsSynSuccess],alias.[Title],alias.[CombinationsValueName],alias.[OverseaProductId],alias.[UnderWayNum],alias.[UnderWayLockNum],alias.[PrepOwnerConstraint],alias.[PrepOwnerCategory],alias.[LabelOwner],alias.[Expiration],alias.[SkuCode],alias.[isDullLabel],alias.[AdjustmentOnWayNum],alias.[StorageType],alias.[PlatformOnWayNum],alias.[Last7DaysSalesOutboundQuantity],alias.[Last14DaysSalesOutboundQuantity],alias.[Last30DaysSalesOutboundQuantity]                          FROM dbo.RB_WareHouse_Product (NOLOCK) alias                              LEFT JOIN dbo.RB_WareHouse (NOLOCK) b                                  ON b.CustomerID = alias.CustomerID                                     AND alias.WareHouseID = b.ID                          WHERE alias.CustomerID = @CustomerID                                AND b.WareHouseType = @WareHouseType                                AND alias.GoodNum > 0                                AND alias.UpdateTime < DATEADD(DAY, -5, GETDATE());

[04:28:16]  -------------------------------------------------------------
CODE:N042816219
Error:20_121_0_-2146232060
SQL:  SELECT alias.[ID],alias.[CustomerID],alias.[WareHouseID],alias.[SKU],alias.[PositionID],alias.[WarningNum],alias.[GoodNum],alias.[BadNum],alias.[LockNum],alias.[AddAdminID],alias.[AddAdminName],alias.[AveragePrice],alias.[HistoryInNum],alias.[HistoryOutNum],alias.[Memo],alias.[AddTime],alias.[UpdateTime],alias.[AddCycle],alias.[HaulageTime],alias.[BuyTime],alias.[SafetyDays],alias.[AvgDailySales],alias.[OrderSourceSKU],alias.[OrderSourceID],alias.[ASIN],alias.[FNSKU],alias.[isHandUpdate],alias.[BatchNum],alias.[SynchronousGoodNum],alias.[RepairTrapTime],alias.[APIUpdateTime],alias.[FirstLegShippingType],alias.[UnitBuyShipFee],alias.[FBA_Reserved_CustomerOrders],alias.[FBA_Reserved_Transfers],alias.[FBA_Reserved_Processing],alias.[IsOneProductToMorePosition],alias.[PlatformWarningNum],alias.[IsEFN],alias.[EFNCountry],alias.[IsEFNWareHouse],alias.[ProtectNum],alias.[EstimatedSaleNum],alias.[ReceiptRecordSynTime],alias.[IsHandleEFN],alias.[EfnUpdateUser],alias.[StockType],alias.[IsNARF],alias.[NARFCountry],alias.[NARFUpdateUser],alias.[OnWayNum],alias.[IsSynSuccess],alias.[Title],alias.[CombinationsValueName],alias.[OverseaProductId],alias.[UnderWayNum],alias.[UnderWayLockNum],alias.[PrepOwnerConstraint],alias.[PrepOwnerCategory],alias.[LabelOwner],alias.[Expiration],alias.[SkuCode],alias.[isDullLabel],alias.[AdjustmentOnWayNum],alias.[StorageType],alias.[PlatformOnWayNum],alias.[Last7DaysSalesOutboundQuantity],alias.[Last14DaysSalesOutboundQuantity],alias.[Last30DaysSalesOutboundQuantity]
                        FROM dbo.RB_WareHouse_Product (NOLOCK) alias
                            LEFT JOIN dbo.RB_WareHouse (NOLOCK) b
                                ON b.CustomerID = alias.CustomerID
                                   AND alias.WareHouseID = b.ID
                        WHERE alias.CustomerID = @CustomerID
                              AND b.WareHouseType = @WareHouseType
                              AND alias.GoodNum > 0
                              AND alias.UpdateTime < DATEADD(DAY, -5, GETDATE());
PARAMS:@CustomerID = 1 ,@WareHouseType = 118 ,
MESSAGE:在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 信号灯超时时间已到)
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 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)
   在 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)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtendV3.RB_WareHouse_ProductExtendV3.GetModelListByWareHouseType(Int32 customerId, Int32 wareHouseType)
   在 Biz.Irobotbox.ReStock.SellerPlatformStockService.SyncStock(CM_OrderSource_EbayAmazonAPIResult param, WareHouseStockInfo wareHouseStockParam)
   在 Biz.Irobotbox.ReStock.SellerPlatformStockService.HandleApiData(CM_OrderSource_EbayAmazonAPIResult param, List`1 apiData)
   在 Biz.Irobotbox.ReStock.SellerPlatformStockService.SyncOverseaStock(CM_OrderSource_EbayAmazonAPIResult param)
   在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()

[结果]

[期望]

排查问题，提升效率。