on 01-23-2012 12:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.