cancel
Showing results for 
Search instead for 
Did you mean: 

Error With JDBC receiver adapter

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member192343
Active Contributor
0 Kudos

you have wrong message type for jdbc side or wrong mapping. reffer to the links above.

ranjit_deshmukh
Active Participant
0 Kudos