Skip to Content
0
Jul 31, 2009 at 07:22 AM

error when updating database table in Receiver JDBC

36 Views

Hi

I am doing Proxy to JDBC Scenario using storedprocedures

While executing the scenario i am getting the following error in communication channel monitoring.

MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMU.VENUS_ACCT' (structure 'Statement'): com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: COJXI;INSERT;EMU.VENUS_ACCT

My Payload is like that

<?xml version="1.0" encoding="UTF-8" ?>

- http://www.CoJ.co.za/IsutoECD/Updatedata">

- <Statement>

- <VENUS_ACCT ACTION="UPDATE">

<TABLE>EMU.VENUS_ACCT</TABLE>

- <ACCESS>

<SAP_DATE>2009-07-30</SAP_DATE>

</ACCESS>

- <KEY>

<VENUS_ACCT_NO>000000120</VENUS_ACCT_NO>

</KEY>

</VENUS_ACCT>

</Statement>

</ns0:MT_XIToECD_Meter_TabUpdate>

Can anybody give solution

Regards

Praveen