Receiver JDBC error

[Former Member]

Hi All,

I get a error in cc monitoring for JDBC adapter. The error msg I get is

<b>

Error while parsing or executing XML-SQL document: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)</b>

My receiver JDBC XML structure

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

- <ns1:mt_target xmlns:ns1="http://test">

- <events action="INSERT">

<table>jai_db.tab1</table>

- <access>

<Id>140246</Id>

<Emp Name>Jai</Emp Name>

<IDATE>12/18/06</IDATE>

<ITIME>23:41:08</ITIME>

</access>

</events>

</ns1:mt_target>

Can you pls tell me where I have gone wrong?

Regards,

Jai Shankar

[bhavesh_kantilal · Accepted solution]

Jai,

STATEMENT level tag is missing!

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

- <ns1:mt_target xmlns:ns1="http://test">

<b><STATEMENT></b>

- <events action="INSERT">

<table>jai_db.tab1</table>

- <access>

<Id>140246</PXNVN>

<Emp Name>Jai</Emp Name>

<IDATE>12/18/06</IDATE>

<ITIME>23:41:08</ITIME>

</access>

</events>

<b></STATEMENT></b>

</ns1:mt_target>

Regards

Bhavesh

[Former Member · Accepted solution]

Bhavesh,

I guessed it should be the problem, but prayed it should not be, coz if I change the dat type by introducing <statement> tag I will loose all my mapping Beleive me the target structure is very big and I have to update 4 different tables.

Is there any way I can introduce the <statement> tag with out loosing my current mapping?

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi,

U have an option of cut,copy and Insert for a node. U can see via right click on the node during creating Data type in Editor.(for easier alteration of Data Type)

Regards,

Sudharshan

Message was edited by:

Sudharshan Aravamudan

[Former Member · Accepted solution]

Hi,

Try if mapping template can help you in this case.Select the element events and save the mapping as template. Introduce the statement element on top of it. And try to apply the template saved in the previous case. Not sure if this works, just give a try.

Regards,

Sudheer.

[bhavesh_kantilal · Accepted solution]

Jai,

When you make a change in the target datatype, the mapping will be retained

Only you would need to map the new field.

If you make the change in the source datatype though, the mapping is lost!

In your case i hope you need to change the target datatype and so it wouldnt matter much!

Regards

Bhavesh

[Former Member · Accepted solution]

Bhavesh,

Unfortunately that is not the case. When I introduce the <statement> tag in my target data type all my mapping gets lost

I get a information mapping skipped, node not found... some thing of this sort for all the nodes....

Regards,

Jai Shankar

[bhavesh_kantilal · Accepted solution]

Jai,

Dats strange, I just did the same. I intrduced a new element in my target datatype and then when i went to my mapping, i found that the old mapping still existed!

will try introducing a node and then see what happens!

regards

Bhavesh

[Former Member · Accepted solution]

Bhavesh,

If a new element is introduced in <acces> node, the mapping is retained, but if a <statement> node is introduced all my mapping vanishes

Regards,

Jai Shankar

[bhavesh_kantilal · Accepted solution]

Jai,

Just tried the same as well! Looks like addition of a Element doesnt matter. But addition of a node does make the mapping disappear!

Regards

Bhavesh

[Former Member · Accepted solution]

Thanks for all the helping hands...

I l try start doing the mapping from scratch....:-(((

Regards,

Jai Shankar

[Former Member]

Hi,

Table and access should be subelement of <events>

Check "action" is defined as attribute in datatype.

Regards,

P.Venkat

[Former Member]

Hi,

Just cross check the structure

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm</a>

Regards,

Sudharshan