Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk Mapper only returning first row to destination schema
- This topic has 3 replies, 1 voice, and was last updated 8 years, 4 months ago by
community-content.
-
AuthorPosts
-
-
July 12, 2013 at 9:05 AM #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.
-
July 12, 2013 at 2:10 PM #26097
You need to put a looping functoid on the parent records
-
July 16, 2013 at 7:34 AM #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?
-
July 16, 2013 at 7:50 AM #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.
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.