You’re offline. This is a read only version of the page.
425
Hi Guys,
I have issues in upgrading from Gp 10 SP5 to GP2010 R2.
GP 2010 R2 utils fail with error message:
Product 1911 doesn't support upgrade from 10.0.38
Product 4522 doesn't support upgrade from xxx
My Path is Gp 10 SP5-->GP 2010 SP1-->Gp 2010 SP2
GP 2010 Sp1 finished fine without any errors, but it didn't upgrade those HR and Payroll modules.
I am stuckat Sp2 utils.
Please help me in this regards.
Any pointers is appreciated....
Thanks in advance.
-Dhruva
GP Consultant.
*This post is locked for comments
Hey guys,
These modules have always been updated while logging into GP not Utilities until R2/SP2 when we pushed them into Utilities. If you were to upgrade to RTM or SP1 and logged into each company you would see the tables begin to update. As for the issue in R2/SP2 we have wrote this up to the Development team as a bug and they have assured us this will be fixed in the next hotfix.
I apologize for any inconvenience you may have run into. Please let me know if you have any other questions regarding this matter.
Thanks,
Joanthan
We did finish the upgrades for 2 Clients in test environment. But can't rollback to see the R2 hotfix works.
Definately i would try for next client upgrades and let you know if that works.....
Thanks for the info....
Are you still in a test environment so you can start the upgrade over or is it too late? Do you have backups from before beginning the upgrade so you can start fresh after applying the latest R2 hotfix? You would need backups of your company databases plus the DYNAMICS database.
Absolutely right.....
We wasted a lot of time running Gp 2010 Sp1 utilities and after the utilities got completed HR and payroll modules were still at 10.
Means GP 2010 Sp1 utils didn't update them. Thats my concern
I just noticed that looking at the service pack board once you have this level of GP 10 there are numerous fixes for payroll
10.00.1441 (Hotfix KB 982415)
Also, to upgrade to GP2010 R2 you have to apply the latest hot fix prior to launching GP Utilities.
2011 June Hotfix or later KB 2552044 - Version 11.00.1799 - English
Jonathan,
Thanks for replying.....
We had this issue resolved by Going back Gp 10 Sp5 and updated the HR and Payroll modules by downloading the chunk files.
There we were able to continue with Upgrade to GP2010 R2.
But my question is Why didn't the GP 2010 SP1 utilities didn't update the HR and Payroll modules????
To my surprise after updating to GP 2010 SP1 HR and payroll modules were at 10.
It really doesn't make sense that SP1 doesn't update those modules and R2 wont let you upgrade becoz of version issue. Dont you think this should have been checked at SP1 level.....
Hi Dhruva,
This is a bug we found. Here are your options:
1. Verify that the advanced hr and payroll modules are even used. If not, run the following scripts below to re-install the products:
USE DYNAMICS
drop table APR000020
delete DYNAMICS..DB_Upgrade where PRODID = 1911
delete DYNAMICS..DB_Upgrade where PRODID = 4522
delete DYNAMICS..DB_Upgrade where PRODID = 4933
delete DYNAMICS..DB_Upgrade where PRODID = 4955
/*Run the following on the company databases*/
DROP TABLE APR_PIP40100
DROP TABLE PTO00100
DROP TABLE CLM40600
2. If the advanced hr and payroll modules are used, verify the version of the advanced hr and payroll modules are at the latest version.
a. Run the following statement in the SQL Server Management Studio:
select * from DYNAMICS..APR000020
b. Verify the versions match those listed below:
PRODID 1911 - 9.0.60
PRODID 4522 - 9.0.45
PRODID 4933 - 9.0.26
PRODID 4955 - 9.0.88
c. If the versions are not at the latest, download the latest version and install the version for Microsoft Dynamics GP 9.0. **NOTE**Following the installation, login to Microsoft Dynamics GP 9.0 as the sa user to finish the update.
mbs.microsoft.com/.../hrp_bp_addon.htm
3. Verify the correct hotfix for Microsoft Dynamics GP is installed for the update to Microsoft Dynamics GP 2010. The version must be 9.00.0371 or later.
4. Install Microsoft Dynamics GP 2010 Service Pack 1 or earlier. **NOTE**There is currently an issue when updating the advanced hr and payroll modules to Microsoft Dynamics GP 2010 R2. Therefore, the update path must first stop at Service Pack 1 or earlier.
5. Update the databases to Microsoft Dynamics GP 2010 Service Pack 1 or earlier.
6. Login to Microsoft Dynamics GP 2010 Service pack 1 or earlier as the sa user to finish the update of the advanced hr and payroll modules.
7. Install Microsoft Dynamics GP 2010 Service Pack 2 or later and update the databases to that version.
Updating from Microsoft Dynamics GP 10.0 to Microsoft Dynamics GP 2010
1. Verify that the advanced hr and payroll modules are even used. If not, run the following scripts below to re-install the products:
USE DYNAMICS
drop table APR000020
delete DYNAMICS..DB_Upgrade where PRODID = 1911
delete DYNAMICS..DB_Upgrade where PRODID = 4522
delete DYNAMICS..DB_Upgrade where PRODID = 4933
delete DYNAMICS..DB_Upgrade where PRODID = 4955
/*Run the following on the company databases*/
DROP TABLE APR_PIP40100
DROP TABLE PTO00100
DROP TABLE CLM40600
2. If the advanced hr and payroll modules are used, verify the version of the advanced hr and payroll modules are at the latest version.
a. Run the following statement in the SQL Server Management Studio:
select * from DYNAMICS..APR000020
b. Verify the versions match those listed below:
PRODID 1911 - 10.0.38
PRODID 4522 - 10.0.51
PRODID 4933 - 10.0.82
PRODID 4955 - 10.0.97
c. If the versions are not at the latest, download the latest version and install the version for Microsoft Dynamics GP 9.0. **NOTE**Following the installation, login to Microsoft Dynamics GP 10.0 as the sa user to finish the update.
mbs.microsoft.com/.../hrp_bp_addon.htm
3 Verify the correct hotfix for Microsoft Dynamics GP is installed for the update to Microsoft Dynamics GP 2010. The version must be 10.00.1368 or later.
4. Install Microsoft Dynamics GP 2010 Service Pack 1 or earlier. **NOTE**There is currently an issue when updating the advanced hr and payroll modules to Microsoft Dynamics GP 2010 R2. Therefore, the update path must first stop at Service Pack 1 or earlier.
5. Update the databases to Microsoft Dynamics GP 2010 Service Pack 1 or earlier.
6. Login to Microsoft Dynamics GP 2010 Service pack 1 or earlier as the sa user to finish the update of the advanced hr and payroll modules.
7. Install Microsoft Dynamics GP 2010 Service Pack 2 or later and update the databases to that version.
Let me know if you have any further questions.
Thanks,
Jonathan
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (