Skip to Content
0

JDBC error following parameters must be specified. "@body, @query, @file_attachments, @subject"..

Feb 09, 2017 at 06:00 AM

56

avatar image

Hi All,

I am facing a problem in IDOC to JDBC scenario. While inserting records to SQL server, the below error message is coming in PI:

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'usp_OrdersRealTimePush' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]At least one of the following parameters must be specified. "@body, @query, @file_attachments, @subject"..

when I checked with database team, they are saying that they dont see any of these parameters in the stored procedure usp_OrdersRealTimePush.

Could any one help me on this issue?

Regards,

Pushpa

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers