on 05-30-2008 8:43 AM
Hi Guys,
I am working with File to Jdbc scenario.at the file side the process is working fine.the file is picked up by the file adapter and send it XI.then XI sends the data to JDBC it shows an error in receiver side.the error is as follws
Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sap_alt_spec' (structure 'Statementname'): java.sql.SQLException: ORA-00928: missing SELECT keyword
so can any one tell me the solution to resolve the error?its urjent.
Hi,
Have you create Your JDBC Structure According to this Blog
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30
Also check the Keywords that used in the JDBC Structure at the time of Mapping( Like Action = INSERT or UPDATE or DELETE)
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have wrong message type for jdbc side or wrong mapping. reffer to the links above.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please refer:
for configuration of JDBC adpt-
http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm
for XML document formats(this is much imp.)-
http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm
Ranjit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.