Cannot delete empty batches, "being edited by another user"

(0) Share

Report

Posted on by TGcville@gmail.com

375

I have a handful of empty batches, all the same user, that have zero transactions, yet cannot be deleted due to the error message, "Being edited by another user." Any way to delete these?

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Sort by

TGcville@gmail.com 375 on at

Like (0)

Report
Copy link

Link copied!

Also, they do not appear in the "Series Posting" window, nor the "Batch Recovery" window.

Was this reply helpful? Yes No
TGcville@gmail.com 375 on at

Like (0)

Report
Copy link

Link copied!

And, I tried deleting them from the user that created them.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Try this

www.sanjaykumar.us/.../this-batch-is-being-edited-by-another-user

Cheers!

Sanjay

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!
Run the following update to change the status of the batch (to get it released) after ensuring that no user is already opening the batch

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB='XXX'

Now, you must be able to see the batch on the batch window, and delete it safely.

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

With all users out the system, run the following against your environment:

USE DYNAMICS;

GO

DELETE FROM ACTIVITY;

DELETE FROM SY00800;

DELETE FROM SY00801;

GO

USE tempdb;

GO

DELETE FROM DEX_LOCK;

DELETE FROM DEX_SESSION;

You should be able to return to GP and remove the empty batches.

Was this reply helpful? Yes No
TGcville@gmail.com 375 on at

Like (0)

Report
Copy link

Link copied!

From my reading, this would probably fix my issue, however I have no clue as to where to begin? I am an end user, not a Partner. Would this be done on the server through MS SQL exchange?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

You will need to run this scripts at SQL Server query analyzer. You will need appropriate access and permission to execute this script. Would recommend if you have never done this before, contact your DBA.

Cheers!

Sanjay

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

So long you have Microsoft SQL Server Management Studio (there's no such thing as MS SQL Exchange. There's SQL Server and then there's Exchange Server) running on a machine and can access (as in having permission) your SQL Server, you should be able to do this.

I strongly suggest you contact your partner or get a hold of your DBA to run the above script.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

Nothing more valuable to add for Mr. Mariano's comments except that this must be on the top ten list of the most FAQ in Dynamics GP.

Just to include the documentation of this error on Microsoft Support Knowledge base, Article ID: 850289

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

Thanks for pointing this out Mahmoud. There's a Microsoft Fix It! that is a part of the KB article Mahmoud has directed you to and this Fix It! should take care of the problem without the need of running SQL scripts (technically, it does the same in the background).

Was this reply helpful? Yes No