SQL端口将空白xml发送到SQL端口Biztalk Server 2006时出错 [英] SQL port Error when sending blank xml to SQL port Biztalk Server 2006

问题描述

大家好。我已经开发了一个应用程序，我从SAP RFC获取数据并将其存储在SQL表中..因为此RFC表包含每日数据更新所以我运行批处理文件以每天执行此RFC ..
现在我有了senario，有时候RFC表可能不会包含任何内容，而且空白的xml将来自SAP作为repsonse。
这个xml我使用Request SQL进行映射，以便我调用pass this数据到SQL发布。
现在，如果我从SAP RFC Biztalk收到空白xml暂停消息，因为模式与请求SQL模式不匹配。
错误消息："无法向SQL发送消息因为身体部分是NULL ..

由于所有这些我可以在Biztalk组概述中看到暂停的消息和编排..现在可能导致Biztalk的性能降低..
那我该怎么办避免消息进入暂停阶段。

谢谢
Sandeep

Hi All..
I have developed an application where i fetch data from SAP RFC and i store it in SQL table.. as this RFC table contains updates of data daily so i run batch file to execute this RFC daily..
Now i have senario where sometimes it could be possible that RFC table doesen't contains anything and a blank xml will come from SAP as repsonse.
This xml i map with Request SQL so that i call pass this data to SQL post.
Now if i receive blank xml from SAP RFC Biztalk Suspend the messages,because the schema doesen't match with request SQL schema..
Error Message: "Failed to send message to SQL post as body part is NULL..

And due to all these i can see in Biztalk Group Overview suspended messages and orchestration..Now could lead to degarde the performance of Biztalk..
So what can i do to avoid messages going to suspended stage.

Thanks
Sandeep

推荐答案

Hey Sandeep，

Hey Sandeep,

我相信你有p几天后又出现了一个类似的问题，你决定添加一个决策块来检查来自SAP的传入消息是否包含任何数据。然后适当地处理数据。您是否遇到过这种方法的问题？

I believe you had posted a similar question few days back and you had decided to add a decision block to check whether the incoming message from SAP contains any data. And then handle the data appropriately. Were you having issues with this approach ?

这篇关于SQL端口将空白xml发送到SQL端口Biztalk Server 2006时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！