cancel
Showing results for 
Search instead for 
Did you mean: 

How to solve the following JDBC-DB2 FORMAT problem?

Former Member
0 Kudos

Here is the error info:

Message processing failed.

Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException:

Error processing request in sax parser:

No 'action' attribute found in XML document

(attribute "action" missing or wrong XML structure)

The XML message after pipeline is:

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

- <ns0:Create_Material4PT xmlns:ns0="http://parmalat.ca/DMS">

- <root>

- <StatementName2>

- <dbTableName action="INSERT">

<table>MFIP931P</table>

- <access>

<PRODP>20L Bea Homo MilkFFF</PRODP>

<UPCP>055300115008</UPCP>

</access>

</dbTableName>

</StatementName2>

</root>

</ns0:Create_Material4PT>

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member463616
Contributor
0 Kudos

Hi,

Please once again do cross check with your JDBC Receiver Structure.

Please see the below link.

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

If you see the above blog, action is an attribute of TEST and not STATEMENTNAME.

I think, these kind of hierarchy is missing in your receiver structure. Please check once again.

Hope this helps to you.

Regards,

P.Rajesh

naveen_chichili
Active Contributor
0 Kudos

HI,

Could you please click on the message id in the channel level details window popsup and go to the content and check if you are able to see correct payload there..

if you are not able to see the right pay load then there should be some problem in ur configuration...pls cross check....

Cheers!!!!!!

Naveen.

baskar_gopalakrishnan2
Active Contributor
0 Kudos

I think your structure is okay. But if you want , you can remove some unwanted tags and modify as below.

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

<ns0:Create_Material4PT xmlns:ns0="http://parmalat.ca/DMS">

<StatementName>

<dbTableName action="INSERT">

<table>MFIP931P</table>

<access>

<PRODP>20L Bea Homo MilkFFF</PRODP>

<UPCP>055300115008</UPCP>

</access>

</dbTableName>

</StatementName>

</ns0:Create_Material4PT>

Have you declared attribute action type is string and occurence optional?

Former Member
0 Kudos

Thanks Sir, I just check the structure, ACTION is an attribute, it seems the problem located in somewhere else.

former_member463616
Contributor
0 Kudos

Hi,

It seems to like problem with your JDBC structure. In the structure action should be in the category declared as a attribute.

Please see the below link, it might be useful to you.

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

Regards,

P.Rajesh