cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP Config Scenario has Codepage issue with umlaut characters

former_member201275
Active Contributor
0 Kudos

We are on PI version 7.1

I have many SFTP Config Scenarios which simply pick up a file in one location and deliver it to another. All of these work fine but now I have an issue with one particular scenario where there is a codepage problem. What is happening is that characters with umlauts (äöü... etc) are delivered as garbage.

SFTP delivers files in binary mode and so in PI we don’t convert or change anything therefore this should work. I don’t understand why this particular scenario doesn’t work?

I have seen a number of posts on codepage issues, (including this very useful link http://scn.sap.com/thread/3307004), and many of these suggest using AF_Modules/MessageTransformBean, followed by the conversion Bean AF_Modules/TextCodepageConversionBean. The problem is that in my SFTP adapter these Modules are not available, I am assuming because we are only on version 7.1.?

Any help/advice would be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

former_member201275
Active Contributor
0 Kudos

I currently have this now, but it is not working:

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glen,

Remove TextcodepageConversion module, since Using MessageTransformBean is sufficient.

Also, please maintain  the charset accordingly i.e. whether it is utf-8 or ISO.....

Please maintain the message transform bean like this.

Try this out and let me know the outcome.

Regards

Vishnu

former_member201275
Active Contributor
0 Kudos

Thank you Vishnu, that has done the trick. You have made my Monday!

pvishnuvardan_reddy
Active Contributor
0 Kudos

You are welcome Glen...

Former Member
0 Kudos

Hello Glen ,

Apart from Message TransformBean , was the note 1906648 checked .

Can you please  try adding the parameter file.encoding in the Advanced Mode as per the note and know the results.


Regards,

Malini

Answers (2)

Answers (2)

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Glen,


I have seen a number of posts on codepage issues, (including this very useful link http://scn.sap.com/thread/3307004), and many of these suggest using AF_Modules/MessageTransformBean, followed by the conversion Bean AF_Modules/TextCodepageConversionBean. The problem is that in my SFTP adapter these Modules are not available, I am assuming because we are only on version 7.1.?

What do you mean they are not available on PI 7.1?

You can add them in the sender adapter module configuration.

Regards,

Mark

former_member201275
Active Contributor
0 Kudos

Hi Mark,

What I mean is that I cannot see these Modules in the ESB in the SFTP Metadata display i.e. I can see the 'ExitBean' (see screenshot below) but not 'Transform' or 'Convert' Beans?

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Glen,

Do not worry about it. I also have the same screenshot for File Adapter.

Regards,

Mark

former_member201275
Active Contributor
0 Kudos

Hi Mark,

Thank you once again for your help! Very useful.

One last question, if i may.

Do you have any idea how I can test my solution? I have tried by creating a non utf-8 txt file with the umlaut characters, then putting this on AL11 (cg3z), then in my receiver i receive this in another path on AL11. However all the way through when I display my file the values are correct i.e. the umlauts are always there!

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glan,

For testing, you can use FileZilla tool to place the file.

You can also use RWB testing option for testing.

Do end to end testing in non production environment and check the file for the characters you want to watch out for at the receiver end.

Regards

Vishnu

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glen,

Regarding your modules query, the modules which you are viewing in the metadata are the standard modules provided for the SFTP adapter.

According to our requirement, we will use the standard modules provided by SAP to achieve our functionality.

Regards

Vishnu

former_member201275
Active Contributor
0 Kudos

Hi Vishnu,

So the modules we see in the Metadata are the only modules we are allowed to use? In other words I cannot use 'AF_Modules/MessageTransformBean' because I cannot see this in the SFTP Metadata?

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glen,

No, that's not what I mean.

What I am trying to say is that those are the standard or modules which comes with the adapter. i.e. when you try to create a SFTP channel, when you go to module tab, you will see these modules.

SAP has provided some standard modules like message transform bean, XML anonymizer bean etc. to achieve some functionality according to our requirement.

Yes, you can use these standard modules whenever/whereever it is needed according to your requirement.

Regards

Vishnu

former_member201275
Active Contributor
0 Kudos

Hi Vishnu,

Thank you i understand now.

When I am creating the communication channel and i go to 'module' tab I don't get a drop down list or anything for these modules but I have found these on SCN so I have added them anyway.

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glen,

Please close this thread if your issue has resolved.

It helps out other fellow mates who ever facing the same type of issue..

Regards

Vishnu

former_member201275
Active Contributor
0 Kudos

Hi Vishnu,

Yep i realise this and will of course close... still struggling with testing i.e. still seeing umlat characters eg. äöü etc., as garbage! It's quite difficult to know which Modules are available for the SFTP adapter without a dropdown, and the subsequent parameters as well are difficult to find as also there is no dropdown!

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Glen,

Similar type of discussion has done in the below thread. Can you check this out:

Yes, you can use Message Transform Bean in the adapter.

Please let us know if you still have any issues with proper screen shots for better understanding of the issue.

Regards

Vishnu