Execution timeout expired - JDBC message processing failed

[NataliaGlants]

Hi all ,

We have SAP as Sender and SQL Server as Reciever in syncronious scenario.

We try to insert 17000 line into table Cust and recieve an error:

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'Cust' (structure 'statement1'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Execution timeout expired

If there any setting where we have to define to prolong Exevution timeout?

Thanks, Natalia.

[Former Member · Accepted solution]

Hi Natalia,

Even though it seems a time out issue, but for me It seems that you have created a wrong JDBC structure.

Check out the below link for the correct format for JDBC receiver.

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards,

Sarvesh

[NataliaGlants]

Hi,

"Advance Mode" is enabled and the values are:

sqlquerytimeout = 600000

driver:oracle.jdbc.ReadTimeout = 600000

driver:oracle.net.CONNECT_TIMEOUT = 600000

Trigger with Procedure execution exists in SQL Server.

Thanks, Natalia

[Former Member]

To configure a timeout for the JDBC receiver channels, please enable the "Advanced Mode" for the respective JDBC communication channel in the Integration Directory and add an entry "poolWaitingTime" and set to a time in Milli Secs to the "Additional Parameters" section.

The default value of this parameter is 5000 Milli Secs.