SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

DIR getting Locked during MDT execution

Former Member
0 Kudos

Dear Experts;

In our projects we use Device Infor Records (DIR).During the cretion of technical master data a MDT gets triggered which installs the DIR at the Installation.

We are facing a issue currently in our system.Whenever employee starts the process ,it gives an error message that the Material/Seral Number <DIR No> is locked by the user.

If I execute the process individually on test system it works fine.In production environment whenever there are multiple processed are triggered simultaneously then this problem occurs.

Also occurance of this issue is not consistent ,we get 2-3 such cases per day.

Kindly advice what could be the issue and how we could fix this.

regards,

Sagar

1 ACCEPTED SOLUTION

murtuza_chhatariya
Active Participant
0 Kudos

This issue looks like there are concurrent updates causing locks. Is there any custom code in this process which uses COMMIT command?

If yes then change it to COMMIT WORK AND WAIT and it will stop concurrent updates.

Thanks,

Murtuza

View solution in original post

4 REPLIES 4

murtuza_chhatariya
Active Participant
0 Kudos

This issue looks like there are concurrent updates causing locks. Is there any custom code in this process which uses COMMIT command?

If yes then change it to COMMIT WORK AND WAIT and it will stop concurrent updates.

Thanks,

Murtuza

0 Kudos

Hi Murtuza,

We are using Standard MDT Category : INSTALLATION

Kindly suggest what could be the cause.

Still we are not able to identify the issue.

regards,

Sagar

0 Kudos

In production environment whenever there are multiple processed are triggered simultaneously then this problem occurs.

Multiple means the same process is executed simultaneously? If yes, then it will surely raise problem of Locking, This should be avoided.

Also are you sure that there is no user-exit where custom code is added? As COMMIT commad applies lock on master data and that could be the reason of the issue.

Thanks,

Murtuza

former_member229976
Active Participant
0 Kudos

Hi,

each node of the MDT commits itself, there is no explicite commit needed. Was the DIR created also within the MDT? Did that fail for some reason? And even if using several replication queues from CRM, each DIR should be used only once and by one single process. Or do you store one DIR within several installations/contracts? Normally only one DIR is used and only that particular DIR is touched during MDT processing.

But in order to check the issue, I'd suggest to run a lock-trace (ST01 or ST05) and check which particular lock is not released in time.

Kind regards

Uwe