由于空白Xml Biztalk业务流程导致的SQL端口错误 [英] SQL Port Error due to Blank Xml Biztalk Orchestration

问题描述

HI All ..

HI All..

我对Biztalk Orchestration有疑问...我开发了Biztalk解决方案，其中我调用SAP RFC来获取数据和数据我需要在SQL表中插入..如果在RFC表中没有数据，那么空白xml将激活SQL存储过程...现在如果空白xml将到SQL端口，请求xml将以挂起模式进入存储程序期望参数@ a，@ b

I have query regarding Biztalk Orchestration ...i have developed Biztalk solution in which i invoke SAP RFC to get data and that data i need to insert in SQL table..if suppose in RFC table there is no data then blank xml will go to fire SQL stored procedure...now if blank xml will to SQL port, the request xml will go in suspend mode as Stored Procedure expects parament @a,@b

我得到的错误是：

执行响应（接收）管道失败："Microsoft.BizTalk.DefaultPipelines.XMLReceive，Microsoft.BizTalk.DefaultPipelines，Version = 3.0.1.0，Culture = neutral，PublicKeyToken = 31bf3856ad364e35" ;资料来源："XML反汇编程序"发送端口："SendPort_SQL_Hiring_PersonToPos" URI："SQL：// XYZ / DB01 /"原因：正文部分为NULL。

There was a failure executing the response(receive) pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "XML disassembler" Send Port: "SendPort_SQL_Hiring_PersonToPos" URI: "SQL://XYZ/DB01/" Reason: The body part is NULL.

请给我解决方案......这个Biztalk解决方案正在进入生产服务器

Pls provide me with the solution...as this Biztalk Solution is getting into production server

谢谢

Sandeep

推荐答案

您可以从输入的XML中创建一条新消息（ ，其中包含所需节点的空数据使用ConstructMessage和MessageAssignment Shapes填充 ）。在此之前，您需要提升您要设置的属性。

You can create a new message out of the input XML that you get (with empty data for the nodes what want to be populated) using a ConstructMessage and MessageAssignment Shapes. Before doing this, you need to promote the properties that you want to set.

这篇关于由于空白Xml Biztalk业务流程导致的SQL端口错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！