Skip to Content
avatar image
Former Member

SAP PI 7.1 Performance Issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 18, 2014 at 01:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Feb 18, 2014 at 01:35 PM

    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-dee0ac03f782?quicklink=index&overridelayout=true

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

    Add comment
    10|10000 characters needed characters exceeded