topic Re: Dequeue multiple instances of the same lock in Application Development and Automation Discussions

Dequeue multiple instances of the same lock

roland_spindler — Mon, 01 Feb 2010 08:34:14 GMT

Hello,

I'm developing a user exit for a standard transaction. In this exit I want to dequeue some of the locks created by the standard transaction. For some reason it has created multiple locks for the same object.

So if I write

CALL FUNCTION 'DEQUEUE_ESORDER'

EXPORTING

mode_aufk = 'E'

aufnr = l_aufnr.

the "use count" in SM12 decreases by one. If I call the same dequeue several times (e.g. in a DO loop), the lock disappears in SM12.

Is there a way to remove all lock instances with a single FM call?

Thanks in advance

Roland

Re: Dequeue multiple instances of the same lock

Former Member — Mon, 01 Feb 2010 08:37:41 GMT

hi,

Try FM 'DEQUEUE_ALL'.

Thanks,

Archana

Re: Dequeue multiple instances of the same lock

roland_spindler — Mon, 01 Feb 2010 08:40:27 GMT

I don't want to remove all locks, just all locks for a certain object.

Roland

Re: Dequeue multiple instances of the same lock

SuhaSaha — Mon, 01 Feb 2010 08:43:40 GMT

Hello,

For some reason it has created multiple locks for the same object

If you check the SAP documentation on [SAP Lock Mechanism|http://help.sap.com/saphelp_nw04/Helpdata/EN/aa/fd823730fa874ae10000009b38f8cf/frameset.htm] how can you justify this statement.

BR,

Suhas

Re: Dequeue multiple instances of the same lock

Former Member — Mon, 01 Feb 2010 08:44:34 GMT

Hi Roland,

You may

- lock the whole table SM30 like via lock object E_TABLE or E_TABLEE

CALL FUNCTION 'ENQUEUE_E_TABLE'
     EXPORTING
          tabname      = 'MARA'
     EXCEPTIONS
          foreign_lock = 1.

- lock the whole set of keys using a wildcard key via the lock object assiociated to records of the table

CALL FUNCTION 'ENQUEUE_EMMARAE'
 EXPORTING
   mandt                = sy-mandt
*  MATNR                = " generic value will lock whole table
 EXCEPTIONS
   foreign_lock         = 1
   system_failure       = 2
   OTHERS               = 3.

But be aware that the lock tools will only lock vs other reports using the same logic/FM. (chek in SM12)

Also read documentation like The SAP Lock Concept (BC-CST-EQ) and samples like Example Program: SAP Locking

Re: Dequeue multiple instances of the same lock

roland_spindler — Mon, 01 Feb 2010 09:31:47 GMT

Suhas,

As I didn't implement the standard transaction - obviously - this question should be sent to SAP, but my best guess is that two different LUWs have been started.

Kumar,

I'm not trying to lock something, I'm trying to remove locks created by someone else.

Roland

Re: Dequeue multiple instances of the same lock

Former Member — Mon, 01 Feb 2010 09:39:37 GMT

This message was moderated.

Re: Dequeue multiple instances of the same lock

roland_spindler — Mon, 01 Feb 2010 09:42:36 GMT

Kumar,

1) My name is Roland.

2) Please do not post any lock-related stuff to a very specific question.

Thank you

Roland

Re: Dequeue multiple instances of the same lock

Former Member — Mon, 01 Feb 2010 09:47:17 GMT

Oh Sure...Roland Sir!!

Many Apologies...Pardon.

Re: Dequeue multiple instances of the same lock

Former Member — Mon, 01 Feb 2010 10:02:57 GMT

This is also your final warning!

If you copy&paste again, of answer interview questions with links, or I have to spend more than 1 more minute looking into Abuse Reports about your behaviour... then your user ID will be deleted .

You have been warned plenty of times before!

Julius