Error processing request in sax parser...............

[Former Member]

Hi all,

While executing proxy to JDBC scenario,only few messages in SXMB_moni are showing error as below.

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'mySQL' (structure 'StatementName1'): com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.transmit operation. Exception:Broken pipe. Context:(3) [XI2JDBC[:BS_OSA:CC_Receiver_INTERFACE_DB]_69608, IO:216c6.

This interface will run every 30 mins ,only 2 messages are seen in error.

Any inputs...

Thanks,

Srinivasa

[former_member183906 · Accepted solution]

This error occurs when the receiver side structure is incorrect.

Your structure seems to be correct.

Please use lower case for action, access and table.

Please check whether the field names are exactly the same as in the actual Database table sadmt1.SPE106TST.

Check if the table has permissions to write.

[Former Member]

HI,

Check whether the structure of database is same . Also check whether the connection to jdbc is proper

Regards,

Sona.

[Former Member]

Hi,

Check with the Table name that you have provided in the Receiver JDBC Structure & Action field value that u have provided

and also Field names are case sensetive, reffer the database field names and table names as it is

Regards

Seshagiri