日志抬头：f3942089-e702-4f58-816a-ef8d695f1505
业务单号：
记录时间：2026-03-04 12:55:35
日志内容：{"Code":"26030412553516","SqlText":"insert into Ord_Refund(Code,CurrentProcessCode,CurrentNodeCode,SourceProcessCode,SourceCode,LastProcessCode,LastCode,LastNodeCode,BillState,Remark,zdUserCode,FromShop,SumQuantity,SumAmount,Vip,ToShop,RealAmount,RefundType,ExpressCOM,ExpressNO,Remark2,afterSaleType,Recipients,Mobile,Address,Oldcode,Initiator,SerialNum,transaction_id,Pid,FromCustomer,FromChannel,ToCustomer,ToChannel) values ('DS0001P05260304025','P05','P35','P35','DS0001P35260228006','D11','DS0001P35260228006','02','0','','API','DS0001','1','75.6000000000000','','DSTH02','75.6000000000000','1','','','','2','','','广东省东莞市寮步镇','5087847134046312938','4','','','378342469510313829','','000','','000')delete Ord_Refund_dtl2 where code='DS0001P05260304025'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0001P05260304025','DS0001P35260228006','DS0001P35260228006','YA25211L008','YA25211L008750125','1','19.00','75.60','75.6000000000000','611d15e2-79ab-43dc-b512-42439cb40417','75.60','75.6000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','8F28C95A-A452-4904-AF70-88859B0FF721')delete Ord_Refund_dtl where code='DS0001P05260304025'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0001P05260304025','DS0001P35260228006','DS0001P35260228006','YA25211L008','YA25211L008750125','1','19.00','75.60','75.6000000000000','75.60','75.6000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (378342469510313829)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (378342469510313829)。\",\"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\":\"42a8a74d-4912-48c3-b65e-17146a8d7bd2\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (378342469510313829)。\\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.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}"}
日志抬头：31844a25-4035-49a5-90e1-bf3bcb3b05bc
业务单号：
记录时间：2026-03-04 16:35:10
日志内容：{"Code":"260304163510041","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 237)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 237)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"fa330ed3-655c-4cb3-95c5-322c8ce735d9\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 237)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：e82b56d4-4b6d-4358-b380-c8f86abf589d
业务单号：
记录时间：2026-03-04 17:35:52
日志内容：{"Code":"260304173552132","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 249)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 249)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"57461df9-dd2a-441b-8d36-7b9ee8dbf061\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 249)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：13c7a1fe-5958-4982-923e-47549be962ab
业务单号：
记录时间：2026-03-04 17:35:54
日志内容：{"Code":"260304173554651","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 210)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 210)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"ed475da9-588d-4899-b211-054fd7ac4cb4\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 210)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}