web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I restart a co...
Microsoft Dynamics GP (Archived)

How can I restart a company upgrade in GP Utilities?

(0) ShareShare
ReportReport
Posted on by Chris Adaline 215

I'm trying to upgrade GP 10 from sp3 to sp4 and when GP Utilities was upgrading my main company database it errored out.  I tried fixing the problem and re-running the company upgrade, but GP Utilities thinks the upgrade completed.  Is there a flag I can flip somewhere so GP Utilities will think the company needs to be upgraded?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    David V Profile Picture
    David V 270 on at
    Re: How can I restart a company upgrade in GP Utilities?

    GP checks out the Dynamics..DB_Upgrade table and the DYNAMICS..DU00020 table to look for incompatible versions.  I would scan through there and check the version number on login.  Just want to make sure the upgrade didn't really complete.

    There's some ideas in KB 920900 about updating  the PRODID field in these tables to have GP believe it's a prior version.  If you have a backup of these tables in the Dynamics database it might be possible to make the tables in the KB match pre-upgrade versions and then relaunch GP Utilities normally.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    Re: How can I restart a company upgrade in GP Utilities?

    David is correct in that, when upgrading from one build to another build as in this case for Dynamics GP 10.0, once the upgrade gets past the table update, if it fails after that, it will update the DU000020 table to show the database as upgraded, even though it hasn't. The DB_Upgrade table will still show the database as in the process of upgrading.

    Using the 'old' version of GP 10.0 that you are coming from, edit the DU000020 table for the PRODID of 0 (Microsoft Dynamics GP) for this specific company database to show it at the 'old' version again.

    If that doesn't work, you can use these scripts as well: (Make sure we have backups)

    1. Delete DYNAMICS..DU000020 where PRODID <> 0 and companyID = X

    2. Update DYNAMICS..DU000020 set versionMajor = 10, versionBuild = #### where companyID = X

    ***Replace X with the actual companyID for the database failing the upgrade and #### with the version build number that you are upgrading FROM.

    Also, if there are records for any tables failing the upgrade in the DU000030 table, Utilities will not attempt to re-upgrade those tables unless the record is removed from this table. To do this, you can use this script:

      Delete DYNAMICS..DU000030 where Status <> 0 and Status <> 15

    KB 920900 really won't work in this case as that article is more for when upgrading from one version to another, such as 9.0 to 10.0 or 9.0 to GP 2010.

    Thank you

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans