on 05-31-2012 5:14 PM
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
You are not passing correct input structure to Stored procedure,check your mapping output and compare number of argumnets against SP inputs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.