the output map is half full and half empty

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › the output map is half full and half empty

Viewing 2 reply threads
  • Author
    Posts
    • July 21, 2010 at 10:12 AM #25322
      community-content

        I have a biztalk application in which I have the following:

        1- a WCF adapter which connects to SQL DB to get some data using stored procedure.

        2- another WCF adapter which connects to SQL DB to get some data using stored procedure which takes a single input to extract data from DB based on that input “which is taken from the first WCF adapter”.

        3- I created an orchestration in which I connect to the database to poll the data of input 1 then use this data to get input 2 “I did unit testing on both of the inputs and they were working correctly”. however, the problem is there is a mapping that I have to perform in which I take both input 1 & 2 and map them into a single schema. I created a multipart message which is composed of two messages the first and second inputs and I map the inputs into the source schema, I rebuilt the application and redeployed it, then I ran the application the problem is that the output xml file is empty from data, ironically the first part from input 1 contains data but the input2 is empty “just empty nodes”, I tried the option of ignore namespace and changed it to No, I tried refreshing and reconstructing the map but no use, can anyone please help me.

        ** the DB I am using is full of information “there are no any null fields in any record”

        Thanks,

      • July 21, 2010 at 7:24 PM #25330
        community-content

          You do not need to use a multipart message. This is just a message with a body part and 1 or more attachments. BizTalk functions such as maps and pipeline components only operate on the Body part of the message. It is possible to have a multipart message that has an Xml body part and a binary attachment, such as an image. These two parts are not joined together.

          To use a map that aggregates two messages, you add a Transform shape to your orchestration and add both of your input messages to the source and your output message to the destination. At runtime Biztalk aggregates your two Xml messages into a single Xml message that is passed to the transform.

          • July 22, 2010 at 12:26 AM #25335
            community-content

              I already did that, and this is what created the problem.

              I tried using a single source single destination schema but there seems to be a problem in the mapping because that schema doesn’t copy the values to the destination

          • November 19, 2020 at 3:14 AM #50451
            biztalkgurus

              Art Now – Burkhard Riemschneider – 9783822811603

          • Author
            Posts
          Viewing 2 reply threads
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.