×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

This transaction is being edited by another user

This transaction is being edited by another user

This transaction is being edited by another user

(OP)
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.

RE: This transaction is being edited by another user

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.

RE: This transaction is being edited by another user

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.  

RE: This transaction is being edited by another user

(OP)
Thanks a ton, Hamza

RE: This transaction is being edited by another user

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close