Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Trying to upgrade from GP10 to GP2010 R2

Posted on by Microsoft Employee

I am trying to upgrade from GP10 (version 10.00.1701) to GP2010R2 (version 11.00.1752).  When I launch Utilities I get the following error message 'There was a problem ascertaining product version information.  Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information.'

When I check the duinstall.log file it has the following
Failure encountered ON 8/5/2011 at 10:55:28 PM.  Error:  Product 1911 does not support upgrading from version 10.0.1701.
Failure encountered ON 8/5/2011 at 10:55:28 PM.  Error:  Product 4522 does not support upgrading from version 10.0.44.
Failure encountered ON 8/5/2011 at 10:55:28 PM.  Error:  Product 4933 does not support upgrading from version 10.0.76.
Failure encountered ON 8/5/2011 at 10:55:28 PM.  Error:  Product 4955 does not support upgrading from version 10.0.92.

The products that it are referenced are
Product 1911 - HRM Solution Series
Product 4522 - Payroll Integration to Payable
Product 4933 - Certification Manager
Product 4955 - Employee Health and Wellness

Any help that could be provided would be greatly appreciated.
Thanks!
Brigitte

*This post is locked for comments

  • Re: Trying to upgrade from GP10 to GP2010 R2

    Thanks for the suggestion Charles Ray.  I have used that solution in the past, but for this specific issue, none of the typically recommended steps re: the DU000020, DU000030, and DB_upgrade tables worked.  After a lot of time working with MS support, I decided to manually update the build in the DB_upgrade table to match the APR000020 table...that's the only thing that resolved the issue without fully uninstalling the products (which we did do on the site that is not using them at all).

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    Ran into a similar situation when trying to upgrade to the latest GP2010 SP3 (just released). My HR Forms dictionnary didn't wanted to get upgraded and was keeping throwing and error (though I don't have any HR reports or forms customizations).

    The conversion log file contains an interessting Error message at the end :
    Error on line 528: End of input while looking for a section with "from version" of '11.0.1807'. The Input file has errors.

    The log file provides also details about the version it's trying to adjust :

    Run on             : 7/10/2012 9:08:05
    Main Dictionary    : :C:Program Files/Microsoft Dynamics/GP2010/Dynamics.dic
    Old Product Dict.  : :C:Program Files/Microsoft Dynamics/GP2010/Version11.0.2055.0Backup/HR.DIC
    New Product Dict.  : :C:Program Files/Microsoft Dynamics/GP2010/HR.DIC
    Reports Dictionary : //SRV-CAMTL-GP11/GP/Data/HRPRPTS.DIC
    From Version       : 11.0.1807
    To Version         : 11.0.2030
    Input File         : :C:Program Files/Microsoft Dynamics/GP2010/REP414.TXT
    Log File           : Update1102030_Human_Resources.log
    Delete Files       : True

    This is not the first time it happens to me (not only with the HR module) during a GP upgrade of the Forms and Reports dictionnaries. I end up usually tweaking the input file, which misses a "From - To" section for the aformentionned versions.

    This will look like :
    ['11.0.1807' to '11.0.2030']
    ### Do nothing here.  Just needs to be in here.


    That usually solves the problem and your upgrade is completed for the Reports and Forms.

  • Suggested answer
    Charles Ray Profile Picture
    Charles Ray on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    Another viable solution - if the build numbers are correct in the APR000020, you can simply delete the orphaned product references in the DU000020.

  • Re: Trying to upgrade from GP10 to GP2010 R2

    Thanks for updating!  I was able to resolve mine on both sites, using the same method.

  • Runbiz Profile Picture
    Runbiz 45 on at
    Re: Trying to upgrade from GP10 to GP2010 R2

     

    I encountered this same issue and figured out a fix.  The issue is that the DYNAMICS..DB_Upgrade table does not get properly updated with the correct version information when the GP 10.0 HRMSS SP5 is installed.  After installing the HRMSS SP5 for GP 10.0, I manually updated the DYNAMICS..DB_Upgrade table with the proper version information and then was able to successfully run the upgrade to GP 2010R2 in GP Utilities.

     

    To fix the DB_Upgrade table, first verify that the HRMSS SP5 has been successfully installed by running the following script:

     

    SELECT * FROM DYNAMICS..APR000020 ORDER BY PRODID

     

    The versionMajor field for each product listed should be 10.  The versionBuild field should be as follows:

     

    PRODID

    versionBuild

    1911

    38

    4522

    51

    4933

    82

    4955

    97

     

    I then ran the following scripts to manually update the DYNAMICS..DB_Upgrade table:

     

    UPDATE DYNAMICS..DB_Upgrade SET db_verBuild = '38' WHERE PRODID = '1911'

    UPDATE DYNAMICS..DB_Upgrade SET db_verOldBuild = '38' WHERE PRODID = '1911'

     

    UPDATE DYNAMICS..DB_Upgrade SET db_verBuild = '51' WHERE PRODID = '4522'

    UPDATE DYNAMICS..DB_Upgrade  SET db_verOldBuild = '51' WHERE PRODID = '4522'

     

    UPDATE DYNAMICS..DB_Upgrade SET db_verBuild = '82' WHERE PRODID = '4933'

    UPDATE DYNAMICS..DB_Upgrade SET db_verOldBuild = '82' WHERE PRODID = '4933'

     

    UPDATE DYNAMICS..DB_Upgrade SET db_verBuild = '97' WHERE PRODID = '4955'

    UPDATE DYNAMICS..DB_Upgrade SET db_verOldBuild = '97' WHERE PRODID = '4955'

     

    Both the db_verBuild and the db_verOldBuild fields had to be updated to match the versionBuild field in the DYNAMICS..APR000020 table before the upgrade could be completed successfully.

     

    The GP 2010R2 upgrade should now run successfully.

     

    As always, be sure to make a backup before updating any tables.

     

    I hope that helps.

     

  • Charles Ray Profile Picture
    Charles Ray on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    Is there anything new on this?  The GP version is already at 10.00.1835, but I re-added the 4 HR-PR chunk files and included, logged into the company (only one, no demo) as sa, there were several windows that opened and closed as tables were updated, but the DU000020 table does not reflect the change.  I even tried manually updating the DYNAMICS..DU000020 VersionMinor to the actual version of the dictionaries but it did not help.  DYNSA is dbo, and grant script has been run.  I have also run the 'clear company' script to sweep the cobwebs.  The version I'm updating to is 2010R2 +  the KB2682502 msp.

  • Re: Trying to upgrade from GP10 to GP2010 R2

    Hi Brigitte,

    I'll second Viol-8-r's question.  I tried installing sp 5, as suggested above, but the version doesn't seem to be updating in the tables (after logging into each company as 'sa' and letting the create tables run).  Any help is greatly appreciated!!

  • Syrus Profile Picture
    Syrus 4,156 on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    Hello Brigitte,

    Were you able to install GP 2010 successfully ? if yes How ?

  • callen Profile Picture
    callen 4,595 on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    There are SP5 versions of the four products you mentioned.  

    Here are the latest versions:

    HRMSS  10.0.38

    Payables Integration 10.0.51

    Certifications, Licenses 10.0.82

    Health and Wellness 10.0.97

  • callen Profile Picture
    callen 4,595 on at
    Re: Trying to upgrade from GP10 to GP2010 R2

    The versions of the products you specified are out of date. Download the latest versions of the products.  You'll need to log into each company as 'sa' to update the tables.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans