What can cause the user automatically be locked in SM12 while nothing happened...

[Former Member]

Hi expert,

We lauched a new platform NWBC(seems another version of GUI) to connect our new financial platform.

But from time to time, the users are locked by themself automatically , without anyting doing /happening.

It is hard to trace since it happens randomly...

I just have no clue where to start the analysis, which part might goes wrong...

It's an annoying situation.

Thank you all for your help.

Kate

[Sriram2009 · Accepted solution]

Hi

1. In this case you can take help with ABAPer find the route case. because from the application site they have check the lock enters type S , E ,X , O

2. Its based on you support package stack level?

3. Kindly refer the some of the link for SM12

SAP Lock Concept - The SAP Lock Concept (BC-CST-EQ) - SAP Library

How to run and understand SAP transaction SM12 | SAP application performance

4. You can enable the ST12 ABAP trace and check where its getting stuck

BR

SS

[Former Member · Accepted solution]

Hi SS,

Thank you very much for reply and sorry for the delay.

And i've still 2 quesitons please,

for your first point, how to decide which coding part cause this problem?

for your second point, why do you think it might related to the SP level

Thank you for the usefull links:)

Kate

[Former Member]

Hi Kate,

When blocked in SM12, is there a table indicated or something? It may be a job running under the user's name also..

Kind regards,

Génia.

[Former Member]

Hi Génia

Thank you for your reply.

No, this could happened to every end user...

Best regards,

Kate

[sivakumar_kilari3]

Hi Kate,

Every end user will call tables ( using transaction codes ) .if you call any transaction code (Instead of program ), The program will call , whatever required tables.

In SAP There is different kinds of table locks is there. You can create Locks through SE11. Like below

When you create lock , It will generate to function modules with table name. find below

Go-----> Lock Modules.

For particular table you want to lock , you have to these function modules

1. ENQUEUE_Name ( This is for table locking)

2.  DEQUEUE_Name. ( This is for lock release

Suppose you have to write code in your ABAP program

If you are inserting data In A table ( you have to call ENQUEUE_Name this Function Module

........ENQUEUE_A ( Calling functional module for locking table A)

Insert data into A table

..............DEQUEUE_A ( Calling functional module for release lock for table A)

The SAP Lock Concept (SAP Library - ABAP Programming (BC-ABA))

Thanks

Siva

[former_member188883]

Hi Kate,

Do you have any SSO configured ? If yes, please investigate whether it is working fine .

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thank you very much for reply and sorry for the delay , since our timezone is different.

And How can i check SSO(single sign on right?)

the user is locked after he signed on it.

Best regards,

Kate