SM12 "Diagnosis in update" reports "Error discovered"

[former_member198989]

Diagnosis in update reports the following in SM12:

09.10.2007 Dynamic List Display 1

-

---

-

---

Diagnosis in Update

Line

-

---

Step 1: Owner Keys / Dialog / Update
ok.
ENQKEY = 20071009203712187000000300*********.......................
ENQKVB = 20071009203712187000010300*********.......................
Step 2: Set Lock for Update
ENQKEY = 20071009203712187000010300*********.......................
ENQKVB = 20071009203712187000010300*********.......................
Object: ENQ_TEST
Granule: ENQ_TEST E ENQ_TEST ENQ_TEST ENQ_TEST ENQ_TEST
ok.
Step 3: Update Call, Pass On Lock
ok.
Step 4: Lock Passed On
ok.
Step 5: Wait for Update to End, Max.20 seconds
Update not completed after (seconds): 20
Locks not deleted
Step 6: Read Locks Messages from the Update
Step 7: Delete Locks
Error discovered ******************
Messages Received from Update
-No- -Time- - Message Text -
ENQ_TEST ENQ_TEST ENQ_TEST ENQ_TEST

-

---

It is not possible for functional people to create/change any entry in table LFA1

I am able to see 3 update work process in SM50 out of which 2 shows to be running

but with a time entry as 496297 and 494093

Searching in SDN did not yielded much help.

Can anyone please help?

Regards,

[former_member198989]

Problem resolved

Regards,

[Former Member]

Have you resolved the issue?

If not, Plz check if there are/were any background jobs running, which might be updating data.

Also, check to see if there are any expensive SQL statements (since it is a sequential read) I presume it might be an issue with Indexing in the LFA1 Table. If this is an ABAP report that is running the SQL statement, ask your Abapper to change the where clause in the SQL statement to match the current index of the table LFA1.

Hope this helps.

Regards

Shantanu

[former_member198989]

Ruchit and Shantanu

Thanks a lot for your help.

I have restarted the r/3 and the problem got solved.I believe the problem was due to the busy update processes.

Regards,

[Former Member]

Hello Prashant,

Check if there are any exclusive locks in DB01 and if they are then check if any deadlock has happened in ST04.

Regards.

Ruchit.

[former_member198989]

Thanks for your prompt reply.

There are no exclusive locks in DB01.

Regards,

[Former Member]

Hello Prashant,

For the two update processes that are long running just check if any activity is happening. Double click on them and you will find the records.

Additionally check what is status of SM13 ?

Regards.

Ruchit.

[former_member198989]

Ruchit,

I am not able to interpret the information it is showing for the two processess.

But, it says that there is a sequential read going on, on table KOCLU and a report named SAPLV45U is running.

But there are no user except myself and one more in the system.

SM13 shows 10 update records. 2 have status enqueues deleted(shown in red).

Rest others show status initial(shown in green)

Please guide as to how interpret information about the work process if needed.

Regards,

[Former Member]

Hi Prashant,

Do you have any update processes available. Also for Sm13 don't take a singular snapshot. Stay in this transaction for a around a minute or so and keep on refreshing it. Just check if the data is changing.

Regards.

Ruchit.

[former_member198989]

Yes I do have a V1 update process available(total there are 3) and there are 2 separate V2 processes.I have just restarted the update work processes which were running for a long duration.Proceeding to restart the R/3 instance.

Will update to you.

Regards,