Skip to Content

Work Process stuck in sequential search

Hi ,

We are running a program in background in pre-production system(Data for this system is refreshed just last week) and i is taking very long.When i look in SM50 i can see a work process stuck 'Sequential Read of DB DFKKOP'.

But the same program runs fine in production without any issues.

Can anyone give a hint or suggestion what could be the issue.

Cheers,

Anjana Rao

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 01, 2019 at 01:40 PM

    With Oracle systems, I usually look at the shared cursor cache in ST04, select all statements about DFKKOP, it shows even the ones which are currently running, refresh to make sure which DFKKOP request corresponds to yours (probably yours reads intensively)... If so, it's probably the culprit and you may analyze its execution plan (what index and what strategy it's using, etc., compare with the one in production). Based on your analysis, some solutions can be the calculation of statistics, creation of missing indexes... Note that you also have a button to reach the corresponding ABAP code.

    The difference with the production system is also maybe due to the volume of data which is processed and a slowest disk, RAM or CPU. Here, no other solution than reducing the volume processed, or just wait.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 01, 2019 at 06:55 AM
    -1

    Hi Anjana,

    Rather than hit & trial, please use new debugger feature effectively. This blog post has exact use case. I hope this helps:

    https://blogs.sap.com/2019/10/10/abap-debugger-scripting-my-first-real-use/

    GK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 04, 2019 at 10:22 AM
    -1

    Moderator : I want to accept Sandra rossi comment... this helped me a lot.. can not find accept under her response.. can you help

    Add a comment
    10|10000 characters needed characters exceeded

    • It requires that I first convert my comment into an answer, then you can accept it. Let me do that.

      If you have found a solution (or not), a feedback about the solution is welcome. Note that you may also post your own answer and accept it.

      PS: Please use the COMMENT button for comments, questions, adding details, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

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.