Batch interrupted while transferring from order to invoice, now 2 of the orders keep saying they being edited by another user, I even ran the below script
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='EOS1608151030JH'
But still it says its being edited by another user.
*This post is locked for comments
I have also had this occur. Below is the email I sent myself that I used to resolve the issue.
I got the issue resolved. So I noticed USER1 has the only PM batch open. So I ran the following steps to determine who might have the stuck record open which was causing USER2 the problems in her batches.
--Step 1 – Get the SQLSESID from the Activity Table
SELECT [USERID]
,[CMPNYNAM]
,[LOGINDAT]
,[LOGINTIM]
,[SQLSESID]
,[Language_ID]
,[DEX_ROW_ID]
FROM [DYNAMICS].[dbo].[ACTIVITY]
GO
--Step 2 – Look to see who’s session id has dex rows in the temp table and take note of it.
USE tempdb
SELECT [session_id]
,[sqlsvr_spid]
FROM [tempdb].[dbo].[DEX_SESSION]
GO
--Step 3 – See exactly what session id has an exclusive lock in the Dex_Lock temp table and in this instance user1 was the only user.
USE tempdb
SELECT [session_id]
,[row_id]
,[table_path_name]
FROM [tempdb].[dbo].[DEX_LOCK]
GO
Based on all of that I conclude the only person who had anything PM related open was USER1. I asked her to log out and ran step 3 again with no entries in the table. I then had USER2 log in and see if she got the error. She did not.
Check the DYNAMICS..SY00800 table. If it has a record in there is thinks it is being edited by another user. Simply delete the record for that transaction and it will free it it.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
