ERROR in configuration:more elements in file csv structure than filed names

[Former Member]

<p ct="TextView" class="urTxtStd" style="white-space:nowrap;">Hello,<br>we have problem with file content conversion on file (FTP) sender<br>adapter when reading flat delimited file.<br><br>Error:<br>Conversion of file content to XML failed at position 0:<br>java.lang.Exception: ERROR converting document line no. 2 according to<br>structure 'P':java.lang.Exception: ERROR in configuration: more<br>elements in file csv structure than field names specified!<br><br>Details:<br>We have windows machine and line in a file is ended with CRLF.<br>We have PI 7.0 SP10, and following pathches:<br>SAPXIAF10P_3-10003482<br>SAPXIAFC10P_4-10003481<br><br><br>Adapter Type: File<br>Sender<br>Transport Protocol: File Transfer Protocol (FTP)<br>Message Protocol: File Content Conversion<br>Adapter Engine: Integration Server<br><br>FTP Connection Parameters<br>Transfer Mode: Binary<br><br>Processing Parameters<br>File Type: Binary<br><br>Channel: IN_XXXXX_FILE_WHSCON<br><br>Input File: (WZ00008.DAT)<br>N|0025013638||0000900379|0000153226|2007-07-24|2007-07-24||||<br>P|000030|2792PL1|2303061|1|KRT|||||<br><br>Content Conversion Prameters:<br>Recordset Structure: N,1,P,<br>Recordset Sequence: Ascending<br><br>Key Field Name: KF<br>Key Field Type: String<br><br>N.fieldNames: N1,N2,N3,N4,N5,N6,N7,N8,N9,N10<br>N.fieldSeparator: |<br>N.endSeparator: 'nl'<br>N.processFieldNames: fromConfiguration<br>N.keyFieldValue: N<br><br>P.fieldNames: P1,P2,P3,P4,P5,P6,P7,P8,P9,P10<br>P.fieldSeparator: |<br>P.endSeparator: 'nl'<br>P.processFieldNames: fromConfiguration<br>P.keyFieldValue: P<br><br><br>At the same time we have another channel very similar to this on which<br>works:<br><br>Channel: IN_XXXXX_FILE<br><br>Input File: (PZ000015.DAT)<br>N|2005-11-25|13:01||<br>P|0570001988|2005|305|6797PL1|2511091|3500|SZT|2005-11-<br>25|1200|G002|1240|G002|||<br><br><br>Content Conversion Prameters:<br>Recordset Structure: N,1,P,<br>Recordset Sequence: Ascending<br><br>Key Field Name: KF<br>Key Field Type: String<br><br>N.fieldNames: N1,N2,N3,N4<br>N.fieldSeparator: |<br>N.endSeparator: 'nl'<br>N.processFieldNames: fromConfiguration<br>N.keyFieldValue: N<br><br>P.fieldNames: P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,P13,P14,P15<br>P.fieldSeparator: |<br>P.endSeparator: 'nl'<br>P.processFieldNames: fromConfiguration<br>P.keyFieldValue: P<br><br>Converted file:<br>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;<br>&lt;ns:PZ_MT xmlns:ns=&quot;<a href="http://xxxxx.yyyyy.hr&quot;&gt;" target="_blank" title="Open this link in a new window">http://xxxxx.yyyyy.hr&quot;&gt;</a><br>&lt;PZ&gt;<br> &lt;N&gt;<br> &lt;N1&gt;N&lt;/N1&gt;<br> &lt;N2&gt;2005-11-25&lt;/N2&gt;<br> &lt;N3&gt;13:01&lt;/N3&gt;<br> &lt;N4&gt;&lt;/N4&gt;<br> &lt;/N&gt;<br> &lt;P&gt;<br> &lt;P1&gt;P&lt;/P1&gt;<br> &lt;P2&gt;0570001988&lt;/P2&gt;<br> &lt;P3&gt;2005&lt;/P3&gt;<br> &lt;P4&gt;305&lt;/P4&gt;<br> &lt;P5&gt;6797PL1&lt;/P5&gt;<br> &lt;P6&gt;2511091&lt;/P6&gt;<br> &lt;P7&gt;3500&lt;/P7&gt;<br> &lt;P8&gt;SZT&lt;/P8&gt;<br> &lt;P9&gt;2005-11-25&lt;/P9&gt;<br> &lt;P10&gt;1200&lt;/P10&gt;<br> &lt;P11&gt;G002&lt;/P11&gt;<br> &lt;P12&gt;1240&lt;/P12&gt;<br> &lt;P13&gt;G002&lt;/P13&gt;<br> &lt;P14&gt;&lt;/P14&gt;<br> &lt;P15&gt;&lt;/P15&gt;<br> &lt;/P&gt;<br>&lt;/PZ&gt;<br>&lt;/ns:PZ_MT&gt;<br><br>And, if we remove last delimiter before CRLF in WZ00008.DAT file then<br>file works, but we dont't have fields N10 and P10 in a XML converted<br>file.<br><br>Converted file:<br>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;<br>&lt;ns:WZ_MT xmlns:ns=&quot;<a href="http://xxxxx.yyyyy.hr&quot;&gt;" target="_blank" title="Open this link in a new window">http://xxxxx.yyyyy.hr&quot;&gt;</a><br>&lt;WZ&gt;<br> &lt;N&gt;<br> &lt;N1&gt;N&lt;/N1&gt;<br> &lt;N2&gt;0025013639&lt;/N2&gt;<br> &lt;N3&gt;&lt;/N3&gt;<br> &lt;N4&gt;0000900379&lt;/N4&gt;<br> &lt;N5&gt;0000153226&lt;/N5&gt;<br> &lt;N6&gt;2007-08-01&lt;/N6&gt;<br> &lt;N7&gt;2007-08-01&lt;/N7&gt;<br> &lt;N8&gt;&lt;/N8&gt;<br> &lt;N9&gt;&lt;/N9&gt;<br> &lt;/N&gt;<br> &lt;P&gt;<br> &lt;P1&gt;P&lt;/P1&gt;<br> &lt;P2&gt;000010&lt;/P2&gt;<br> &lt;P3&gt;0212PL1&lt;/P3&gt;<br> &lt;P4&gt;2007071&lt;/P4&gt;<br> &lt;P5&gt;1.000&lt;/P5&gt;<br> &lt;P6&gt;KRT&lt;/P6&gt;<br> &lt;P7&gt;&lt;/P7&gt;<br> &lt;P8&gt;&lt;/P8&gt;<br> &lt;P9&gt;&lt;/P9&gt;<br> &lt;/P&gt;<br>&lt;/WZ&gt;<br>&lt;/ns:WZ_MT&gt;<br><br>Regards,<br>Mladen Kovacic</p>

[Former Member · Accepted solution]

Hi,

In FCC use this

<RecordSetStructure>.additionalLastFields = ignore.

Cheers,

*RAJ*

[Former Member]

N yeah itz available from SP 19 Onwards.

<b>Cheers,

*RAJ*</b>

[Former Member]

Hello,

I tried, but it doesn't work.

I am not sure whether it works on PI 7.0 SP10.

Regards,

Mladen Kovacic

[Former Member]

Hello,

it seems that we have problem with SAP XI AF CPA Cache.

We make this changes and after this AF Cache stops working.

• In the Visual Administrator, in service SAP XI AF CPA Cache, set the SLDAccess parameter to false

• Save your entry and start the service

• In service SAP XI AF CPA Cache, check that the cacheType parameter has the value DIRECTORY

• In service SAP XI Adapter: XI, enter values for:

o xiadapter.isconfig.url - http://xidev:8038/sap/xi/engine?type=entry

o xiadapter.isconfig.username - XIAFUSER

o xiadapter.isconfig.password –

o xiadapter.isconfig.sapClient - 001

o xiadapter.isconfig.sapLanguage - en

• On the Integration Server, use transaction SMICM to check that you have entered the correct URL for the Integration Server.

• On the Integration Server, use transaction SU01 to create a new user XIAFUSER

• Assign the role SAP_XI_AF_SERV_USER_MAIN to the user XIAFUSER

• In the Visual Administrator, check whether the user synchronization was successful

• Use the new user to log on to the Integration Server and change the initial password to master password

Any idea for SAP XI AF CPA Cache update?

[Former Member]

Hello,

Your file having folllowing structure..

N|0025013638||0000900379|0000153226|2007-07-24|2007-07-24||||

N.fieldNames: N1,N2,N3,N4,N5,N6,N7,N8,N9,N10

...

You have one extra field in N Line( 8||0 two separators here)....Remove Last "|" and it will work.

Nilesh

[Former Member]

Hello all,

We restored SAP XI AF CPA Cache as it was before

• In the Visual Administrator, in service SAP XI AF CPA Cache, set the SLDAccess parameter to true

• SLD.selfregistration.hostName=xidev

• SLD.selfregistration.httpPort=53800

• Save your entry and start the service

After this content conversion works OK.

Thanks all