java.sql.SQLException: Io exception: Socket read timed out

[Former Member]

Hello,

I've a interface RFC - JDBC - RFC.

When this interface is executing, i have the follow error in RuntimeWorkbench::

'Unable to execute statement for table or stored procedure. 'TABLAERR' (Structure 'STATEMENT') due to java.sql.SQLException: Io exception: Socket read timed out'

In SXMB_MONI do not see any message, only

' <SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry> '

this error don't occurs always, when and why i don't know..

I searched for information about this error and nothing found

why it is happens?

thank very much

[Former Member · Accepted solution]

HI,

This is not a problem in ur mapping or configuration.

This is a problem with JDBC connection. This is a common error, that generally comes when the DB server is receiving and processing numerous records. Connection time out or socket read time out.

First try this:

In ur JDBC adapter go to Advanced Tab Page and check Transaction Isolation Level as Serializable.

If still problem persists then take help of basis guys and increase the timeout for the connection, same thing can be asked from DB team.

[agasthuri_doss]

Hey,

>this error don't occurs always, when and why i don't know..

I did not glance the above words, Mapping should be fine, As Rahul mentioned check the JDBC Connectivity

Cheers

Agasthuri

[agasthuri_doss]

Hey,

Check this link

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

and see whether you Message Mapping follows the above structure ( Target one )

• Pass valid data in Message Mapping test tab and check

Cheers

Agasthuri