SAP PI 7.1 Performance Issue

[Former Member]

Hi All,

We are on SAP PI 7.1 and currently have a performance Issue for a particular interface. Every day we receive a huge file with 150K records and the interface is taking almost 3 hours to complete the process to convert to an XI Messages or payloads.

Interface is configured to 1 Record-sets per message so for 150K records we are having 150K XI Messages/payloads in application system. Interface is using a graphical mapping but the mapping is 1-1 simple mapping there are no transformations or conversions in the mapping object.

We did trace the performance monitor to check the timelines for each pipeline processing and what we observed is it is taking considerable amount of time in mapping. However when we process a simple file with 100 records or so the mapping is not taking that much amount of time. We also, tried changing the no of record-sets per message to 1000 and interface executed without any performance issues.

So what i think is more number of XI messages for an interface the more time it is talking to process. Do let me know if there is anyway to improve the performance

Thank You,

Regards,
Swaroop

[Muniyappan · Accepted solution]

Hi,

 Interface is using a graphical mapping but the mapping is 1-1 simple mapping there are no transformations or conversions in the mapping object

can you try this and check the performance?

delete the mapping and operation mapping. and delete the operation mapping in interface determination. just mention interface,namespace,swcv.

Regards,

Muni.

[Former Member · Accepted solution]

Thank you for your response, I can try that but I think its not related to mapping. I strongly think it has to do with volumes the performance is getting degraded with more no of messages. Some of the initial messages are getting initially it processes the records with processing time of 2 seconds and because of the volume the processing time is getting close to 5 mins.

Regards,

Swaroop

[former_member184720]

HI Swaroop - Are your about it? Is it mapping step taking much time? PLSRV_MAPPING_REQUEST?

I feel the below step should take much time incase you have many incoming messages.

DB_ENTRY_QUEUEING/ DB_SPLITTER_QUEUEING

As there are more no.of incoming messages, there should enough work processes to handle the load. You can tune by following the below guide.

However to handle such load enable message packing for a better performance.

Below guide will help you in debugging the issue further.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0b96675-87cf-2c10-b489-dee0ac03f...

P.S incase there is no mapping may be just develop a pass through interface.

[Former Member]

Hi Hareesh,

Thank you for suggesting message packing

I am sure that PLSRV_MAPPING_REQUEST is taking lot of time, Please see the attachment(tab delimited) for the processing time it is sorted descending by Processing time.

DB_ENTRY_QUEUEING/ DB_SPLITTER_QUEUEING - Seems to be ok and as i said in my previous post initially the messages are getting processed fine within 2secs but gradually the processing time is taking lot of time.

Do you still think the message packing will be helpful in my scenario.

Regards,

Swaroop

XI Pipeline Processing time1.txt.zip

[former_member184720]

Hi Swaroop - Message packging is definetly improve the performance during such high volume scenarios.

In the above shared document please refer to the below sections and follow SAP's suggesstions.