Sales Batch: " This batch is being edited by another user " Error

(0) Share

Report

Posted on by Community Member

Hello

I've got a Sales Batch that gives " This batch is being edited by another user " error when tried to post.

I can see the same batch in Master Posting Window with its Status 'Busy'. and I cant click on it as it pops up an error message saying you cant change statues because someone else is editing it. but in reality no one is.

I can see the batch in SY00800 table but the user is not actually in the batch even though it shows a Username against it.

When I look in SY00500, I can see the same batch but Status is Already '0'

Now I know that clearing all locking tables will resolve the issue and will release the batch, but i believe this should be done after hours.

My Question is,

Is there anything I can do to release this batch other than waiting till everyone logs off the system?

Can I delete the line in SY00800 ? will that affect anything or resolve the issue?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Sinnerv,

I had a similar problem a few weeks ago and I cleared the record In SY00800 when users were still logged in.This resolved the Issue for me.

Ponguso.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (2)

Report
Copy link

Link copied!

Hi,

I am not sure if removing the line will resolve this, but what I have seen is if the specific user who created the batch, logs on goes into the batch and exits properly the batch becomes available.

Regards,

Rosemary

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for sharing that...

Rosemary

Was this reply helpful? Yes No
Peter Muchira 1,912 on at

Like (0)

Report
Copy link

Link copied!

In addition to the tables above, look for the Batch/User's record in SY00801(Resource Activity). If it is indeed a stuck record, then delete it from that table as well. This way, you won't have to wait for all users to log out of the system. Hope this helps.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I received this SQL query from a colleague. I wish I could remember who it was so I could give them credit. It will tell you who has the record locked:

SELECT 'Sales Documents' AS LockType

, DexSession.sqlsvr_spid

, ISNULL(sysproc.loginame, 'Disconnected') AS LoginName

, SOP10100.SOPNUMBE AS SOPNumber

, CASE SOP10100.SOPTYPE

WHEN 1

THEN 'Quote'

WHEN 2

THEN 'Order'

WHEN 3

THEN 'Invoice'

WHEN 4

THEN 'Return'

WHEN 5

THEN 'Back Order'

WHEN 6

THEN 'Fulfillment Order'

ELSE 'Unknown'

END AS SOPType

, SOP10100.CUSTNMBR AS CustNumber

FROM tempdb..DEX_LOCK DexLock

INNER JOIN tempdb..DEX_SESSION DexSession ON DexLock.session_id = DexSession.session_id

INNER JOIN SOP10100 ON DexLock.row_id = SOP10100.DEX_ROW_ID

LEFT OUTER JOIN master..sysprocesses sysproc ON DexSession.sqlsvr_spid = sysproc.spid

WHERE DexLock.table_path_name = RTRIM(DB_NAME()) + '.dbo.SOP10100'

Kind regards,

Leslie

Was this reply helpful? Yes No
Jim Schindler 5 on at

Like (0)

Report
Copy link

Link copied!

Since you are confident that the user is not actively working with the batch in any way. You can delete the records. See KB article reference below.

support.microsoft.com/.../850289

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The suggestion to have the user that created the batch, logon, go into the batch and exit gracefully - that worked for me. Thanks.

Was this reply helpful? Yes No