on 02-24-2014 7:03 AM
Hi Experts,
I am getting the below error in JDBC recever communication channel. Could you kindly provide the solution to resolve this.
Unable to execute statement for table or stored procedure. 'SPCD*************' (Structure 'StatementName') due to com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function SPCD'SPCD************* has too many arguments specified
JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'SPCD'SPCD*************' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function SPCD'SPCD************* has too many arguments specified.
Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SPCD'SPCD*************' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function SPCD'SPCD************* has too many arguments specified.
Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SPCD'SPCD*************' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function SPCD'SPCD************* has too many arguments specified
regards
raju
Dear Raju,
it's look like data issue, please compare the lenth of the value and cross check with DB field lenth.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raju - Based on the error message it's quite clear that you are supplying more parameters to the stored procedure.
Make sure that you have properly assigned the constants for the below parameters..
[isInput=”true”] [isOutput=true]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kiran,
Can you please attached a screenshot of the mapping to the JDBC. Also upload the target payload?
Regards,
Jannus Botha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Raju,
it’s look like SP issue, please check with DB Team.
Regards
srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Peddaraju,
Please share your XML to check the correctness. Also, you would need to compare the DB store procedure parameters with the parameters that you have passed.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.