Skip to Content
avatar image
Former Member

JDBC Receiver Communication channel Error

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Jan 23, 2012 at 01:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2012 at 02:10 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2012 at 02:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23, 2012 at 04:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2012 at 03:10 PM

    resolved

    Add comment
    10|10000 characters needed characters exceeded