190
I keep getting a message "You can't complete this process while transactions are being edited."
This item was just created two days ago, I have had everyone exit this system just in case that was an issue. This item has not been used on any PO, it does not exist in a Kit. Any ideas what this could be?
*This post is locked for comments
Hi awildrick!
Thank you for the update in regards to this issue. Unfortunately as you have already had everyone exit out of Dynamics GP and the issue still occurred it seems as Harry had noted that there could be a stuck user record in some of the Activity tables. Do you have anyone that would be able to run the SQL statements that Harry had posted?
Please keep us posted!
~Thomas Newcomb
------------------------------------
Microsoft Dynamics GP Support
------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Hello!
Is this still an issue or has the information that Harry has posted helped in resolving the issue?
Please let us know!
~Thomas Newcomb
------------------------
Dynamics GP Support
------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Cause
You may have a user locked in a table even though all users are logged out.
Resolution
1. Have all users exit Microsoft Dynamics GP and execute the following query in the SQL Query Tool against the DYNAMICS database (after you make a backup):
delete SY00800
2. Execute the following queries against the Tempdb database:
delete DEX_LOCK
delete DEX_SESSION
KB 864434
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (