Error on MM02 - Lock

[Former Member]

Hi,

When i try to alter a material on MM02, when i put the plant data, the error is launched:

The plant data of the material 1300000277 is locked by the user ############

The '###' chars really appears on the screen.

This error is launched by the fm ENQUEUE_EMMARCE as a "foreign lock".

But, when i execute the fm DEQUEUE_EMMARCE, nothing happens, the error continues on MM02.

Someone could help ?

Thanks in advance.

[Former Member]

you can't dequeue something, that was enqueued by someone else, I suppose. Your message says there is a lock on the plant data by somebody / something. Did you search SM12 for a corresponding record? There you may see who locks it.

[Former Member]

That's the point, there's no records in SM12 for this material.

[Former Member]

The locking concept of whole MM is a little bit tricky as locking there can be made via large amount of enhancements / customizing. Did you try debugging the place where the message is raised?

[Former Member]

Yes, it's raised on program SAPLMG22 inlcude LMG22FSQ:

FORM LESEN_MARC_SINGLE USING RCODE.

   DATA: HTABIX_KEY     LIKE SY-TABIX,
         SY_SUBRC_KEY   LIKE SY-SUBRC.

   CLEAR RCODE.

   PERFORM SPERREN_MARC USING SY-SUBRC.
   PERFORM MESSAGE_LOCK.

At this moment, the SPERREN_MARC returns the foreign lock from ENQUEUE_EMMARCE.

[ThangaPrakash]

Hello Gustavo,

Check in SM51 and double click on the server name in which you have lock issue.

In the last column of the ALV display you can find table name, check if there is any lock on the material master tables like MARA, MARC and so on.

Regards,

Thanga

[ThangaPrakash]

Hello Gustavo,

Also check in SM04 transaction, Is there any entries with transaction MM01, MM02 or other MM transactions.

Regards,

Thanga

[former_member821147]

Hi,

Check Sm12 and delete all entries related to that user.

[Former Member]

There's no records in SM12 for the supposed user.

And, there's no entries in SM04 with any MM transaction too.

Maybe the only way is to shutdown the server to clean the memory... i don't know where to look anymore.

Regards,

Gustavo

[ThangaPrakash]

Hello Gustavo,

Did u check in SM51 if there is any process running which is related

[nabheetscn]

Hi

Is it happening for all or only one material. Did you check in SM50/SM37 does any running job is locking it..?

Nabheet

[Former Member]

No Nabheet, there was no job running...

Thanks to all, but the problem was solved when the server was restarted.