none
BizTalk DB2 adapter issue RRS feed

  • Question

  • Hi All,

    I have BizTalk application which connects to a AS400 Database. Last night I had an issue with it. I have multiple receive locations on my application each polling a different table. I had an Active Host issue and i had to restart all my host instances. While i was re-starting the host instances, the DB2 adapter kept polling the table. once BizTalk picks up the files, it changes the status on the table which tells me that these records were picked up. However during a transaction normally, if i restart the host instances, any transaction will be rolled back and whenever BizTalk gets back to the normal state, the records are picked. What happened to me was, the transaction was not rolled back and the status had changed to complete, but the records did not reach the destination and it failed. Can i know where the error lies here. is it in my stored proc that polls the table or is it the DB2 adapter which does not support ambient transactions.

    Thanks.

    Friday, January 7, 2011 3:36 PM