Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum (Archive) / How do you clear out a...
Microsoft Dynamics GP forum (Archive)

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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How do you clear out a glpbBatchCleanup error for good?

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

  • Angela Furney Profile Picture
    Angela Furney 330 on at
    Re: How do you clear out a glpbBatchCleanup error for good?

    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.

  • Hernan Batista Profile Picture
    Hernan Batista 930 on at
    Re: How do you clear out a glpbBatchCleanup error for good?

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

  • Angela Furney Profile Picture
    Angela Furney 330 on at
    Re: How do you clear out a glpbBatchCleanup error for good?

    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?

  • Santosh Profile Picture
    Santosh 766 on at
    Re: How do you clear out a glpbBatchCleanup error for good?

    Hi,

    Try this KB article.

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

    Regards,

    Santosh

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Moderator

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans