Procedure or function SPCD'SPCD************* has too many arguments specified

[Former Member]

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

[former_member182455 · Accepted solution]

Dear Raju,

it's look like data issue, please compare the lenth of the value and cross check with DB field lenth.

Regards

[former_member184720]

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]

[Former Member]

Hi Kiran, 

Can you please attached a screenshot of the mapping to the JDBC. Also upload the target payload? 

Regards, 

Jannus Botha

[former_member182455]

Dear Raju,

it’s look like SP issue, please check with DB Team.

Regards

srinivas

[iaki_vila]

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.