Skip to Content
avatar image
Former Member

Need help in FCC - writing to FTP

Hi, i have done this before but now i am stuck. I have following target structure for flat file:

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

<MT_PRVO>

<PRVORecordSet>

<PRVODetStruct>

<PVNR/>

<PVADAT/>

<PVSTELL/>

<PVNAME/>

<PVUPM/>

<PVNH/>

<PVKW/>

<PVLEER/>

<PVDIN/>

<TYPE/>

<PRVO_TXT/>

</PRVODetStruct>

</PRVORecordSet>

</MT_PRVO>

My FCC parameters are:

RecordsetStructure: PRVORecordSet,PRVODetStruct,PRVO_TXT

PRVORecordSet.fieldFixedLengths: 04,10,03,15,06,04,04,04,05,08,1400,1400,1400,1400

PRVODetStruct.fieldSeparator: ;

PRVODetStruct.endSeparator:'nl'

PRVO_TXT.fieldFixedLengths: 1400,1400,1400,1400

PRVO_TXT.fieldSeparator: 'nl'

My test-output after Mapping in SXMB_Moni is like this:

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

- <MT_PRVO>

- <PRVORecordSet>

- <PRVODetStruct>

<PVNR>78</PVNR>

<PVADAT />

<PVSTELL />

<PVNAME />

<PVUPM />

<PVNH />

<PVKW />

<PVLEER />

<PVDIN />

<TYPE />

- <PRVO_TXT>

<PVTXTD>D1 HIER D2 D5 D6 D9</PVTXTD>

</PRVO_TXT>

- <PRVO_TXT>

<PVTXTF>F1 F2 F3 F4 F7</PVTXTF>

</PRVO_TXT>

- <PRVO_TXT>

<PVTXTE>E1 E2 E3 E4</PVTXTE>

</PRVO_TXT>

- <PRVO_TXT>

<PVTXTS>S1 S2 S3 S4 S8 S10</PVTXTS>

</PRVO_TXT>

</PRVODetStruct>

</PRVORecordSet>

</MT_PRVO>

Problem is that i am getting this error in adapter Moni:

java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Consistency error: more fields found in XML structure than specified in conversion parameters! (Value 'D1 HIER D2 D5 D6 D9 ')', probably configuration error in file adapter (XML parser error)'

What have i done wrong? I am really stuck because in other scenarios everything works like this.

br

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 16, 2007 at 10:09 AM

    Hi,

    Check out the number of fields you mapped and the fields you provided in XML structure.. This is because of mismatch.

    regards

    Aashish

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Check out these blogs they may help you.

      /people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

      /people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

      /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

      /people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC /people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

      /people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

      /people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO

      regards

      Aashish Sinha

  • avatar image
    Former Member
    Nov 16, 2007 at 11:09 AM

    hi Carsten,

    did u checked <b>TEST in message mapping</b>, if it is giving successful test, so copy your source structure and put it into your source file.

    hope it will help.

    regards

    HONEY

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Prabhu S

      Hi, well of course!

      The recordset-structure i changed nothing, in parameters the following:

      I added following values to the parameters:

      PRVORecordSet.fieldFixedLengths: 04,10,03,15,06,04,04,04,05,08,<b>1400</b>

      PRVORecordSet.endSeparator: ;

      PRVODetStruct.fieldSeparator:;

      PRVODetStruct.endSeparator: 'nl'

      PRVO_TXT.fieldSeparator: '0'

      please compare to the posted parameters before.

      br