Skip to Content
0
Former Member
Jun 21, 2007 at 07:00 PM

XI - java.sql.SQLException

97 Views

We are working on XI (PI 7.0 actually) with Oracle 10.2 database. Windows 2003.

When we try to send data from XI to another database SCDB, we get the following error:

<i>Error while inserting the SCDB CM transaction data into the staging table. SCDB # 00140962000. This record can not be processed.</i>

The next thing we did was to go into XI to determine the message error. The error showed a JDBC connection failure when doing an insert to the SCDB staging table.

XI Message Text when JDBC error occurs:

<i>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SCDB.OLAC_CM' (structure 'Insert'):

<b>java.sql.SQLException: No more data to read from socket</b></i>

ANY IDEAS ??

Cheers

Kunal.