topic Re: Table level lock not working in Application Development and Automation Discussions

Table level lock not working

former_member212001 — Tue, 21 Jan 2014 03:19:31 GMT

Hi,

Row level locking by creating lock objects is working but entire table level locking is not working.

I have used Function module ENQUEUE_E_TABLE and DEQUEUE_E_TABLE which is not working for locking the entire table

Since I am doing insertion alone in the table always.

Please let me know if any function module exists.

Thanks & Regards,

Priya

Re: Table level lock not working

ramkumar007 — Tue, 21 Jan 2014 04:27:08 GMT

Hi,

Type the action is E.

Thanks

RAM

Re: Table level lock not working

former_member187748 — Tue, 21 Jan 2014 04:35:38 GMT

Hi Priya,

while calling both ENQUEUE_E_TABLE and DEQUEUE_E_TABLE

Please modify your entries as shown in this link

Re: Table level lock not working

former_member212001 — Tue, 21 Jan 2014 05:43:57 GMT

Hi Ram,

Even after passing action as E, its same.

After executing function module, sy-subrc eq 0 ( its enqued ) but diectly able to add entries in table in other session.

@Sanjeev,

row level locking is working.

but i need table level locking.

Re: Table level lock not working

Former Member — Tue, 21 Jan 2014 05:57:23 GMT

Hi Priya,

It should work in this way!

call function 'ENQUEUE_E_TABLE'
         exporting
           mode_rstable   = 'E'
           tabname        = p_table
         exceptions
           foreign_lock   = 1
           system_failure = 2
           others         = 3.

       if sy-subrc = 0.

*       Modify the database table with these changes
         modify (p_table) from table <dyn_tab_temp>.

         refresh <dyn_tab_temp>.

*       Unlock the table
         call function 'DEQUEUE_E_TABLE'
           exporting
             mode_rstable = 'E'
             tabname      = p_table.

       endif.

Re: Table level lock not working

former_member212001 — Tue, 21 Jan 2014 06:13:41 GMT

Hi Kiran,

I have followed the same thing but not working.

after 'ENQUEUE_E_TABLE'

In if sy-subrc = 0. ( yes sy-sub rc is 0)

In another session I have opened the table in SE 11 , Utilities -> Table contents -> Create entries

Its allowing to create entries eventhough dequeue is not executed.

Please let me know if am doing wrong.

Re: Table level lock not working

Former Member — Tue, 21 Jan 2014 06:34:04 GMT

Hi,

tested, it is working fine for me! cehck the table name, how you are passing

call function 'ENQUEUE_E_TABLE'

exporting

mode_rstable = 'E'

tabname = 'ZAAK_CONTACTS'

exceptions

foreign_lock = 1

system_failure = 2

others = 3.

Re: Table level lock not working

narendar_naidu — Tue, 21 Jan 2014 06:37:52 GMT

hi Priya,

U tried to check or you actually created an entry. if not try creating bcoz it shud work.

regards,

Re: Table level lock not working

former_member212001 — Tue, 21 Jan 2014 06:48:27 GMT

Hi Karan,

CALL FUNCTION 'ENQUEUE_E_TABLE'
EXPORTING
   MODE_RSTABLE         = 'E'
   TABNAME              = 'ZMM_KANBAN_HIST'
*   VARKEY               =
*   X_TABNAME            = ' '
*   X_VARKEY             = ' '
*   _SCOPE               = '2'
*   _WAIT                = ' '
*   _COLLECT             = ' '
EXCEPTIONS
   FOREIGN_LOCK         = 1
   SYSTEM_FAILURE       = 2
   OTHERS               = 3.

IF sy-subrc EQ 0.

      refresh gt_zmm_kanban_hist.
      CLEAR gs_zmm_kanban_hist_c.
      SELECT * FROM zmm_kanban_hist
             INTO TABLE gt_zmm_kanban_hist.

      IF sy-subrc EQ 0.
        SORT gt_zmm_kanban_hist BY zrecord DESCENDING.
        CLEAR gs_zmm_kanban_hist_c.
        READ TABLE gt_zmm_kanban_hist INTO gs_zmm_kanban_hist_c INDEX 1.
        IF sy-subrc EQ 0.
          gs_zmm_kanban_hist-zrecord = gs_zmm_kanban_hist_c-zrecord + 1.
          INSERT zmm_kanban_hist FROM gs_zmm_kanban_hist.
        ENDIF.
      ELSE.
        gs_zmm_kanban_hist-zrecord = 1.
          INSERT zmm_kanban_hist FROM gs_zmm_kanban_hist.
      ENDIF.

CALL FUNCTION 'DEQUEUE_E_TABLE'
EXPORTING
   MODE_RSTABLE       = 'E'
   TABNAME            = 'ZMM_KANBAN_HIST'.
*   VARKEY             =
*   X_TABNAME          = ' '
*   X_VARKEY           = ' '
*   _SCOPE             = '3'
*   _SYNCHRON          = ' '
*   _COLLECT           = ' '

ENDIF.

I have used the same like you but am not getting popup with locked message.

Re: Table level lock not working

former_member212001 — Tue, 21 Jan 2014 06:56:43 GMT

Hi Kiran,

Created entry with my code changes.

In another session ,

Utilities -> Table contents -> Create entries

Its allowing to create entries even dequeue function module is not executed.

Re: Table level lock not working

Former Member — Tue, 21 Jan 2014 07:02:50 GMT

Hi Priya,

Please follow what ever is suggested by Kiran Kumar. Once you have locked, I suggest you to try closing all other sessions and reopen a new session or even try logging off and logging in.

Hope this helps!

Happy Coding,

Santhosh Yadav

Re: Table level lock not working

nabheetscn — Tue, 21 Jan 2014 07:15:50 GMT

Hi Priya

When you execute your program did you put a breakpoint at sy-subrc if it returns zero then you open another session and try to maintain entry it will show error

Nabheet