Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Upgrade from GP 10 Sp5...
Microsoft Dynamics GP (Archived)

Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

(0) ShareShare
ReportReport
Posted on by Dhruva Darshan U 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

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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

  • Dhruva Darshan U Profile Picture
    Dhruva Darshan U 425 on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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....

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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.

  • Dhruva Darshan U Profile Picture
    Dhruva Darshan U 425 on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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

  • Dhruva Darshan U Profile Picture
    Dhruva Darshan U 425 on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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.....

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: Upgrade from GP 10 Sp5 to Gp 2010 R2 issues

    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

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans