Skip to Content
0
Former Member
Nov 24, 2006 at 09:57 AM

Empty XML file by posting Data from Oracle to FTP

34 Views

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" ?>

http://test.de/xi/lvs" />

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