topic Re: Lock Error with BAPI call in Application Development and Automation Discussions

Lock Error with BAPI call

Former Member — Wed, 20 May 2009 11:26:27 GMT

Hi all,

We are using the BAPI call to the FM BAPI_GOODSMVT_CREATE for goods recipt posting.

When we have multiple PO's the first PO is posted succesfully and the next PO gives a locking error as "The plant data of the material <material number> is locked by the user <usedrid> "

How to dequeue the plant data for the material? Is there any specific function module ?

Regards,

stk

Re: Lock Error with BAPI call

former_member188827 — Wed, 20 May 2009 11:28:13 GMT

use fm 'DEQUEUE_ALL' after bapi call

Re: Lock Error with BAPI call

tarangini_katta — Wed, 20 May 2009 11:29:48 GMT

Hi stock.

try this.

DEQUEUE_E_MATNR_LOCK

if does not work serch in SE37 DEMATNR*.

U will get so many function modules.May be some thisng will help u

Thanks

Re: Lock Error with BAPI call

Former Member — Wed, 20 May 2009 12:00:30 GMT

Hi ,

Both DEQUEUE_E_MATNR_LOCK and DEQUEUE_ALL doesnt remove the lock...

But when i check the program in debug mode the lock is removed and the posting is done.

still problem persists.

thnks

Re: Lock Error with BAPI call

Former Member — Wed, 20 May 2009 12:06:47 GMT

Your BAPI sets a lock using ENQUEUE. Using debug or just looking at the code, (or I think there is a trace somewhere), you can find the FM used to do the ENQUEUE. What you need to do, is in a loop, try to get the same lock, using the same ENQUEUE function module. If you can't get a lock, then it means that BAPI processing hasn't quite finished. So use FM Enque_Sleep to sleep for a number of seconds. Then try and get a lock again.

When you get a lock, immediately release it (Using a DEQUEUE FM with exactly the same params, and do your next task.

Don't use DEQUEUE_ALL. You don't want to inadvertantly remove a lock that you actually need. That way lies db corrupution.

Re: Lock Error with BAPI call

Former Member — Mon, 29 Jun 2009 07:03:31 GMT

Called BAPI_TRANSACTION_COMMIT after the posting BAPI call.

Re: Lock Error with BAPI call

Former Member — Fri, 05 Feb 2010 21:42:54 GMT

hi, can you give me code example of it....??

table S021 no update after bapi commit..