DELETE FROM database statement hangs (rarely)

Former Member — Thu, 21 Nov 2013 15:53:21 GMT

Hi folks,

I got an unusual challenge in one of our systems.

When the statement:

DELETE FROM DATABASE indx(ab) ID lv_indxkey.

is being run within a user exit in the VA01 standard transaction, it causes the processing to hang for minutes. I've debugged this and there is no doubt that this statement, at that time, takes minutes to complete.

Other characteristics of this situation:

1) This doesn't always happen, it happened twice within the past 2 days, even though this statement is executed every time some VA01 checks are performed.

2) If it helps, the ID lv_indxkey at the time of the hanging was blank. Still, I've seen calls with the ID blank after the situation had passed and they were executed immediately.

3) The situation solved by itself, nobody did anything in the system. After a few minutes of debugging this, when trying to execute it again I've seen that the statement no longer hangs.

Before asking this question, be sure that I searched all the relevant SCN threads and the SAP Notes, nothing was obviously related to this.

So my question to you is, do you know of anything that can cause this DB cluster statement, DELETE FROM statement, hang so much and just for a few minutes, then be executed with normal runtimes?

Thanks in advance and best regards,

George

Re: DELETE FROM database statement hangs (rarely)

Former Member — Thu, 21 Nov 2013 16:26:14 GMT

Believe it or not, including mandt (client number) to key can solve this issue.

Re: DELETE FROM database statement hangs (rarely)

Former Member — Thu, 21 Nov 2013 16:32:16 GMT

Thanks Manish for the very quick reply.

topic Re: DELETE FROM database statement hangs (rarely) in Application Development and Automation Discussions

DELETE FROM database statement hangs (rarely)

Re: DELETE FROM database statement hangs (rarely)

Re: DELETE FROM database statement hangs (rarely)