Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

GP 18.3 Upgrade Stuck

Posted on by 3,480

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,480 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans