Notifications
Announcements
No record found.
I just started updating the DYNAMICS database in GP Utilities after installing the year-end update from 18.3.1200 to 18.4.1384, and immediately ran into a table error.
Has anyone run into this, and know the most appropriate way to proceed?
Hi,
This looks like a failed attempt to run the GP upgrade.. I hope you have a full backup taken before you started?
Please restore the DYNAMICS database and every company DB that might have been upgraded (or attempted) to go back to the old version 18.3.1200.
After that, I'd run the ClearCompany.sql script that you can find on the Microsoft site, as it looks like you might have had companies that got deleted in SQL, but are still showing up in the Company master table and elsewhere in the DYNAMICS system DB.
Once the script was executed and returns no error, try to upgrade again. This upgrade should run smoothly as I just completed one with the same versions yesterday.
Hi Beat,
Thank you for the reply. I restored the DYNAMICS database, and ran the clear companies script. I got the same error. However I did notice that now getting the error, the Company Detail screen shows BOTH the Current Version and the New Version being 18.4.1384. Do you know if there is somewhere in the DYNAMICS database that I might need to update the Current Version to roll back to 18.3.1200?
There are multiple places where the GP version is stored in the DYNAMICS DB..
DB_Upgrade & DU000020 are the most prevalent ones.
But you should take a look at this KB post that might help to pinpoint the problem.
support.microsoft.com/.../how-to-restart-the-upgrade-of-a-company-database-in-microsoft-dynamics-gp-8b616876-e2cf-7d1e-edaf-2939015efc20
Of course this is old and you may need to adjust the queries.
Here is something more recent:
community.dynamics.com/.../microsoft-dynamics-gp-upgrade----upgrade-troubleshooting-1749838885
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
