SAP PI adapter SFTP sender - convert file - error Invalid byte 2 of 3 -byte UTF-8 sequence

[Former Member]

tbel-cancellationtobeinvoiced-20161122-051000.txtDear all,

we are in PI 4.0

Scenario SFTP file (format csv UTF-8 with BOM) to RFC

During the load of File, I convert it to xml document and during mapping there is an error "Invalid byte 2 of 3-byte UTF-8 sequence.

The file begin with characters EF BB BF

.I join the file I want to upload (test file).

Can somebody help me?

Eric Koralewski

[former_member190293]

Hi Eric!

Do you convert your flat file into XML structure using MessageTransformBean?

Regards, Evgeniy.

[ilie_aleman]

Similar error here with PO 7.5. Sender SFTP adapter is not able to process a file with encoding UTF-8-BOM . It doesn't even get to the module procesor and no specific error is showed.

Regards,

[Former Member]

HI Eric,

When i was checking for one of my issues, i found that, you also got similar kind of issue.

You solved by using Java Mapping step before the graphical mapping to eliminate the doublequotes in the nodenames.

could you please let me know ASAP - step by step process of java mapping and also code.

Thanks a lot - the above issue is like nightmare to me, if you provide me the inputs it will be a great helpful for me. Once again thanks in advance.

[former_member190293]

Hi Eric!

I've tried to process your attached file using MessageTransformBean. It worked for me. Maybe you could use it instead of FCC too?

Regards, Evgeniy.

[Former Member]

Hi Eric,

that's the byte order mark. I also still did not find a clean solution to get rid of this.

Actually, I would assume, that the SFTP-Adapter should eliminate this when reading the file, but it doesn't.

We are currently using a "string replace module" to remove it before the XML conversion-bean.

Regards,

Heiko

[Former Member]

Hi Evgenly,

No I convert the flat file with the file conversion included in the SFTP sender adapter.

Regards

Eric Koralewski