SQL适配器调用存储过程-vs-函数 [英] SQL Adapter Invoking a Stored Procedure -vs- Function

问题描述

您好，

我正在尝试从Biztalk 2010调用SQL Server数据库中定义的标量函数。 我按照MSDN上的说明进行了操作，标题为"使用WCF服务模型调用SQL Server中的标量函数"。对于Biztalk 2010. 

在我的业务流程中，在进行函数调用时，我收到以下错误：

适配器未能发送消息去发送端口"<发送端口名称>"使用网址"< url>"。它将在为此发送端口指定的重试间隔后重新传输。详细说明：" HRESULT = QUOT; 0x80040e14" Description ="找不到存储过程
'< parm 1 of function>'。"

Biztalk正在尝试调用名为第一个参数的存储过程我的标量函数。 我在两个函数上尝试了这个，在两种情况下都会发生同样的事情。我已经审核了标题为" 调用
a SQL Server功能与存储 程序？ "  ;这似乎是同样的问题，但是我不明白开发人员为解决问题做了什么。 有人可以详细说明解决方案吗？                              

谢谢

解决方案

请注意以下注意事项文章"使用BizTalk Server在SQL Server中调用标量函数"：

  注意
使用Consume Adapter Service生成架构BizTalk Project Add-in还会创建一个绑定文件，其中包含有关端口的信息以及要为这些端口设置的操作。您可以从BizTalk Server Administration
控制台导入此绑定文件，以创建发送端口（用于出站呼叫）或接收端口（用于入站呼叫）。有关详细信息，请参阅

使用端口绑定文件配置物理端口绑定。

所以这个
中提到的解决方案< a href ="../../ biztalkgeneral / thread / 4372443c-fb61-44a0-8beb-465bc723e8f2"rel ="nofollow">
线程说导入此绑定文件修复了问题。

Hello,

I am trying to call a scalar function defined in a SQL Server database from Biztalk 2010.  I have followed the instructions located on MSDN entitled "Invoking Scalar Functions in SQL Server by Using the WCF Service Model" for Biztalk 2010. 

In my orchestration, when making the function call, I receive the following error:

The adapter failed to transmit message going to send port "<send port name>" with URL "<url>". It will be retransmitted after the retry interval specified for this Send Port. Details:"HRESULT="0x80040e14" Description="Could not find stored procedure '<parm 1 of function>'."

Biztalk is attempting to call a stored procedure named as the first parameter to my scalar function.  I have tried this on two functions and the same thing happens in both cases. I have reviewed the post entitled "Invoking a SQL server Function versus Stored Procedure?"  This seems like the same issue, however I don't understand what the developer did to fix the issue. Can someone elaborate on the solution?                             

Thanks

解决方案

Pay attention to the following note in the article "Invoking Scalar Functions in SQL Server by Using BizTalk Server":

 Note Generating the schema using the Consume Adapter Service BizTalk Project Add-in also creates a binding file that contains information about the ports and the actions to be set for those ports. You can import this binding file from the BizTalk Server Administration console to create send ports (for outbound calls) or receive ports (for inbound calls). For more information, see Configuring a Physical Port Binding Using a Port Binding File.

So the solution mentioned in this thread say that importing this binding file fixed the problem.

这篇关于SQL适配器调用存储过程-vs-函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！