topic Re: Trying to read locks using function: ENQUEUE_READ not returning results. in Application Development and Automation Discussions

Trying to read locks using function: ENQUEUE_READ not returning results.

lisa_gravito — Wed, 09 Apr 2008 18:48:33 GMT

Hi,

I am attempting to read user locks programmatically by calling the function: ENQUEUE_READ. This however is not working. Has anyone successful read locks using this FM?

Piece from my function module

checking to see if user has a BPS BSP layout lock

CALL FUNCTION 'ENQUEUE_READ'

EXPORTING

gclient = sy-mandt

gname = 'UPC_YS_LOCK'

guname = sy-uname

IMPORTING

number = l_num

TABLES

enq = l_enq.

Thank you!

~ Lisa

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

Former Member — Wed, 09 Apr 2008 19:41:26 GMT

How did you know it's not working?? Is it giving any exception..check sy-subrc value and post back!!

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

lisa_gravito — Wed, 09 Apr 2008 19:49:43 GMT

I checked SM12 to ensure I had locks, called ENQUEUE_READ and parameter: l_num returned 0. (I had 2 locks)

After I check the locks, I need to be able to log those user out if they in fact have locks...

log user off if lock exists

IF l_num > 0.

CALL FUNCTION 'TH_DELETE_USER'

EXPORTING

user = sy-uname

client = sy-mandt.

ENDIF.

Perhaps I'm using the wrong elementary ock (UPC_YS_LOCK)?

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

Former Member — Wed, 09 Apr 2008 19:51:57 GMT

Hi Lisa,

Your code looks perfect. I think it is an authorization issue. Check you have proper authorization to execute that Function Module as this is related to Security.

Thanks,

Greetson

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

lisa_gravito — Wed, 09 Apr 2008 19:54:01 GMT

Will do! I'll let you know whether I don't have the proper authorizations or not...

~ Lisa

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

Former Member — Wed, 09 Apr 2008 20:01:02 GMT

SImply pass client and that's it ...

'UPC_YS_LOCK' is table name on which locks exist..if any entry of this table is not being edited currently..then it will not return anything...

CALL FUNCTION 'ENQUEUE_READ'

EXPORTING

gclient = leave blank if you want locks across the system

gname = table name which is locked/leave blank

guname = leaveblank

IMPORTING

number = l_num

TABLES

enq = l_enq.

If you want to see it work then simply pass the table name you see in sm12..

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

lisa_gravito — Wed, 09 Apr 2008 20:09:52 GMT

I ran the function without the table name and l_num was populated!

It makes sense that the table would only be populated with a lock if entries were being edited.

Thanks for your help guys!

~ Lisa Gravito

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

Former Member — Wed, 09 Apr 2008 20:12:53 GMT

You forgot about our incentives?? OUR POINTS??

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

lisa_gravito — Wed, 09 Apr 2008 20:17:22 GMT

Sorry! 1st time posting. Please let me know if I've now rewarded the points correctly.

Edited by: Lisa Gravito on Apr 9, 2008 3:18 PM

Re: Trying to read locks using function: ENQUEUE_READ not returning results.

Former Member — Wed, 09 Apr 2008 20:20:26 GMT

Thanks!!