Empty XML file by posting Data from Oracle to FTP

[Former Member]

Hi all,

I want to select a dataset from database and post it to a FTP Server as flat file. In Integration Repository I have defined all needed objects and in the Integration Directory I have defined the desired scenario. The select and update statement were processed successfully. But when I view the generated flat file in FTP Server it contains only the follow text:

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

<ns1:StoreFTP xmlns:ns1="http://test.de/xi/lvs" /></b>

But when I check the SOAP-Payload in message-monitoring I see that the dataset is picked up correct from database. Here comes the SOAP-Payload:

<b>

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

<StoreFTP>

<row>

<SATZ_NR>3</SATZ_NR>

<SATZ_ART>RHBDAT</SATZ_ART>

<STATUS>20</STATUS>

<PARAM01>ole2</PARAM01>

<PARAM02 />

<PARAM03 />

<PARAM04 />

<PARAM05 />

<ERROR_MSG />

<ANL_DT>2006-11-23 10:19:22.0</ANL_DT>

<AEN_DT />

</row>

</StoreFTP>

</b>

When I check the processed XML Messages in SXMB_MONI there is nothing exceeding. The status is successful processed.

Thanks in advance

Florian

[Shabarish_Nair · Accepted solution]

also try a test of your mapping (/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios).

It seems to be a problem in your mapping only.

[Former Member · Accepted solution]

Ok, this helped me a lot. You are both right, the mapping is not correct. Now I will search for the problem and tell you where the error was.

[Former Member · Accepted solution]

I found the error in the mapping. The root element should include namespace declaration. But I don't know where I can insert it in the mapping?

The source xml should look like this:

<b>

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

<ns0:StoreFTP xmlns:ns0="http://test.de/xi/lvs">

<row>

<SATZ_NR>3</SATZ_NR>

<SATZ_ART>RHBDAT</SATZ_ART>

<STATUS>20</STATUS>

<PARAM01>ole2</PARAM01>

<PARAM02 />

<PARAM03 />

<PARAM04 />

<PARAM05 />

<ERROR_MSG />

<ANL_DT>2006-11-23 10:19:22.0</ANL_DT>

<AEN_DT />

</row>

</ns0:StoreFTP>

</b>

[Former Member · Accepted solution]

Hi,

You don't have to insert htis. Ithink it happens on its own when you have a namespace attached to the Message type.

Please can you check if the namespace is attached to both the sender and reciever Message Types

Regards

vijaya

[bhavesh_kantilal · Accepted solution]

Hi,

In the sender JDBC adapter, you have a field called <b>DOCUMENT NAMESPACE</b>. This will contain the Namespace value. Give you namespace in this field.

Also, there is another field called DOCUMENT NAME --> This will be the name of your message type.

Regards,

Bhavesh

[Shabarish_Nair · Accepted solution]

the namespace is filled automatically. in your case check whether you have the corresponsing mesg. type under the namespace - http://test.de/xi/lvs

this blog shows how to remove a namespace - https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2769. [original link is broken] [original link is broken] [original link is broken] [original link is broken] In your case u need to have the namespace !!!

[Former Member · Accepted solution]

Thank you very much. This weblog will solve another problem I have.

[Former Member · Accepted solution]

Thank you. This solution solved the problem.

[bhavesh_kantilal]

Hi,

It looks like there is some problem in the mapping between the source ( from the JDBc adapter ) and the target ( the file's message).

use this blog to test your mapping,

/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Regards,

Bhavesh