Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Posting a Batch Causing "Worldwide Freezing"

Posted on by Microsoft Employee

Hello:

We are on GP 2013 R2, with many international divisions.

Overseas and very early this morning Pacific Time, one of our users posted a batch that--monthly--takes only 2 - 3 minutes to post.  Instead, her posting this batch took nearly 3 hours.

And, while the posting was happening, none of our overseas users could access or use GP.  And, when our East Coast and Central US users reported for work, they could not access GP either.

After the posting process was finished, GP was available for use again and all was well.

Upon first hearing about this early in the morning, I created a new GP user ID for her.  She was then able to post, without causing any issues.  She did have trouble with one batch, but I advised her to review the edit list and if necessary post the transactions individually to see which one is the culprit or move the transactions to a new batch ID for posting.

Our SQL DBA who traced the GP freezing to this user's batch posting suggested, for the next time this happens, implementing a program called "auto cleanup" that would kick a user out of GP and allow for everyone to access GP.

This issue with not being able to access and use GP caused our overseas users to not be able to work and made them miss important deadlines.

Should this auto cleanup program be used?  Has anyone ever heard of it?

If it should not be used, does anyone have any suggestions?  We cannot have this happen, again.

Thanks!

John

*This post is locked for comments

  • CJustin Profile Picture
    CJustin 262 on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Do not use third party auto-cleanup tools. They can not be relied upon.

    Also, the freezing of GP in the other parts of the world where you operate - means that there may be a network connection problem.

    That is what is the issue is most of the times.

    We had used Dynamics 365  GP on our Citrix Virtual Desktop and it worked all well.

    But after a few months, we faced error in the processes of the Citrix.

    Turns out that the Virtual Desktop has to cross through two tiers to gain access to input and output ports.

    And a error in the permissions given to the Virtual Desktops had caused the problem.

    I hope this helps!

    Regards.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Hi Tristan:

    I'm going to leave this Forum question open, for others, in case anyone has additional opinions if that's okay.  :)

    Thanks!

    John

  • Verified answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Glad to be able to help John.  Do you still need help on this topic?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Hi Tristan:

    Thank you, again, for your thoughts.  I'm in agreement with you on auto cleanup.

    John

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Hi John,

    Possibly a corrupt User ID then.  

    However, going back to the "auto cleanup" tool, I am not comfortable using it since it may cause more problems than solutions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Hi There, Tristan:

    Thank you, for the quick response!

    No, our network admins reported that there were no issues.

    All of our users, both in the US and overseas, access GP through the Terminal Server.  And, most of the users access GP through Terminal Server using a tool called "VDI".

    But, our network admins said that there were no issues with VDI and the issue seemed to be GP related.

    The only thing that I knew to do was to create a new user ID for the user, since her ID was "tagged" in SQL to the posting process that was causing GP to freeze and preventing other users from accessing and using GP.

    John

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Posting a Batch Causing "Worldwide Freezing"

    Hi John,

    I would not recommend using this "auto cleanup" tool.  

    There are lots of factors though that could cause the scenario.  One would be a network problem on the workstation who posted the batch (if GP is client-based install).  

    Did the System Admin report anything unusual network wise that day?  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans