MII - Cycle to add XML does not process all the items

[Former Member]

I am working on fixing an MII Transaction that is not processing all the records coming in from a database query. There is a For Loop that goes through all the records and is supposed to add items to a local XML variable definition. Even though the query is returning 20+ rows, the resulting XML data only has a couple of items. I am building a totally new transaction to test this and I see very similar results. This is the test transaction's sequence:

- Main XML definition:

<?xml version="1.0" encoding="UTF-8"?><OPTIONS> <item> <TEXT>BASE ITEM</TEXT> </item> </OPTIONS>

- Main XML Item definition:

<?xml version="1.0" encoding="UTF-8"?><item> <TEXT>FIRST ITEM</TEXT> </item>

- For Next Loop from 0 to 20, step 1.

- Assignment action 0: Local.ItemXML{/item/TEXT} = For_Next_Loop_0.CurrentItem (this will be replaced in the end with actual data; this is for demonstration purposes)

- Assignment action 1: Local.OptionsXML{/OPTIONS} = Local.ItemXML{/item} with the "Append XML" link type.

When I run the transaction in Debug mode, the following is the end result XML, even though it looped all 21 times:

<?xml version="1.0" encoding="UTF-8"?><OPTIONS> <item> <TEXT>BASE ITEM</TEXT> </item> <item> <TEXT>0</TEXT> </item> <item> <TEXT>1</TEXT> </item> <item> <TEXT>2</TEXT> </item> <item> <TEXT>3</TEXT> </item> </OPTIONS>

I did this using a Repeater with similar results.

Any ideas?

I am using MII Version 15.0 SP4 Patch 12.

Thanks.