Announcements
I am upgrading from 2015 (14.00.1430) to 18R2 with year end installed. ( I already performed exactly same upgrade (same versions) for another installation without any issue)
When running utilities I am getting the following error.
Failure encountered ON 11/10/2020 at 8:51:48 PM. Error: Product 1911 does not support upgrading from version 10.0.31.
Failure encountered ON 11/10/2020 at 8:51:48 PM. Error: Product 4522 does not support upgrading from version 10.0.45.
Failure encountered ON 11/10/2020 at 8:51:48 PM. Error: Product 4933 does not support upgrading from version 10.0.78.
Failure encountered ON 11/10/2020 at 8:51:48 PM. Error: Product 4955 does not support upgrading from version 10.0.94.
Thanks for your assistance.
That would be rather scary to have the DYNUTILS.SET file be different than the DYNAMICS.SET but it can happen.
I'm curious whether we removed the HR/Payroll Suite (which is what these four modules are a part of) through Control Panel > Programs and Features, which would remove the dictionary files from the GP directory for these four modules, as well as remove them from the Dynamics.set and the DynUtils.set.
If not, we may've forgot to remove them from the DynUtils.set, which is what GP Utilities actually looks at, to determine what products are installed and need to be upgraded.
I'm happy to hear the upgrade did go through.
Glad you got it to upgrade. I am also surprised that GP was trying to upgrade those products despite the fact that they were not in your set file.
Thank you for all your assistance.
I restored a new copy of the database and started all over again.
After removing the records - I still got the error.
Not sure what was going on. Just to double check I ran a select query and there were still records in the DB_Upgrade Table. It turns out the some of the values in DB_Upgrade are Text values so I reran the delete query with the quotes around the prodid's verified that they were gone.
And sure enough I was able to go run the Utilities.
I was deleting the products as
Delete DYNAMICS..DU000010 where PRODID in (6499,1911,4522,4933,4955)
Delete DYNAMICS..DU000020 where PRODID in (6499,1911,4522,4933,4955)
Delete DYNAMICS..DB_Upgrade where PRODID in ('6499','1911','4522','4933','4955')
Delete DYNAMICS..DU000030 where PRODID in (6499,1911,4522,4933,4955)
Again really appreciate your time.
I do not see any of the product IDs you originally mentioned in this set file. Is the the set file from the same computer you are trying to upgrade?
Here you go!
29
0
Microsoft Dynamics GP
105
IntegrationManager
309
Fixed Assets
414
Human Resources
681
Greenshades
949
FieldService
1042
Interfund Management
1235
Safe Pay
1428
Electronic Reconcile
1493
SmartList
1632
Cash Flow Management
1838
Technical Service Tools
1878
Excel-Based Budgeting
2277
Purchase Order Enhancements
2404
Mekorma MICR
2416
Control Account Management
2547
Enhanced Commitment Management
2916
MICR for Canadian Payroll
2992
CopierSeries
3104
Advanced Security
3183
Assign By Checkbook
3258
Encumbrance Management
3278
Report Scheduler
3830
SmartList Builder
5597
HITB Report
6499
Dynamics Online Services
7150
Mekorma Multi-Batch Management
7156
Mekorma Products Manager
8209
Mekorma Enhanced ePayments
Windows
:c:program files (x86)/Microsoft Dynamics/GP2018/Dynamics.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/FORMS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/REPORTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/IM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/IMFORMS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/IMRPTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/fam.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/F309.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/R309.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/HR.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/HRPFRMS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/HRPRPTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/GSCENTER.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/GSFORM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/GSREPORT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/SrvcAdv.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/FRMS949.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/RPTS949.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/IFund.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/1042FORM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/1042RPTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/SFPAY.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/SPAYFRM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/SPAYRPT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/AREC.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ARECFRM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ARECRPT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/EXP1493.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/EXP1493F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/EXP1493R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/CFM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/CFMFORM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/CFMRPTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/TAUTIL.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/F1838.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/R1838.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/XLBudget.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/XL1878F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/XL1878R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/POE2277.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/POE2277F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/POE2277R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/MICR.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MICRFRM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MICRRPT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/CAM2416.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/CAMFORM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/CAMRPTS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/ECM2547.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ECM2547F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ECM2547R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/MICRJOE.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/F2916.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/R2916.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/QK2992.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/QDF2992.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/QKR2992.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/AdvSecur.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ADVS_FRM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ADVS_RPT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/VPS.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/VPSFRM.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/VPSRPT.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/ENC3258.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ENC3258F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/ENC3258R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/RPTSCHED.dic
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/F3278.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/R3278.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/SLBUILD.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/F3830.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/R3830.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/HTB5597.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/HTBF5597.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/HTBR5597.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/DO6499.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/DO6499F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/DO6499R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/MPP7150.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MPP7150F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MPP7150R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/MEP7156.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MEP7156F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MEP7156R.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/MEEP8209.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MEE8209F.DIC
:c:program files (x86)/Microsoft Dynamics/GP2018/Data/MEE8209R.DIC
Paste your DYNAMICS.SET file here and I will show you the changes to make. Dropping tables is not going to fix this only create more issues.
Ok I am still getting the same error:
Removed it from DU0000010, DU000020, DB_UPGRADE and removed Table DU000030
Further Dropped the following tables from Dynamics
APR000020
Dropped the following tables from company database
drop table pto00100
drop table PIP40100
drop table APR_PIP40100
drop table CLM40600
These items do not exist in Dynamics.Set or DynUtils.set
So not sure where else they can stuck?
Thanks
You can remove these products from your DYNAMICS.SET file but they will remain in your database. Try modifying your DYNAMICS.SET file using Add/Remove programs. It can be tricky modifying the set file.
You will have to remove the tables for those products mentioned in the link below:
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156