SFTP Sender

[former_member509118]

HI, I have an interface SFTPtoProxy and I'm with problem in mapping..

My file in SFTP Server is:

H005000005620132                                                                 20131015CDCA        CDEM

I0001            000000000000305829UN             15.000      0GERA560000002900001

I0002            000000000000305830UN             15.000      0GERA560000002900002                 

I0003            000000000000305831UN            15.000      0GERA560000002900003

I'm using Content Conversion:

My mapping:

my error:

I already checked several forums and wiki's and did everything that mention to do but the error continues...

Can someone help me?

[iaki_vila]

Hi Rodrigo,

You are using the fieldfixedlengths parameter, may be you are taking  the end of line too, are you trying to to substract one to each the fieldfixedlength parameter?

Regards.

[anupam_ghosh2]

Hi Rodrigo,

                     Could you please post the values you received in message mapping queue for  the source elements which is causing the exception.

Regards

Anupam

[former_member509118]

Hi Anupam...

this is the payload:

File.txt

H005000005620132I                                                      20131015CDCA        CDEM

I0001  000000000000305829UN        15.000 0GERA560000002900001                 

I0002  000000000000305830UN        15.000 0GERA560000002900002                 

I0003  000000000000305831UN        15.000 0GERA560000002900003                 

[former_member184720]

I see that you have configured Header.fieldSeparator and Item.Separator as 'nl' and i think should be Header.endSeparator and item.endSeparator

You can check the below blog-

http://saptechnical.com/Tutorials/XI/Contentconversion/page1.htm

[ambrish_mishra]

Hi,

What is the data received in PI ? Do view source in sxmb_moni and check for special characters.

this might be due to special characters in the file.

Ambrish

[former_member509118]

Hi Ambrish...

the strings of file has not special character, only spaces...

[ambrish_mishra]

Hi Rodrigo,

Your file structure seems quite reasonable. Why aren't you reading fixed length for all the fields and using 94 and 79 for fields other than identifier.

BTW, can you attach the sample file here.

thanks

Ambrish