none
DB2 Adapter Insert Updategram RRS feed

  • Question

  •      How to resolve the BizTalk Transmission error "Invalid index 0 for this MsDb2ParameterCollection with Count=0." with DB2 Adapter? 

     I tried to insert a single row of data and it was success. I have few other applications which inserts batched data using DB2 adapter and they works fine. Both the messages look similar and adapter configurations are also one and the same.  Does this error require some configuration change at the end system (AS400)?

    Any suggestions please..

    Thanks & Regards,

    Sara.K

    Friday, December 3, 2010 1:25 AM

All replies

  • You have to loop at the "sync" level for inserts and you can't loop at all for an update from what I can tell (in BizTalk 2006 R2 anyway)...  Supposed to be fixed in HIS 2010.
    Thursday, February 10, 2011 2:14 AM