Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table data getting locked for multiple user for a Z-table updation after EH4 to EHP6 Upgrade

Former Member
0 Kudos
382

Hi,

We have one new upgraded system at EHP6, earlier system was at EH4 where multiple user can Run one Z  T-code and can edit the entries for the Z-table.

This Z-Tcode is calling SM30 internally for updating the Z-Table.

Now in the upgraded system, when one user is into the transation code, and other user runs that T-code, systems throws a POP-UP mesg saying that the data is locked and can be displayed only(can not be edited).

I have debugged the code in both the environment and found that there is one statement Call C_ENQUEUE ID < > field. for which the Sy_Subrc is coming as 2 in the upgraded system which is causing the issue, where as the sy-subrc is 0 in the system at EH4 level.

Can any body tell me why this Z-tcode is not allowing to be accessed by multiple user at same time for Editing(updating the table) .

Regards,

Archana Jha


8 REPLIES 8

former_member201275
Active Contributor
0 Kudos
159

I don't understand how it was ever possible for more than one user to update the same table at the same time, in any environment!

0 Kudos
159

Hi,

It is possible for multiple user to update the same file.(This is normal in SAP) .

The lock object needs to be implemented on a record key level and not on a table level.

The is part of the applications that update this file .

Regards.

0 Kudos
159


Hi Glen,

It is still working (Allowing for new entries and updating) for multiple user at the same time in the sytem available with us which is at EhP4. Now this new system at EHP6 is having this issue and giving a POP-UP.

0 Kudos
159

Thanks Eitan. I stand corrected.

0 Kudos
159


Hi Eitan,

Can you please let me know how to implement the below ?

"The lock object needs to be implemented on a record key level and not on a table level"?

0 Kudos
159

0 Kudos
159

I wouldn't stand too corrected if I were you Glen.  While it is entirely possible to implement row level locking on a table, this is not the standard behaviour of the Table Maintenance Generator that would be used to maintain the table from SM30.

If Archana's Z-tranaction maintains the z-table using the TMG the way it's working in EHP6 then the locking is working exactly as I would expect.  Archana, can you elaborate if there were any modifications or exits in getting this working in EHP4?

Regards,

Nick

0 Kudos
159

Hi,

When you create the lock object you can define the keys.

and then you can use those in the ENQUEUE function.

Regards.

regards.