JDBC Reaciver

[Former Member]

Hi Guys,

I have a problem when i am passing a message from Idoc to Oracle useig JDBC Reaciver i had problem in Runtime..

Below message is my Error message..

channel Jdbc_Rec: processing started; party , service DMZ_DEV

2006-09-07 11:56:33 Error No "action" attribute found in XML document ("action" attribute missing or wrong XML structure)

2006-09-07 11:56:33 Error Exception caught by adapter framework: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Page 1 / 2

Thanks in advance

Thanks

Hari

[Former Member]

Hi Hari,

There is a good blog on this.. Check this out..

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

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

Hi Guys,

I Followed the all the documents which are realted to JDBC Reaciver. STill i am faceing same problem.

I hared coded INSERT- @ACTION. i SELECT Optional for attribute.

Once again thanks for helping me..

Regd's

Hari

[Former Member]

Hi Hari,

I was the same <u>stupid</u> error, because I read the doc too quickly...

Go to your Data Type and look at the line "action":

> DO NOT use "insert Element" but "<b>Insert Attribute</b>", because <u>action is an attribute</u> of TableName.

Example: If action has category "Element", then you have

<TableName>
<action>INSERT</action>
...
</TableName>

and it's wrong... That's why you have "<i>Error No "action" attribute</i> "

But if you use category "Attribute", then you will have:

<TableName <b>action</b>="INSERT">
...
</TableName>.

And this is exactly what the JDBC adapter want!

Mickael

Message was edited by: Mickael Huchet

[Former Member]

Hi Hari,

You will need to hard code ur action attribute with INSERT.

This means, create a constant node, with value=INSERT and map your action attribute to that.

cheers,

Prashanth

P.S Please mark helpful answers

[moorthy]

HI,

The error is because of your error in the mapped xml message format. i.e message which goes to JDBC adapter after mapping.

Check the message format based on this help-

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

In the mapping, action attribute is not mapped correctly or it is not in correct message format

Regards,

Moorthy

[Former Member]

HI Krishna

for action i been Hard coded with constant

'INSERT'-ACTION.

if we send Blank data is these problem will cause.

i followed the JDBC Reaciver DOC.

Thanks for quick responce

Regd's

Hari

[former_member206604]

Hi Hari,

Yes you need to fill action with INSERT or UPDATE. It is mandatory.

thanks,

Prakash

[former_member206604]

Hi,

"action" attribute is missing in your structure. You will need to mention the line action = 'INSERT' in that attribute. Please check if you have that and mapped it with a constant.

Check out this URL

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

Thanks,

Prakash