BizTalk cannot insert record in DB2 Table

Hi,

I am working with “BizTalk 2009 Adapters for Host System 2.0” and trying to insert a record in a db2 table which is on a AS400 System i series Os.

I get the following error when the DB2 Send Port tries to insert the record in the table.

Event Type: Warning
Event Source: BizTalk Server 2009
Event Category: (1)
Event ID: 5743
Date: 2009-10-15
Time: 11:41:55
User: N/A
Computer: xxxxxxxx

Description:
The adapter failed to transmit message going to send port “Snd_Port1” with URL “DB2://xx.xx.xx.xx:446/Temp/Temp1″. It will be retransmitted after the retry interval specified for this Send Port. Details:” in Ø”.

—————————–

FYI, BizTalk can read the table succesfully if I configure the recieve DB2 adapter with Select query on it.

So I feel its nothing with connection string.

Connection String is as follows:

User ID=biztalk;Password=***************;Initial Catalog=Temp;Network Transport Library=TCP;Host CCSID=37;PC Code Page=1252;Network Address=xx.xx.xx.xx;Network Port=446;Package Collection=Temp1;Default Schema=Temp1;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/AS400;Defer Prepare=False;Rowset Cache Size=0;Authentication=Server;Persist Security Info=True;Connection Pooling=False;Derive Parameters=False;

Any help would be appreciated.