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
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).
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.
Another viable solution - if the build numbers are correct in the APR000020, you can simply delete the orphaned product references in the DU000020.
Thanks for updating! I was able to resolve mine on both sites, using the same method.
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.
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.
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!!
Hello Brigitte,
Were you able to install GP 2010 successfully ? if yes How ?
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156