JDBC Receiver Communication channel Error

[Former Member]

Hi Friends,

I am facing below error in JDBC Receiver Communication chnnel.

Please shared your views.

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. 'KRSAPJOB' (structure 'Statements'): java.sql.SQLException: [SQL0204] KRSAPJOB in KRONOSMF type *FILE not found.

thanks

Mohit

[former_member184681 · Accepted solution]

Hi,

This is obviously an error in the Stored Procedure you are calling with the JDBC Adapter. Contact the party that is responsible for this particular system, as it is up to them to fix this.

Hope you'll find it useful,

Greg

[Former Member]

resolved

[Former Member]

Hi Mohit,

I received a smiliar error with the receiving JDBC Communication channel. Please talk with your database Admin regarding the stored procedure.

Either one of the fileds in the database is Mandatory and you are not sending that field valiue OR

the data type for one of the fields definied is not matching the one in the database and the stored procedure is failing and throwing an exception.

Teresa

[baskar_gopalakrishnan2]

With your error details, I dont see any issues with PI or communication channel configuration issue. First talk to DBA or whoever handles Stored Procedure to sort out this problem.

[Shabarish_Nair]

Looking at the error, it could be an issue with the SP itself and not PI but try to execute the SP independently of PI using the same input data and check to confirm.