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

[Former Member]

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

[former_member201275]

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!

[rosenberg_eitan]

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.

[Former Member]

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.

[former_member201275]

Thanks Eitan. I stand corrected.

[Former Member]

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"?

[Former Member]

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

[rosenberg_eitan]

Hi,

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

and then you can use those in the ENQUEUE function.

Regards.

regards.