AnsweredAssumed Answered

Unbounded element - Only the first record gets updated in the database

Question asked by aseals183968 on Oct 21, 2016
Latest reply on Oct 24, 2016 by aseals183968

I am having an issue calling my stored procedure with multiple elements in a file.  I have set unbounded on the element in the xml profile.  The data that is output from my map and is the command shape's source data looks like this: 

 

DBSTART|6f0e3447-ab11-4daa-87d9-b33ad8a28e83|2|@|BEGIN|5|@|OUT_START|6|@|43|^|4|^||^||^|1|#|43|^|5|^||^||^|1|#||#|OUT_END|6|@|END|5|@|DBEND|6f0e3447-ab11-4daa-87d9-b33ad8a28e83|2|@|

 

The numbers 43, 4, and 1 are from the first record, and 43, 4, and 5 are from the second record.  There are also some nulls in there which is expected.  However, only the first record gets updated in the database.

 

As a side note, I am using a command shape because a database connector did not work and BOOMI support asked me to try a command shape instead.  It then started working, but for only the first element.

 

Any ideas?

Thanks!

Outcomes