Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Joel Fox]

Trying to install the Year end Update

 After running “MicrosoftDynamicsGP18-KB4602593-ENU.msp”. it completes just fine.

 I run “GP Utilities” and it sees a previous version and wants to proceed with the upgrade.

It does the upgrade to the DYNAMICS DB but when its tries to do the company DB’s I get the waring that I am trying to install an older version and it won’t go any farer.

I checked the upgrade table, and it shows that the DYNAMICS database has been upgraded to the correct version and it shows all the company databases on the older version.

 Select * from DYNAMICS..DB_Upgrade where PRODID=0

 Company1                         0              18           4              1384       18           4              1384

DYNAMICS                        0              18           5              1596       18           5              1596

 

 

No clue on what my next steps would be?

——————————
Joel Fox
MIS Supervisor
Nevada Restaurant Services Inc. DBA Dotty’s
North Las Vegas NV
——————————

[Kerry Hataley]

Hi Joal,
I hope this is in a test environment…
I have seen this only once and the fix I did was to run the Oct 2022 release first (KB4602589) then run the Dec release (KB4602593).
You will need to restore from backup.

I think it had something to do with HR/PR modules that went back to Integrity Data.
Let me know if that helps…

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Joel Fox]

Yes this is on my test system that is virtual.   I reverted it back to before anything was done.   I ran the “MicrosoftDynamicsGP18-KB4602589-ENU.msp” it completes just fine.  I run “GP Utilities” and it sees a previous version and wants to proceed with the upgrade. It does the upgrade to the DYNAMICS DB but when its tries to do the company DB’s I get the waring that I am trying to install an older version and it won’t go any farer again.

 

db_name            PRODID               db_verMajor     db_verMinor     db_verBuild       db_verOldMajor                db_verOldMinor              db_verOldBuild                 db_status

DYNAMICS            0                              18                           5              1556                        18                                           5                                      1556                          0

Company1             0                              18                           4              1384                         18                                           4                                     1384                           0

 

I reverted it again and ran check links on all companies for the System and Company series and then did the upgrade again with the same results. 

 

Any other suggestions?

 

——————————
Joel Fox
MIS Supervisor
Nevada Restaurant Services Inc. DBA Dotty’s
North Las Vegas NV
——————————
——————————————-

[Kerry Hataley]

You need to dig into and see if the 18.4.1384 actually finished…
From C:Program Files (x86)Microsoft DynamicsGPData go through the file duinstall.log, find the start of the last upgrade and then see if anything didn’t work or finish…
You could try running KB4576803 – is also 18.4.1384 but with Dec 22 date (Canadian Tax Table update) but still valid for all users or try KB4576805 from Jan 2022 and see if they pass…
Also look at all products in the DB_Upgrade table, not just 0, the error is not specifically just for product 0.

I know for a systems verification and audit control this file is very important…
My upgrade steps include:
1. Before start of upgrade, Copy Current duinstall.log and archive with date
2. Delete the file duinstall.log – This allows for a clean file to examine after upgrade
3. Review duinstall.log after upgrade and verify no issues
4. Copy and Archive duinstall.log after verification

Kerry

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Joel Fox]

Renamed duinstall.log

Installed MicrosoftDynamicsGP18-KB4576803-ENU.msp and ran GP Utilities.  It did not see any difference in versions and a new duinstall.log was not created.

Installed MicrosoftDynamicsGP18-KB4576805-ENU.msp and ran GP Utilities.  It does see it has a new and is starting the upgrade of the companies databases.  It also recreated the duinstall.log.  it will take a while to complete and I will post results later today.

 

After the upgrade to MicrosoftDynamicsGP18-KB4576805-ENU went well and everything look fine I tried to do the MicrosoftDynamicsGP18-KB4602593-ENU upgrade and ended up with the exact same errors and messages.  I am opening a ticket with Microsoft and will see what they have to say.

 

 

——————————
Joel Fox
MIS Supervisor
Nevada Restaurant Services Inc. DBA Dotty’s
North Las Vegas NV
——————————
——————————————-