topic Re: Work Process stuck in sequential search in Application Development and Automation Discussions

Work Process stuck in sequential search

former_member608976 — Thu, 31 Oct 2019 16:35:12 GMT

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

Re: Work Process stuck in sequential search

GK817 — Fri, 01 Nov 2019 06:55:25 GMT

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/

Re: Work Process stuck in sequential search

FredericGirod — Fri, 01 Nov 2019 07:16:07 GMT

what is your database ?

Re: Work Process stuck in sequential search

Sandra_Rossi — Fri, 01 Nov 2019 13:40:07 GMT

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.

Re: Work Process stuck in sequential search

FredericGirod — Fri, 01 Nov 2019 13:50:11 GMT

Could be due to poor index quality in Oracle database. To rebuild it it is RSANAORA, but I cannot remember the program to calculate the quality (you could find it in db02_old transaction)

Re: Work Process stuck in sequential search

former_member608976 — Mon, 04 Nov 2019 10:22:31 GMT

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

Re: Work Process stuck in sequential search

Sandra_Rossi — Mon, 04 Nov 2019 18:45:10 GMT

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.

Re: Work Process stuck in sequential search

former_member608976 — Tue, 05 Nov 2019 09:50:21 GMT

Thanks Sandra.. This helped me identify indexes being used and see time difference between 2 systems to fetch records.. Although i am still in process of exact solution to help me identify issue in pre-production.. this was very helpful