日志抬头：15de36d3-6b87-4002-9139-ea763ecf1af4
业务单号：
记录时间：2026-01-14 17:33:35
日志内容：{"Code":"26011417333564","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"77f0a5d9-4bf7-408c-ae48-1292111ffa42\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：1bcb4579-a5dd-443e-9cfa-3cb7e566d99c
业务单号：
记录时间：2026-01-14 17:33:43
日志内容：{"Code":"260114173343143","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"712e3957-f053-442a-964e-cd2845c0cd47\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：c835eb7c-2df2-474d-bb2a-fba4ceb5c1ae
业务单号：
记录时间：2026-01-14 17:33:44
日志内容：{"Code":"260114173344412","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 185)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 185)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"4beea7f2-7e20-4476-b6cc-ab6e6891162a\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 185)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：b3db6acb-579e-4271-aa3a-510bbe71e8c3
业务单号：
记录时间：2026-01-14 17:33:45
日志内容：{"Code":"260114173345347","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 186)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 186)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"daa5913d-b5d9-4f9f-b58a-33a4aeac50e2\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 186)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：64d39a33-b291-45ac-80f1-1e2d4a325ba9
业务单号：
记录时间：2026-01-14 17:33:45
日志内容：{"Code":"260114173345601","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 109)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 109)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"b588fd10-a032-4c7d-9c31-074631672397\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 109)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：ce3d2a8e-13a6-48b2-803f-85027d2535c6
业务单号：
记录时间：2026-01-14 17:33:45
日志内容：{"Code":"260114173345721","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"77f0a5d9-4bf7-408c-ae48-1292111ffa42\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 68)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：44c6c551-1313-4b8a-84f5-8d4065512a7d
业务单号：
记录时间：2026-01-14 17:33:45
日志内容：{"Code":"260114173345815","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"712e3957-f053-442a-964e-cd2845c0cd47\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：52d3fc86-32d0-47ed-8634-098f6611387c
业务单号：
记录时间：2026-01-14 17:42:32
日志内容：{"Code":"260114174232828","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 192)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 192)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"7397ff4d-f82f-4c89-b53d-d1a577f0c18c\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 192)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：1f83cea9-797d-4b02-89c3-0199ee3bf6f9
业务单号：
记录时间：2026-01-14 17:42:37
日志内容：{"Code":"260114174237844","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 196)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 196)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"e6bdd8fc-2238-4597-a0d1-60b07f5e7965\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 196)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：02529e29-59a2-4e91-8cf8-d923e601c69a
业务单号：
记录时间：2026-01-14 17:42:41
日志内容：{"Code":"260114174241584","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 194)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 194)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"55a6ab5a-ee21-466c-a98a-9e4ed529d021\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 194)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：68595ca0-a2b5-426f-9ca9-af119c7b71f3
业务单号：
记录时间：2026-01-14 17:42:42
日志内容：{"Code":"260114174242688","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 198)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 198)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"66fa1bf2-4480-4835-8a14-3dc5741151ce\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 198)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：8d398de8-9ab5-4e79-a16d-c35fd5f01f4d
业务单号：
记录时间：2026-01-14 17:42:42
日志内容：{"Code":"260114174242892","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 199)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 199)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"c2554f24-f35f-4204-98d3-a447015fc555\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 199)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：04eee929-3536-4f63-b40b-f54f6c2ce7aa
业务单号：
记录时间：2026-01-14 17:42:43
日志内容：{"Code":"260114174243111","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 190)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 190)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"9791ef46-46fd-4ec4-a672-c10b40b8e1cd\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 190)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：98c395d0-2eee-45cc-9c29-2f2203b80ac0
业务单号：
记录时间：2026-01-14 17:51:22
日志内容：{"Code":"260114175122814","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"084e72c8-f93a-46d6-8c27-0428546ca9ce\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 184)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}