日志抬头：763d160c-c34f-4f37-84c0-10a2c8a96bec
业务单号：
记录时间：2026-04-15 00:16:11
日志内容：{"Code":"260415001611977","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 226)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 226)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"41973bbb-d74b-4b2b-bb66-7cd34dc4a6dd\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 226)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：2a7e6eed-2e9e-410d-ae93-ece45f363d3e
业务单号：
记录时间：2026-04-15 05:30:34
日志内容：{"Code":"260415053034832","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 ('DS0025P05260415019','P05','P37','P37','DS0025P37260412072','D11','DS0025P37260412072','02','0','','API','DS0025','1','39.0000000000000','','DSTH02','39.0000000000000','1','','','','2','','','广东省广州市白云区白云区','260412-429968658822553','4','','','20047163020563','','000','','000')delete Ord_Refund_dtl2 where code='DS0025P05260415019'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0025P05260415019','DS0025P37260412072','DS0025P37260412072','YA25219Z004','YA25219Z004750125','1','11.50','39.00','39.0000000000000','071e06d6-fe0d-47e6-b158-d542089d3f95','39.00','39.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','8687C692-8BCD-479D-977A-75ECC7E4198B')delete Ord_Refund_dtl where code='DS0025P05260415019'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0025P05260415019','DS0025P37260412072','DS0025P37260412072','YA25219Z004','YA25219Z004750125','1','11.50','39.00','39.0000000000000','39.00','39.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (20047163020563)。\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”中插入重复键的行。重复键值为 (20047163020563)。\",\"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\":\"3e7d98fe-032b-4313-a809-2620457a37d9\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (20047163020563)。\\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}"}
日志抬头：271db747-53f0-4982-89c4-7f5981d5306e
业务单号：
记录时间：2026-04-15 13:24:30
日志内容：{"Code":"260415132430692","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='P35',@SourceCode='DS0001P35260415038',@CurrentProcessCode='P35',@CurrentNodeCode='01',@BillState='0',@Code='DS0001P35260415038',@Remark='',@WShop='淘宝-爱客女装旗舰店',@CreateDateTime='2026/4/15 13:24:30',@PaymentDate='2026/4/15 13:24:01',@FromShop='DS0001',@Sales='DS0001',@BusinessDate='2026-04-15',@OldCode='4502297737003007604',@SumQuantity='1.0',@SumAmount='85.9',@Recipients='',@Mobile='',@Province='海南省',@City='万宁市',@County='万宁市',@Address='海南省万宁市万宁市南桥镇',@UserCode='',@IsError='0',@Remark2='',@zdUserCode='API',@UpdateDateTime='2026/4/15 13:24:30',@transaction_id='',@FromEcShop='667328',@OrderId='',@Platform='TB',@DisplayName='t**',@RealAmount='85.9',@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-04-17 13:24:01',@TotalAmount='85.9',@TagAmount='659.0',@flag='NONE',@receivedPayment='0.0',@discountFee='573.1',@postFee='0.0',@serviceFee='0.0',@authorId='',@authorName='',@preSellType='none',@Days='2'","Message":"不能在具有唯一索引“u_Index_Ord_OrderImport_Code”的对象“dbo.Ord_OrderImport”中插入重复键的行。重复键值为 (DS0001P35260415038)。\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”中插入重复键的行。重复键值为 (DS0001P35260415038)。\",\"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\":\"d0affaf6-e725-428e-a90d-8dbf81239f51\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“u_Index_Ord_OrderImport_Code”的对象“dbo.Ord_OrderImport”中插入重复键的行。重复键值为 (DS0001P35260415038)。\\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}"}
日志抬头：689c1dba-5071-4cf5-84f6-afb46121e1db
业务单号：
记录时间：2026-04-15 19:05:26
日志内容：{"Code":"26041519052686","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 ('DS0094P05260415072','P05','P36','P36','DS0094P36260415052','D11','DS0094P36260415052','P36','0','','API','DS0094','1','79.0000000000000','','','79.0000000000000','0','','','','2','','','浙江省温州市南塘镇乐清市','6952094118063904159','4','','','147444024843157264','','000','','')delete Ord_Refund_dtl2 where code='DS0094P05260415072'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0094P05260415072','DS0094P36260415052','DS0094P36260415052','YA25224L014','YA25224L014700135','1','12.00','79.00','79.0000000000000','b178b7d8-b983-444d-ba76-195a8e182bd3','79.00','79.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','C1AC9183-7865-4FB8-AFF7-2D571F3C8387')delete Ord_Refund_dtl where code='DS0094P05260415072'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0094P05260415072','DS0094P36260415052','DS0094P36260415052','YA25224L014','YA25224L014700135','1','12.00','79.00','79.0000000000000','79.00','79.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260415072)。\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_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260415072)。\",\"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\":\"23c35f18-a21f-43f1-ba6b-5165644d0c32\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260415072)。\\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}"}
日志抬头：ba944554-48b3-4b59-b706-558e89e37d27
业务单号：
记录时间：2026-04-15 19:55:21
日志内容：{"Code":"26041519552193","SqlText":"select distinct a.Platform,a.FromShop from Net_Set_Stock(nolock)  a left join Net_Set_Stock_dtl(nolock) b on a.code=b.code   where b.barcode in ()","Message":"“)”附近有语法错误。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":102,\"State\":1,\"Class\":15,\"Server\":\"172.18.63.40,4001\",\"Message\":\"“)”附近有语法错误。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"27b6b792-81fb-4e05-b3db-f834c0958522\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"“)”附近有语法错误。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"102\",\"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.SqlDataReader.TryConsumeMetaData()\\r\\n   在 System.Data.SqlClient.SqlDataReader.get_MetaData()\\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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\\r\\n   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\\r\\n   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.QuaryDataSet(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}"}
日志抬头：f826540b-c809-4731-bcc6-a70df8ba532f
业务单号：
记录时间：2026-04-15 20:24:40
日志内容：{"Code":"260415202440451","SqlText":"select   c.guid \r\nfrom Ord_Order_dtl c \r\nleft join Ord_OrderImport_dtl dtl on dtl.code='DS0001P35260412017' and dtl.barcode=c.barcode and dtl.pid=c.pid \r\nwhere c.code='DS0001P35260412017'  and dtl.BarCode_API='5936031782128'   \r\nand c.guid not in (select b.guid from  Ord_Refund a left join Ord_Refund_dtl2 b on a.code=b.code where a.BillState!='95'  and a.SourceCode='DS0001P35260412017') ","Message":"事务(进程 ID 113)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 113)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"a0268b4c-3ca9-40d4-b665-1e1362203ecb\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 113)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)\\r\\n   在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)\\r\\n   在 System.Data.SqlClient.SqlDataReader.Read()\\r\\n   在 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)\\r\\n   在 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)\\r\\n   在 System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)\\r\\n   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.QuaryDataSet(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}"}