proxy to jdbc insert error

[Former Member]

Hi Everyone,

I am working on proxy to jdbc interface.When i am trying to insert data into table getting following error.

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. 't_PDIDetails_Linked' (structure 'Statement'):
java.sql.SQLException: FATAL ERROR document format in structure 'Statement':
expected 'access' tag(s) not found.

I have already inserted successfully into another tables.I followed the same structure.

I couldn't find what could be the issue.Please suggest me.

Thanks in advance points will be rewarded.

Thanks

Kumar

[Former Member]

May the hierarchy of the access tag is wrong too.. meaning it may be getting created at the wrong place ; Like as a sub-node of table .

[sahana_ps]

check your message mapping...test in your message mapping whether access tag is getting created...

Paste your receiver structure here

[rajasekhar_reddy14]

Take payload from communication channel monitoring and paste it here.

if you want to suppress any records based on some conditions then you must right a condition in RD/ID is right idea, because access tag is mandatory in JDBC receiver structure to insert record in to DB else you may get this kind of erros.

[Former Member]

Hi,

Take the source payload and test your mapping i doubt that it is failing becoz the access tag is not getting created at the mapping which eventually results into failure at AE level..

Thanks

Amit Srivastava

[former_member184681]

Hi,

Have a look at answers by Raja Sekhar Reddy and Prabhat Sharma in this thread:

http://scn.sap.com/thread/1862561

They solve an identical problem there.

Hope this helps,

Greg

[baskar_gopalakrishnan2]

Please check your structure on the target side. You need access tags for this. You did not provide one.

Example:

<StatementName>

<TableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</TableName>

  </StatementName>

I might also want you to check the structure provided in the help link

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

If you are not comfortable find the structure error, Please provide us target structure here. we will find it out.