BizTalk Mapper only returning first row to destination schema

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk Mapper only returning first row to destination schema

Viewing 1 reply thread
  • Author
    Posts
    • #26096

      I’ve been working with BizTalk for close to 7 years now but for the last few I was mainly on the administration side. Recently I got back into development and have an issue that has me stumped.

      I have a source XML schema with a Member record that is set with MinOccurs 0 and MaxOccurs unbounded. I have a destination flat file schema with a Detail Record set with Min 0 and Max unbounded.

      When I validate instance on each of the schemas with test files every record I expect comes through in the results.

      I have a map with a 1 to 1 mapping from Member to Detail with no functoids. I’ve tried everything I can think of (Mapping the Member Record Directly to Detail Record, no link between Member and Detail, Linking the two with a logical exists functoid, linking the two with a looping functoid). It doesn’t matter what I do only the first record from the source file gets mapped over to the destination file when I test the map in the IDE or run it through BizTalk in its deployed app. Below is a pic of the amp with no link from Member to Detail. The Header record in the destination schema is a Min 1 Max 1 occurrence and it has defaulted values directly from the schema. I have a feeling I’m missing something obvious (I’ve even tried deleting and re-creating the map) and any help would be appreciated.

       

    • #26097

      You need to put a looping functoid on the parent records

      • #26098

        That doesn't work, tried a table looping functoid as well. I'm kind of glad the looping functoids didn't work because that would have been a confusing solution since I've never needed to do that before in similar situations. I'm starting to think this is a mapper bug. I have no idea why it won't map the other records.

        I've done countless 1 to 1 mappings and never needed to use a looping functoid. Also, I just created a quick test in another project and was able to do a 1 to 1 mapping with 2 very similar schemas and every record came over with no functoids.

        Is this a mapper bug?

        • #26099

          Well, I deleted and re-made the source schema and now everything works with the straight 1 to 1 links. No functoids required. Not sure what the difference was or if it was just a bug but it's working now.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.