Question Re: performance issue while using message transformation bean in receiver SFTP in Technology Q&A

performance issue while using message transformation bean in receiver SFTP

GauravKant — Mon, 20 Mar 2017 05:43:39 GMT

Hi Experts,

i have a proxy to SFTP scenario where i have used module configuration (message transformation bean) for SimpleXML2Plain.

While processing 4000+ records(approx. 4.5MB) from PO to SFTP it is taking more than 90min in transforming messages.

Could you please let me know how to improve performance for this.? PFB module configuration and logs of the same.

Thanks in advance!!

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

Andrzej_Filusz — Mon, 20 Mar 2017 08:47:32 GMT

Hi Gaurav,

The question is with which a component we have a problem. With your PO system or with your SFTP server? Are you able to connect with your SFTP server using a SFTP client application and put there a file (4,5MB) manually? Ideally if you could do this from your PO server. How much time did it take? If this operation wouldn't take a long time then we can be sure that it's not a communication/network problem. And we can start to look for a performace issue at your PO system.

Regards,

Andrzej

Re: performance issue while using message transformation bean in receiver SFTP

Harish — Tue, 21 Mar 2017 03:12:33 GMT

Hi Gaurav,

The performance of message transform bean is not so good with huge file. Please apply the below patch from SAP to improve the performance

1995921 - Performance improvement for content conversion

regards,

Harish

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Tue, 21 Mar 2017 07:10:28 GMT

Hi Andrzej,

Thanks!!

We have checked by uploading file directly to SFTP directory and it has uploaded within few seconds. So i don't think it is a network problem. We have to look at message transformation bean performance.

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Tue, 21 Mar 2017 07:11:41 GMT

Hi Harish,

Thanks a lot!!

I will check and update.

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Tue, 21 Mar 2017 12:10:29 GMT

Hi Harish,

We have PO 7.40 sp11 and it is not available in SAP note.

Can you please provide any other solution/notes for this.

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

Former Member — Tue, 21 Mar 2017 22:24:28 GMT

Hi Gaurav,

Its true performance of MTB bean is not good for Huge file size. use a simple Java mapping. Your transformation should be done in few seconds.

regards.

Nazeer

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Wed, 22 Mar 2017 06:37:13 GMT

Hi Nazeer,

Thanks !!

I'll try with java mapping.

need some more details-

We have processing sequence MTB-AF_Modules/DynamicConfigurationBean-PGPEncryption. I would like to know, will there be any impact using java mapping?

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

manoj_khavatkopp — Wed, 22 Mar 2017 07:36:02 GMT

Gaurav,

Have tried using StrictXml2PlainBean instead of MTB ? does that make any difference ?

Br,

Manoj

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Wed, 22 Mar 2017 12:05:19 GMT

Hi Manoj,

Thanks !!

I have not tried with StrictXml2PlainBean. I will give a try and update.

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

Harish — Wed, 22 Mar 2017 22:43:31 GMT

Hi Gaurav,

unfortunately I also not found anything for 7.4 sp11. You can also use the java mapping for converting XML to flat file. And you can also call the java class from adapter module (Messagetransformation bean). Please refer the below help page

https://help.sap.com/saphelp_nw73/helpdata/en/57/0b2c4142aef623e10000000a155106/content.htm

Deploy External Classes for the Module Processor

You specify external Java classes by using Transform.Class as in the classes above.
To load such Java classes from the AF_Modules/MessageTransformBean module, you must make them known to the relevant Java libraries (jar files) in the AS Java application.
To do so, install and modify the com.sap.aii.adapter.lib.sda archive file:
- Add the jar file to the archive com.sap.aii.adapter.lib.sdaarchive by using a zip program.
- Change the provider.xml file from com.sap.aii.adapter.lib.sda.
  - Extract provider.xml and add <jar-name>thejarname</jar-name> to each jar in the <jars> area.
  - Enter the following line in the <references> area:
    <reference type="library" strength="weak">com.sap.aii.messaging.runtime</reference>
  - Add the changed provider.xml to the archive again.
  - Ensure that the original path server\ is not changed. Check the last path entry.
Add all the jars (without specifying their path) that you defined in provider.xml to com.sap.aii.adapter.lib.sda.
Use the Software Delivery Manager to deploy com.sap.aii.adapter.lib.sda.
- If the empty archive was already deployed during installation, in the first step in deployment choose Update Deployed SDAs/SCAs that Have any Version.
  Otherwise deployment will terminate with the following message: Already been deployed.
Start AS Java again.
The module processor now knows the libraries.

regards,

Harish

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Wed, 12 Apr 2017 09:28:26 GMT

Hi Manoj,

I have tried with StrictXml2PlainBean but getting error due to structure level.

The element nesting level for the structure rec is too deep (reference: 3 levels, found: 4 levels) at XML element

Do we have a way to achieve this.?

Regards,

Gaurav

Re: performance issue while using message transformation bean in receiver SFTP

GauravKant — Wed, 03 May 2017 04:39:43 GMT

Hi Manoj,

Thanks for the inputs!!

I have removed one depth level from receiver structure and it is working fine. Now I am able to process 5MB files just in 15-20 sec.

Regards,

Gaurav