日志抬头：4f1b8335-21ea-4cad-b971-3f4c52f006a7
业务单号：
记录时间：2026-03-11 09:48:41
日志内容：{"Code":"260311094841138","SqlText":" update b set b.ExpressCOM=a.ExpressCom,b.ExpressNO=a.ExpressNo, b.RefundType='1' from API_DRP_OrderRefund(nolock)  a left join Ord_Refund(nolock) b on a.code=b.code and a.oldcode=b.PId where    a.ExpressNo<>'' and a.ExpressNo<>b.ExpressNo  and  a.UpdateDateTime >DATEADD(DAY,-1,GETDATE()) and b.BillState<>'99' ","Message":"事务(进程 ID 246)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 246)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"3eb4044e-291c-413c-a267-0ec1d6fc2361\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 246)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"1205\",\"HelpLink.BaseHelpUrl\":\"http://go.microsoft.com/fwlink\",\"HelpLink.LinkId\":\"20476\"},\"InnerException\":null,\"HelpURL\":null,\"StackTraceString\":\"   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\\r\\n   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\\r\\n   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\\r\\n   在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\\r\\n   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\\r\\n   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.Execute(String sql, SqlTransaction sqlTran, CommandType cmdType, SqlParameter[] sqlParms)\",\"RemoteStackTraceString\":null,\"RemoteStackIndex\":0,\"ExceptionMethod\":\"8\\nOnError\\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\\nSystem.Data.SqlClient.SqlConnection\\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])\",\"HResult\":-2146232060,\"Source\":\".Net SqlClient Data Provider\",\"WatsonBuckets\":null}"}
日志抬头：9d6940c2-09b2-4ab7-a7bd-d4ca4df55bc4
业务单号：
记录时间：2026-03-11 15:15:36
日志内容：{"Code":"260311151536742","SqlText":" update b set b.ExpressCOM=a.ExpressCom,b.ExpressNO=a.ExpressNo, b.RefundType='1' from API_DRP_OrderRefund(nolock)  a left join Ord_Refund(nolock) b on a.code=b.code and a.oldcode=b.PId where    a.ExpressNo<>'' and a.ExpressNo<>b.ExpressNo  and  a.UpdateDateTime >DATEADD(DAY,-1,GETDATE()) and b.BillState<>'99' ","Message":"事务(进程 ID 241)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 241)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"e5f0d07c-02b0-45e1-a353-39e889bfbe87\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 241)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"1205\",\"HelpLink.BaseHelpUrl\":\"http://go.microsoft.com/fwlink\",\"HelpLink.LinkId\":\"20476\"},\"InnerException\":null,\"HelpURL\":null,\"StackTraceString\":\"   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\\r\\n   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\\r\\n   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\\r\\n   在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\\r\\n   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\\r\\n   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.Execute(String sql, SqlTransaction sqlTran, CommandType cmdType, SqlParameter[] sqlParms)\",\"RemoteStackTraceString\":null,\"RemoteStackIndex\":0,\"ExceptionMethod\":\"8\\nOnError\\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\\nSystem.Data.SqlClient.SqlConnection\\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])\",\"HResult\":-2146232060,\"Source\":\".Net SqlClient Data Provider\",\"WatsonBuckets\":null}"}
日志抬头：bedfdf73-89a8-4fbd-af48-cfd2e3d236cd
业务单号：
记录时间：2026-03-11 17:43:32
日志内容：{"Code":"260311174332284","SqlText":"  INSERT INTO Ord_OrderImport(\r\nSourceProcessCode,SourceCode,CurrentProcessCode,CurrentNodeCode,BillState,Code,Remark,WShop,CreateDateTime,PaymentDate,FromShop,Sales,BusinessDate,OldCode,SumQuantity,SumAmount,Recipients, Mobile, Province,City,County, Address,UserCode, IsError, Remark2,zdUserCode,UpdateDateTime,transaction_id,FromEcShop,OrderId,Platform,DisplayName,RealAmount,Money,Remark3,ShopGuideName,Receiver_IsJM,Receiver_name,Receiver_phone,Receiver_address,oaid,Town,OrderState,ExpressCOM,ExpressNO,CashCoupon,CashbackMoney,BalanceMoney,IncomeMoney,giftMoney,LatestDeliveryTime,TagAmount,TotalAmount,flag,receivedPayment,discountFee,postFee,serviceFee,authorId,authorName,preSellType,Days)\r\nvalues(@SourceProcessCode,@SourceCode,@CurrentProcessCode,@CurrentNodeCode,@BillState,@Code,@Remark,@WShop,@CreateDateTime,@PaymentDate,@FromShop,@Sales,@BusinessDate,@OldCode,@SumQuantity,@SumAmount\r\n,@Recipients,@Mobile,@Province,@City,@County,@Address,@UserCode\r\n,@IsError,@Remark2\r\n,@zdUserCode,@UpdateDateTime,@transaction_id,@FromEcShop,@OrderId,@Platform,@DisplayName,@RealAmount,@Money,@Remark3,@ShopGuideName,@Receiver_IsJM,@Receiver_name,@Receiver_phone,@Receiver_address,@oaid,@Town,@OrderState,@ExpressCOM,@ExpressNO,@CashCoupon,@CashbackMoney,@BalanceMoney,@IncomeMoney,@giftMoney,@LatestDeliveryTime,@TagAmount,@TotalAmount,@flag,@receivedPayment,@discountFee,@postFee,@serviceFee,@authorId,@authorName,@preSellType,@Days)sqlParms:@SourceProcessCode='P37',@SourceCode='DS0025P37260311276',@CurrentProcessCode='P37',@CurrentNodeCode='01',@BillState='0',@Code='DS0025P37260311276',@Remark='',@WShop='拼多多店',@CreateDateTime='2026/3/11 17:43:32',@PaymentDate='2026/3/11 17:42:46',@FromShop='DS0025',@Sales='DS0025',@BusinessDate='2026-03-11',@OldCode='260311-415802397010519',@SumQuantity='1.0',@SumAmount='49.0',@Recipients='',@Mobile='',@Province='江西省',@City='萍乡市',@County='安源区',@Address='江西省萍乡市安源区安源区',@UserCode='',@IsError='0',@Remark2='',@zdUserCode='API',@UpdateDateTime='2026/3/11 17:43:32',@transaction_id='',@FromEcShop='667144',@OrderId='',@Platform='PDD',@DisplayName='',@RealAmount='45.08',@Money='0',@Remark3='',@ShopGuideName='',@Receiver_IsJM='-1',@Receiver_name='',@Receiver_phone='',@Receiver_address='江西省萍乡市安源区安源区',@oaid='',@Town='安源区',@OrderState='210',@ExpressCOM='',@ExpressNO='',@BalanceMoney='0',@CashbackMoney='0',@CashCoupon='0',@IncomeMoney='0',@giftMoney='0',@LatestDeliveryTime='2026-03-13 17:42:46',@TotalAmount='49',@TagAmount='49.0',@flag='NONE',@receivedPayment='49.0',@discountFee='0.0',@postFee='0.0',@serviceFee='0.0',@authorId='',@authorName='',@preSellType='none',@Days='2'","Message":"不能在具有唯一索引“u_Index_Ord_OrderImport_Code”的对象“dbo.Ord_OrderImport”中插入重复键的行。重复键值为 (DS0025P37260311276)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“u_Index_Ord_OrderImport_Code”的对象“dbo.Ord_OrderImport”中插入重复键的行。重复键值为 (DS0025P37260311276)。\",\"Procedure\":\"\",\"LineNumber\":1},{\"Source\":\".Net SqlClient Data Provider\",\"Number\":3621,\"State\":0,\"Class\":0,\"Server\":\"172.18.63.40,4001\",\"Message\":\"语句已终止。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"3b4b4deb-30d3-4389-b2ed-2ff3b44acba2\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“u_Index_Ord_OrderImport_Code”的对象“dbo.Ord_OrderImport”中插入重复键的行。重复键值为 (DS0025P37260311276)。\\r\\n语句已终止。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"2601\",\"HelpLink.BaseHelpUrl\":\"http://go.microsoft.com/fwlink\",\"HelpLink.LinkId\":\"20476\"},\"InnerException\":null,\"HelpURL\":null,\"StackTraceString\":\"   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\\r\\n   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\\r\\n   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\\r\\n   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\\r\\n   在 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)\\r\\n   在 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)\\r\\n   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\\r\\n   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.Execute(String sql, SqlTransaction sqlTran, CommandType cmdType, SqlParameter[] sqlParms)\",\"RemoteStackTraceString\":null,\"RemoteStackIndex\":0,\"ExceptionMethod\":\"8\\nOnError\\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\\nSystem.Data.SqlClient.SqlConnection\\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])\",\"HResult\":-2146232060,\"Source\":\".Net SqlClient Data Provider\",\"WatsonBuckets\":null}"}