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.