AS2接收位置运行时存储过程失败 [英] Stored Procedure Failure when AS2 receive location runs

问题描述

这是一个没有编排的生产服务器。这两个错误代表了当AS2接收位置（AS2Receive管道）接收流量时我们得到的结果。时间，7：51：08和8:11:10，跟随交易的接收，例如，在7:46:07 - 7:51:05和8:11:06 - 8之间收到的交易块： 11:08。

事件类型：错误
事件源：BizTalk Server 2006
事件类别：BizTalk Server 2006
事件ID：6912年：2008年3月17日
时间：7：51：08 PM
用户：N / A
计算机：DEVISER
说明：
以下存储过程调用失败：" {call [dbo]。[bts_UpdateMsgbox_BizTalkServerApplication]（？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？， ？）}" ;. SQL Server返回错误字符串："事务（进程ID 156）在锁资源上与另一个进程死锁，并被选为死锁牺牲品。重新运行该事务.;忽略重复键。"。

事件类型：错误
事件源：BizTalk Server 2006
事件类别：BizTalk Server 2006
事件ID：6912年代日期：2008/3/17
时间：8：11：10 PM
用户：N / A < br>计算机：DEVISER
说明：
以下存储过程调用失败：" {call [dbo]。[bts_UpdateMsgbox_BizTalkServerApplication]（？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？，？， ？）}" ;. SQL Server返回错误字符串："事务（进程ID 154）在锁资源上与另一个进程死锁，并被选为死锁牺牲品。重新运行事务。;重复键被忽略。;重复键被忽略.;重复键被忽略.;重复键被忽略。"。

有人会为我理解发生的事情提供了一条路径？

谢谢，

解决方案

您好，

最初，它看起来像BTS而不是AS2的性能问题，但是，我需要更多信息才能跟踪它。

当您在服务器上收到消息时是否有此错误当它处于负载状态时？

您是否启用了AS2状态报告？您是否为传入的AS2流量启用了BisTalk跟踪？

BR，

< p align = left> Yury

 

This is a production server with NO orchestrations.  The two errors are representative of what we are getting when the AS2 receive location (AS2Receive pipeline) receives traffic.  The times, 7:51:08 and 8:11:10, follow the receive of transactions, e.g., a block of transactions were received between 7:46:07 - 7:51:05 and 8:11:06 - 8:11:08.

 

Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 6912
Date:  3/17/2008
Time:  7:51:08 PM
User:  N/A
Computer: DEVISER
Description:
The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.;Duplicate key was ignored.".

 

Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 6912
Date:  3/17/2008
Time:  8:11:10 PM
User:  N/A
Computer: DEVISER
Description:
The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Transaction (Process ID 154) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.;Duplicate key was ignored.;Duplicate key was ignored.;Duplicate key was ignored.;Duplicate key was ignored.".

Would someone suggest a path for me to follow in understanding what is happening?

 

Thanks,

 

解决方案

Hello,

Initially, it looks like performance issue with BTS rather than with AS2, however, I need more information to be able to trace it.

Do you have this error when you receive message on a server when it's under load?

Do you have AS2 status reporting enabled? Do you have BisTalk tracking enabled for incoming AS2 traffic?

 

BR,

Yury

这篇关于AS2接收位置运行时存储过程失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！