JDBC receiver adapter: No 'action' attribute found in XML document

[Jitendra_Jeswan]

Hi this is my target structure getting generated at the Receiver JDBC adapter

I have checked the XML doc, still unable to figure out why in the RWB its showing the following error:

"Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)"

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_IF001 xmlns:ns0="http://vodafone.com/xi/IF001">

<Statement>

<OPCO_VPC_PO action="UPDATE">

<access>

<SO>0060000090</SO>

<SO_ITEM>000010</SO_ITEM>

</access>

<key>

<OPCO_PO>0002002291</OPCO_PO>

<OPCO_PO_ITEM>00010</OPCO_PO_ITEM>

</key>

</OPCO_VPC_PO>

</Statement>

</ns0:MT_IF001>

Kindly Help !!

Thanks !!

[former_member189387]

Hi,

Clearly stating that no action attribute .So, please take a look at the structure please do like this at your Data Type specification

<i><b><b><root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

</root></b></b></i>

refer the following link

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

**Assign points if you found helpful

Regards.,

V.Rangarajan

[Former Member]

Hi

simply change your structure at the target side.

your XML has action , but the structure is wrong.

Thanks

sudhir sharma

[Former Member]

HI

your receiver structure should be like this always :

<statement>

<action/> --- defines what action u need to perform like ,,insert , delete etc,...

<access>

</access>

<key>

</key>

</statement>

Regards

Abhi

[Former Member]

Hi

Error clearly states action attribute is not there in the Receiver structure.

JDBC requires special structures like this

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Get back if you have doubts.

[Jitendra_Jeswan]

Hi i think in the structure i had pasted has action attribute!!

The Problem is Still i see the same error in the RWB.

I am mapping from Idoc Structure to this JDBC receiver Doc. I guess i cant paste you that mapping as it is not in the viwable format !!

Kindly help

[Former Member]

Hi

While you created the data type the action field is suppossed to be an attribute and not an element.Check again.Get back..

Thanks

[nisarkhan_n]

action field should be attribute...check this blog and make sure your DATA type is defined according to this

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

[former_member190313]

hi

i guess there is some problem with your mapping.

check your mapping...or send it to me

Regards

Sheetal