attribute "action" missing or wrong XML structure

[Former Member]

Hi, expert,

I think our JDBC driver is working now. But I got another error says" Error: TransformException error in xml processor class: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)"

I have given the value "insert" to "action". Do I need to define action as an attribute to make it work? If so, how can I do it? I am really new to XI. Thanks!

Marea

[moorthy · Accepted solution]

Hi,

The error is because of incorrect xml structure going to JDBC adapter

Action is an Attribute in the Reciever JDBC message structure.

Refer thru these -http://help.sap.com/saphelp_nw2004s/helpdata/en/ae/d03341771b4c0de10000000a1550b0/content.htm

the strurcture should look exaclty similar.

Also look into this blog for the datatype and structure-

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

Regards,

Moorthy

[Former Member · Accepted solution]

Hi, Moorthy,

Thanks for the reply. I looked at the first link and see my JDBC communication channel is defined collectly. And I am exactly doing the same thing stated in your second link( I am doing that example for my exercise. I don't know if I got your point. Thanks.

Marea

[moorthy · Accepted solution]

Test your mapping in the IR with live data from the SXMB_MONI.

And take the Source xml of your Target Mapped message. SO compare this message xml with SAP help mentioned. also send this xml here so that it is easy to debug.

Regards,

Moorthy

[Former Member · Accepted solution]

I tested my mapping in IR Message Mappings and Interface Mappings. It says "Execute succefully". Also I see the values have been posted in result area the same as in the source. I don't know how to test it using SXMB_MONI.

When I was testing my scenario, I used FTP to send my xml message. The message is like this

- <ns1:DATA_FILESENDER xmlns:ns1="http://XI/MYSAMPLE">

<EMPID>1</EMPID>

<EMPNAME>A</EMPNAME>

<EMPAGE>4</EMPAGE>

<FLAG>Y</FLAG>

</ns1:DATA_FILESENDER>

Please help again. Thanks.

Marea

[moorthy · Accepted solution]

I am asking the message structure(i.e xml of target mapped structere) after mapping i.e structure which goes into JDBC adapter i.e your target strcuture ( with table name etc)

[Former Member · Accepted solution]

Hi, Moorthy,

I am sorry for not catching you. Here is the target structure,

.DATA_JDBCRECEIVER

.STATEMENTNAME

.TEST

.action(VALUE INSERT)

.TABLE (VALUE ZJDBC_MY)

.access

.EMPID

.EMPNAME

.EMPAGE

.FLAG

Thank you very much!

Marea

[moorthy · Accepted solution]

I need mapped data with structure i.e

with other parts of the target strcuture i.e table name etc

<EMPID>1</EMPID>

<EMPNAME>A</EMPNAME>

<EMPAGE>4</EMPAGE>

<FLAG>Y</FLAG>

Anyway the problem looks like your table name is not mentioned correctly ? Is your Table name is ZJDBC_MY ? if so your structure should contain like this-

DATA_JDBCRECEIVER

.STATEMENTNAME

.<b>ZJDBC_MY</b>

.action(VALUE INSERT)

.TABLE (VALUE ZJDBC_MY)

.access

.EMPID

.EMPNAME

.EMPAGE

This is the reason , i told you to check the blog mentioned in my first reply. check it again..

Regards,

Moorthy

[Former Member · Accepted solution]

Hi, Moorthy,

I got you now. You mean in that blog, element TEST is the table name. He should mention that in his blog.

Thank you very much! I will change it and see what happens.

Marea

[moorthy · Accepted solution]

Hope it works:)

Regards,

Moorthy

[Former Member · Accepted solution]

I am so sorry. It still has the same error.

Marea

[Former Member · Accepted solution]

It works now!!!!!!!

Thank you very much Moorthy!

Marea

[Former Member · Accepted solution]

Moorthy,

May I please ask what the significance is of STATEMENTNAME. Why does this element need to be in the target document?

Thanks.