cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver Error for Stored Procedure

Former Member
0 Kudos

Hi All,

My requirement is to Proxy to JDBC.

When i tried to execute I am getting the following error

"Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP.usp_UpdateMaterialReservationHeader' (structure 'Statement'): java.lang.IllegalArgumentException"

Pls guide me to solve the issue.

Thanks in Advance.

Vichu

Accepted Solutions (1)

Accepted Solutions (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

You are not passing correct input structure to Stored procedure,check your mapping output and compare number of argumnets against SP inputs.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Make sure the number of inputs in PI JDBC structure are same as that of SP (in DB).

If possible paste ur SP structure which u have created in PI.

Thanks

Amit Srivastava

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Your JDBC stored procedure receiver structure might not follow the way sap document recommends. Check whether you have right table name using action attribute, param and type values

Please refer the sap help document.

<Statement>  

<storedProcedureName action=” EXECUTE”>

    <table>realStoredProcedureeName</table>

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

</storedProcedureName > 

  </Statement>