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) / Stored Procedure Error
Microsoft Dynamics GP (Archived)

Stored Procedure Error

(0) ShareShare
ReportReport
Posted on by Community Member

I've seen this type of error a couple of times before, but am not sure what causes it - 'The stored procedure glGetNextJournalEntry returned the following results: DBMS: -127, Microsoft Dynamics GP: 0'.

I can run a trace in SQL, but there doesn't seem to be a pattern to when this occurs.  Has anyone seen these types of errors before?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Shabareesh Profile Picture
    Shabareesh on at

    There was a similar issues seen; The issue, cause & resolution given is below:

    Issues symptom:

    When posting a Miscellaneous Log users are getting the message "The stored procedure glGetNextJournalEntry returned the following results: DBMS: -127, Microsoft Dynamics GP: 0"

    Cause:

    Records stuck in the SY00800 and DEX_SESSION.

    Resolution given

    Make sure everyone is out of GP and run the following:

    We ran this against the Dynamics database

    delete SY00800

    delete SY00801

    delete ACTIVITY

    We ran this against the TEMPDB database

    delete DEX_LOCK

    delete DEX_SESSION

    After this was completed everything posted correctly.

  • Community Member Profile Picture
    Community Member on at

    Thanks so much for the response Shabareesh.

  • Curt W Profile Picture
    Curt W on at

    We just had this happen in our system, we will use this article to help in resolving the issue. In our case the users password expired while they were in GP, and it appears that they tried to post the batch while in that state. I am posting this in case it can help others identify the cause. We will try to resolve this without clearing the tables, and if we can I will post our actions.

  • Curt W Profile Picture
    Curt W on at

    For us, I had the user who was trying to post the batch reset their password in the session they were in. I then had them log out of GP and then back into the system. The user was then able to post the batch without any errors.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans