Skip to Content
author's profile photo Former Member
Former Member

Long runtime of loading stage on a process chain

Hi experts,

Just want to ask what is the possible cause of a long runtime of a specific loading step under the process chain

usually it runs 1.5hrs-3 hours with only 12,000-15,000 records being process.

Many thanks in advance!

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Jan 06, 2014 at 11:06 AM

    Hi,

    its depend on the load on your servers and application servers(free).

    At which step its taking more time? dtp or info pack?

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 11:44 AM

    It has start routine from source to target,,,

    how does a star routine affects the loading step? thank you so much!

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      A startroutine can contain code that is inefficient in updating/deleting data or do a lookup from another target which can impact the runtime. You should analyze the infopackage in which step it burns the most time. Inserting the data by handling the updaterule or selecting the data from the source etc.

      hope that helps

      Martin

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 11:19 AM

    Hi,

    It might the cause of the datasource in the source system. Can you check the datasource in RSA3 in Debug Mode with the help of Abaper.

    The problem persists, then you need to split the loads by using the infopackage selections.

    Thanks,

    Purushotham.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 08:18 AM

    Hi Christian,

    In general, the following will affect loading time:

    1) Number of records/fields to process

    2) Number of times require data lookup (database or itab)

    3) Size of the data to lookup (related to point 2)

    And you may also look for loop in the logic of any routine (start/end/field/expert).

    As loop increase number of operatiosn, and it is kind of increasing the number of point 1 and 2, specially nested loop.

    I will suggestion you look at the process monitor first to indicate which part cost most of the times.

    (Start routine/Transformation/End routine/Update?)

    And then try to check what is happening.

    In general, if cost most time in:

    1) Start routine/End routine

    Looking for loop, select into itab and try to time it

    2) Transformation

    As transformation is really a loop, try to spot if any field routine have a database look up or complex logic, try to comment them one by one and see if it make any major difference

    (In the order by your understanding to data)

    3) Update

    Too many records? (From source or generated by routines)

    Regards

    Bill

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 09:03 AM

    Hi Christian,

    Where are you getting stuck

    • ECC-PSA ? if its ECC to PSA then check the CMOD or FM.
    • PSA to DSO ?
    • DSO to Cube ?

    If its to DSO or Cube then check for the Routines - (Start or End Routine).

    And check for the code in the routines.

    Example 1:-Also if you are doing a Look Up to another DSO to populate a New Filed and then using a Non Key to do extract the data then it would take time as its Non Key in that case build Secondary indexes in DSO.

    Example 2:-Also If you have multiple loops and Selects statements inside Loop.

    rgds

    SVU

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 09:16 AM

    Hi Christian,

    The load my be extend may be the below mentioned reason

    1) Backend locks

    2) check the processes in sm50

    3) Server slow

    4) check how many background jobs running in sm37.

    5) SM51,SM66 in source system - What is running for this extractor,which program is being read,which table etc...

    6) Check also the table space available in St04 .

    Regards,

    Baskaran

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.