Error while sending bulk data

[Former Member]

Hi,

I am doing one scenario in which SAP sends Material Number to Oracle and in turn Oracle fetches data for that Material Number and send it back to SAP.

Here when I am executing the scenatio in SAP with Material Number as 1* . I am getting an error in XI as "Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. java.sql.SQLException: No more data to read from socket"

I am getting this error while sending data from SAP to oracle.i tried the same scenario with 2 or 3 records.It is working fine.

I tried many options increasing the polling interval and restricting the records.But I am getting the same error.Please help me in this case.

Thanks,

Gunasree.

[Former Member]

Hi Gunasree,

Please see these links:

http://www.websina.com/bugzero/errors/oracle-SQLException.html

http://forum.springframework.org/showthread.php?t=19810

/message/2179977#2179977 [original link is broken]

No more data to read from socket

Your database connection has timed out, either due to network problems or due to Oracle reaching the IDLE_TIME profile limit.

Your application however tried to use the connection, but as the connection has closed, failed to do so.

This error mostly happens when using connection pools. Normally, when a connection is timed out or gone, the application should automatically reconnect.

Hope these links will help you.

BR,

Alok

[Former Member]

Hi Alok,

Thank you for the reply.

This interface is working for small number of records.When we are posting bulk data I am getting this error.So can u please give the solution for this time out.Even if we restart the oracle server and when i post the bulk data I may get the same error.

Please help me in this case.

Thanks,

Gunasree

[Former Member]

Most of the debugging links say: Connection with database server is lost, and Use a new connection to come out this problem with code so that if again the session goes expired the connection automatically get establised.

Have a look:

Troubleshooting: No more data.....

1.http://www.chemaxon.com/forum/ftopic904.html

2.http://elandingstest.alaska.gov/confluence/display/IERS/TroubleshootingDatabaseConnection+Problems

3. http://www.orafaq.com/forum/t/35084/0/

4.

5. http://www.junlu.com/msg/314591.html

BR,

Alok

[Former Member]

hi

please refers tothe link. hope it will help u.

rewards point if helpful

regards

Kasturika