Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 06:18 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2009 at 03:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2009 at 06:40 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.