Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

GP 18.3 Upgrade Stuck

Posted on by 3,482

Hi:

For 18.3.1245, the first GP company upgrade winow is blank for both table and company update progress.  There is no blue progress bar.  No table is specifically listed.  It seems stuck.

How do I get the upgrade moving?  Are there scripts that I can run?

John

Categories:
  • Suggested answer
    RE: GP 18.3 Upgrade Stuck

    Hello John, I was just going to add, it is normal for GP Utilities to show a blank screen during the upgrade and/or show the list of upgrade steps with a progress bar that doesn't seem to move......it'll be like that until it gets down later in the upgrade where it is doing the 'Load Stubs', 'Load Views', 'Load Triggers', part of the upgrade where it is less demanding on resources and it is simply dropping and re-creating objects.

    The bad thing is, there isn't really any way to see what progress is being made by the GP Utilities until it snaps out of the 'Not Available' or blank screen.

    We usually mention looking in Task Manager to make sure the SQL Server has activity to show processing is being done.

    A dexsql.log would also show us, but that will drastically slow down the upgrade itself, so we don't recommend it unless you're actively troubleshooting an issue with the upgrade or Dynamics GP.

    Worst case scenario, you can 'kill' GP Utilities via Task Manager, then truncate the duLCK system table and launch GP Utilities again, as it is smart enough to pick up relatively where it left off.

    Again, this won't resolve the 'Not Responding' and/or blank GP Utilities window, but it is normal.

    As well, after the upgrade finishes with the system and company databases upgrade, it may go to another window where you have the option to update SQL SRS reports and/or Excel reports.  It is also common for this window to freeze showing a Next button that you cannot click, or a blank window that shows nothing at all.  When this occurs, I usually recommend 'killing' GP Utilities again, and then re-launching GP Utilities after truncating the duLCK system table, to make sure the upgrade has completed successfully.

    Hope this helps for the next time.

    Have a great day.

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: GP 18.3 Upgrade Stuck

    disregard....restored backup

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans