topic Re: Error on MM02 - Lock in Application Development and Automation Discussions

Error on MM02 - Lock

Former Member — Wed, 26 Feb 2014 13:57:09 GMT

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.

Re: Error on MM02 - Lock

Former Member — Wed, 26 Feb 2014 14:16:33 GMT

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.

Re: Error on MM02 - Lock

Former Member — Wed, 26 Feb 2014 15:00:51 GMT

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

Re: Error on MM02 - Lock

Former Member — Wed, 26 Feb 2014 15:22:15 GMT

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?

Re: Error on MM02 - Lock

Former Member — Wed, 26 Feb 2014 16:47:52 GMT

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.

Re: Error on MM02 - Lock

ThangaPrakash — Wed, 26 Feb 2014 17:17:50 GMT

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

Re: Error on MM02 - Lock

ThangaPrakash — Wed, 26 Feb 2014 17:19:13 GMT

Hello Gustavo,

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

Regards,

Thanga

Re: Error on MM02 - Lock

former_member821147 — Thu, 27 Feb 2014 07:39:57 GMT

Hi,

Check Sm12 and delete all entries related to that user.

Re: Error on MM02 - Lock

Former Member — Thu, 27 Feb 2014 11:16:49 GMT

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

Re: Error on MM02 - Lock

ThangaPrakash — Thu, 27 Feb 2014 12:45:59 GMT

Hello Gustavo,

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

Re: Error on MM02 - Lock

nabheetscn — Thu, 27 Feb 2014 13:04:41 GMT

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

Nabheet

Re: Error on MM02 - Lock

Former Member — Fri, 28 Feb 2014 19:05:16 GMT

No Nabheet, there was no job running...

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