Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Upgrade Error

(0) ShareShare
ReportReport
Posted on by 1,930

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.

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade Error

    That would be rather scary to have the DYNUTILS.SET file be different than the DYNAMICS.SET but it can happen.

  • Suggested answer
    RE: Upgrade Error

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade Error

    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.

  • Suggested answer
    Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Upgrade Error

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade Error

    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?

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Upgrade Error

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade Error

    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.

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Upgrade Error

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade Error

    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.

  • Suggested answer
    RE: Upgrade Error

    You will have to remove the tables for those products mentioned in the link below:

    community.dynamics.com/.../quot-problem-ascertaining-version-information-quot-error-when-installing-or-upgrading-microsoft-dynamics-gp

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans