This transaction is being edited by another user 1

[hamzajosh]

I am trying to go into an order in SOP which keeps saying "This transaction is being edited by another user" I asked all users to logout and still the same error. I also ran checklinks but still the same. How can i unlock this record from the database i.e. which table and fields stores this info of the record being locked, so i can reset it if possible. Please help, thanks.

 

[dmuerhoff]

I cannot remember the exact SQL statement to run as I do not work with SOP anymore. However, this is a common problem with SOP and you will encounter it in the future. I believe there is an automated fix you can run from Great Plains website.

 

[Luvsql]

To fix this run the following against the DYNAMICS database (make sure users are out):

DELETE SY00800

Then run this on tempdb:

DELETE DEX_LOCK
GO
DELETE DEX_SESSION
GO

This should make it available again. If not, there are also a couple of fields in the SY00500 table that you may have to update.

 

[hamzajosh]

Thanks a ton, Hamza

 

[hamzajosh]

LuvSQL, I have the same problem again. I did what you mentioned above. The three tables are empty yet I have a purchase order locked, giving the same error " this transaction is being edited by another user" What fields would i have to change in SY00500 as per your above pots. Please help