Ask a question

Search Forums:

• Search BizTalk Server Adapters and Adapter Pack Forum
• Search All BizTalk Server Forums
• Search All Microsoft TechNet Forums

 

BizTalk cannot insert record in DB2 Table

• Thursday, October 15, 2009 9:55 AMNISHIL

   
  

  0

  Sign In to Vote

  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.

  ---

  Regards, NISHIL Http://BiztalkForums.com

  • Changed TypeBen Cline1MVP, ModeratorMonday, October 19, 2009 4:06 PMAsks a question
  •  
  • Reply
  • Quote