Receiver JDBC Adapter error.

[azeem_syed2]

Hi Guys ,

My scenario is IDOC to JDBC scenarion.

when i execute the IDOC i am getting the below error in Receiver message monitoring(JDBC Receiver)

"MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException:

Error processing request in sax parser: Error when executing statement for

table/stored proc. 'RN_MES_STO' (structure 'STATEMENTNAME'):

java.sql.SQLException: ORA-00942: table or view does not exist : Error

processing request in sax parser: Error when executing statement for

table/stored proc. 'RN_MES_STO' (structure 'STATEMENTNAME'):

java.sql.SQLException: ORA-00942: table or view does not exist "

can you please help on the above issue.How to solve this one..

Regards ,

Azeem.

[baskar_gopalakrishnan2]

Are you using statement or stored procedure?  When you design receiver data structure for jdbc, you need to follow the recommended structure format.

Please refer these links....

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/07/jdbc-receiver-scenarios-best-prac...

Also make sure  your user credentials have access/credentials to use database instance schema. Talk to DBA