Batch activity table error message

(0) Share

Report

Posted on by Community Member

Hello,

I have a question about an error message that a user received earlier. It comes up with a unable to save batch activity table error when trying to add to the report. I am very new to dynamics so I don't know if this is a simple fix or something more serious. Any help would be greatly appreciated. Thank you much

*This post is locked for comments

I have the same question (1)

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report

Hi TazMan1 - Which version of Dynamics GP are you seeing this error in?

Was this reply helpful? Yes No
Verified answer

mwiley 170 on at

Like (0)

Report

This table is SY00800 (DYNAMICS database) - there is a record in that table that is locking the batch. You probably can delete the table and run checklinks to recreate the record. Make a backup first.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

In addition to mwiley's good advice, I also recommend making sure everyone exists the system before deleting a table. My personal preference would be to simply delete the errant record using SQL, then everyone could stay on-line and no utilities would be necessary.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello!

It looks like mwiley and Leslie provided you with the resolution. Clearing the activity and batch tables is usually recommended per KB 850289:

850289 A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

vkbexternal.partners.extranet.microsoft.com/.../ViewContent.aspx

I will set this post to closed today.

Best regards,

Dan Moore

Customer Online Technical Community

-----------------------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No