Batch interrupted while transferring from order to invoice

(0) Share

Report

Posted on by Community Member

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 the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you get through with this?

Was this reply helpful? Yes No
Suggested answer

HACKDBA 165 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No