error when updating database table in Receiver JDBC

[former_member182412]

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" ?>

- <ns0:MT_XIToECD_Meter_TabUpdate xmlns:ns0="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

[prateek · Accepted solution]

If it is a stored procedure, the action should be EXECUTE and not UPDATE and the structure should be similar to this:

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

<table>realStoredProcedureeName</table>

<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

From help.sap

Regards,

Prateek

[former_member182412 · Accepted solution]

This is not stored procedure, i am updating table

[Former Member · Accepted solution]

take the sql statement loged in CC monitoring-- audit log and try it in SQL editor , it will give you exact cause.

[Former Member]

Hi Praveen,

Points to check :-

1. You are using Update so data in VENUS_ACCT_NO needs to be present.

2. VENUS_ACCT_NO forms a unique key.

3. The Data Type of SAP_DATE at database level is appropriate.....similar to varchar2 type.

3. Check if any constraints exists

To me it seems a straight forward DB issue ..Please send the table schema !!

Regards,

[prateek]

Are you sure? You must check your first line then:

I am doing Proxy to JDBC Scenario using storedprocedures

Anyways, for your case, EMU.VENUS_ACCT - does EMU represents the name of package?

Regards,

Prateek

[former_member182412]

EMU is Table schema