none
How to read property of Blank Xml in Biztalk Orchestration RRS feed

  • Question

  • Hi All...
    I  have developed application where i read data from SAP and then transform this message to store data in SQL table...

    Sometimes i won't get any data in SAP RFC so i get blank Xml,now this will create error message as blank Xml schema is not matched with the SQL Schema when i was transforming messages.

    My concern is what should i do so that these type of Blank Xml error i can able to handle...
    Either i will route these blank Xml messages to some folder ..or if messages are suspended then i can able to clear Suspend message queue ,..which i like to handle in Biztalk orchestration.

    Pls Advice...
    Sandeep


    Monday, March 16, 2009 6:32 AM

Answers

  • Hi,

    You could use failed message routing feature to pick up the blank xml messages and route them to an orchestration or send port.
    For more information on failed message routing see: http://msdn.microsoft.com/en-us/library/aa578516.aspx

    Another option might be to prevent empty messages from arriving into your receive port. But this must be configured/programmed in either the sending application (in your case SAP) or the adapter receiving the message from SAP.
     

    HTH,

    Randal van Splunteren
    http://biztalkmessages.vansplunteren.net

    Please mark answered if this answers your question.

    Monday, March 16, 2009 8:02 AM
    Moderator