Finance | Project Operations, Human Resources, ...

Company Master table error just starting Year End update in the DYNAMICS database

(0) Share

Report

Posted on by Baycare Health Systems

439

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?

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Sort by

Suggested answer

Beat Bucher GP Gee... 28,069 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
Baycare Health Systems 439 on at

Like (0)

Report
Copy link

Link copied!

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?
Suggested answer

Beat Bucher GP Gee... 28,069 Moderator on at

Like (0)

Report
Copy link

Link copied!

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