web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do you clear out a...
Microsoft Dynamics GP (Archived)

How do you clear out a glpbBatchCleanup error for good?

(0) ShareShare
ReportReport
Posted on by Angela Furney 330

Hello,

I have a customer who is getting the same error message every 3 - 4 months.

The message is "The stored procedure glpBatchCleanup returned the following results: DBMS: 0, Microsoft Dynamics GP: 20488.  More Info shows: glpBatchCleanup.  Eorror occurred attempting select from Batch_Headers.

We have gone through cleaning up the activity table, cleaning the batch tables, dex_session and dex_locks.  We have rebuilt the modified reports dictionaires both by exporting package files, deleting dic's and reimporting as well as renaming dic's and reimporting directly from Report Writer.  The last time this happened was in Dec and I rebuilt the stored procedure.

Now almost four months later to the date we are having the same error.  My client is running GP 10.0.1634.  I can trace this issue back as far as May of 2010, so this has been happening for a year.  We keep putting this bandaid on it and I would like to find a way to resolve for good.  This client is in a RDS environment with three RDS servers.

*This post is locked for comments

I have the same question (0)
  • Santosh Profile Picture
    Santosh 766 on at

    Hi,

    Try this KB article.

    mbs.microsoft.com/.../KBDisplay.aspx$en-us$860710&wa=wsignin1.0

    Regards,

    Santosh

  • Angela Furney Profile Picture
    Angela Furney 330 on at

    thanks for the information.  We have used that KB article before and I infact did this again last evening and the customer is still having the error.  Last time this happened we also rebuilt the stored proc and it continues to break.

    Any other ideas?

  • Hernan Batista Profile Picture
    Hernan Batista 930 on at

    Anybody has idea how fix this issue? I have the same problem

  • Angela Furney Profile Picture
    Angela Furney 330 on at

    I ended up working directly with Microsoft Dynamics GP support and we came up with this resolution:

    Logged into GP as SA and go to File>Maint>SQL, select the company and choose the Posting Definitions Master.  I then marked all checkboxes on the right side and chose Process.

    Next was to run check links:

    • Series name: Purchasing

    File name: Purchasing Series - Payables Transaction Logical

    File name: Purchasing Series - Purchasing Transactions

    • Series name: Sales

    File name: Sales Series - Receivables Open Transaction

    File name: Sales Series - Invoice Work File

    File name: Sales - Sales Work File

    • Series name: Inventory

    File name: Inventory - Inventory Transaction Work file

    File name: Inventory - Inventory - Bill of Materials Transactions file

    and lastly to run Financial Batch Reconcile:

    If any batches exist in Microsoft Great Plains General Ledger, click Tools , point to Utilities , point to Financial , and then click Reconcile . Click Batches , and then click Reconcile to reconcile your batches.

    Since running this process the customer has only had the error come up once in 6 months.  This is much better than every 3 - 4 months, but I would like to know why it keeps happening.

  • Community Member Profile Picture
    Community Member on at

    Check table SY00500 and look for a bachnumb that is blank.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans