Before beginning the installation of SP4, I created a backup copy of my current GP installation folder just in case I needed to revert to it, and of course, backed up all forms, reports, and VBA projects, and my DYNAMICS and company databases. I also backed up the registry key corresponding to the GP installation, HKLM > Software > Microsoft > Business Solutions > Great Plains.
The upgrade operation began by launching the Service Pack 4 msp installation file.
After 5 minutes of the "10.0 is being configured on your computer" process, the installation script began "Gatherting required information" to calculate the installation steps required to deal with my environment's configuration.
That went fairly fast, until the progress bar reached 90%. This is when things slowed down again for approximately another 2 minutes.
Once planning phase was up, another progress bar began letting me know that "10.0 is being configured" on my computer, presenting a progress bar with the time remaining.
Approximately 1 second before the "Time remaining" phase was up, I got an error saying "DEX.DIC version 10.0.320 is not compatible with executable version 10.0.324.0".The error showed up one more time and I clicked the OK button to continue. No other indications, except for the message that anything was wrong.
The process went along and completed "successfully" with all service pack files copied into the GP installation folder. All the Dexterity Shared components were replaced.
I then lauched Dynamics Utilities...remember that DEX.DIC error? There it was again! At this point, the only safe recovery option to protect my data's integrity was restoring all previous backups: databases, reports, forms, registry entries, and application folders.
I then downloaded the latest hotfix prior to SP4, 10.00.1328 (KB971014), and repeated the installation process. Everything went fine. I did not receive the pesky Dexterity dictionary version check error, all system and company tables upgraded without a hitch. All my reports and forms upgraded successfully. I noticed the Dexterity dictionary version for this hotfix was 10.0.320. The question now was, would I receive the same error attempting to install SP4?
I repeated all the installation steps I previously described. The good news this time, the installation of the Service Pack 4 components completed without a hitch.
I onced again launched Utilities, this time to upgrade all system and company tables as required. The product validation went on successfully. SP4 rightfully detected the existance of a previous version. I clicked Next to continue with the system database upgrade. This operation completed successfully with the account framework synchronization.
Next was the company update process...this also went substantially smooth and fast. As to the error, I cannot say for sure whether the installation steps call to be on a specific Microsoft Dynamics GP hotfix build prior to beginning the installation of Service Pack 4, or if this is something that is unique to my environment configuration, but at least the word is out. If you find yourself in this situation, you may be forced to upgrade to the latest hotfix prior to the release of SP4 to correct this situation.
There is also another issue with the original Service Pack 4 installation, with SmartList Builder and Excel Report Builder. If you attempt to save a calculation, you will receive the error "Wrong number of arguments to 'Replace_Text'".
Fortunately, all you need to do is download a chunk file and apply to solve this problem. You will find a link to the chunk download by clicking on a link under the Current Release Downloads secition of the Service Pack, Hotfix, and Compliance page.
You are now directed to the error page, where you can download a zip file with the fix, under the Hot Topics area.
Applying the chunk was very simple, but is always recommended that you backup your data.
Chad A., a user on the Dynamics GP newgroup reported having the same problem. This was his reply:
Found the issue! Looks like Microsoft changed the name of the dictionary from dex.dic to dex_us.dic (there is also a dex_int.dic) back in the day. My GP 10 SP3 install had both files (dex.dic and dex_us.dic) at the same version (10.0.320). SP4 upgraded dex_us.dic but didn't upgrade dex.dic. I checked the dynamic.set, dynutils.set, and dex.ini file but didn't see it listed anywhere so I just renamed dex_us.dic to dex.dic. That stoped the error message.Hope you find this response useful.
We started on GP 7.5 way back in the day. I wonder if that name change got
stuck in the system because we upgrade each time.
Microsoft should probably look into this. I will wait a little bit to see if they catch it, otherwise I may have to send an email to some internal Microsoft GP people I know.
Until next post!
Mariano Gomez, MIS, MCP
Maximum Global Business, LLC