Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP 2010 Upgrade

Posted on by 75,730

I am attempting a sample GP 2010 Upgrade. We are upgrading from 10.00.378 to 11.00.2044.  The upgrade gets to the Multicurrency Account master table and then just sits there. 15 hours later it is still there. The database is only 7.7GB. Has anyone else tried this?

I am going to try upgrading first to GP 2010 RTM and then to 11.00.2044.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Upgrade

    I have submitted my request to Sarah Purdy as she was the engineer that assisted with this incident.

  • Re: GP 2010 Upgrade

    Hi Richard,

    You will need to contact the engineer that assisted on that case.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Upgrade

    Jonhathan, where were charged a support incident($259) to get past this. Since this what I would consider a bug can we get a credit for that charge?

    Reg: 112072769281619

  • Re: GP 2010 Upgrade

    Hi Richard,

    Yeah we found this out about a week ago but still have been trying to narrow it down. We added it to the Hot topic for GP 2010 upgrade.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Upgrade

    The problem turned out to be that there four historical years (2002-2005) that were set up with a thirtenth period and that extra period had the same start date as the twelvelth period. So there were overlapping periods.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Upgrade

    Upgrading from 11.00.1274 to 11.00.2044 did not work either. Running SQL Profiler shows it is stuck on this command. It keeps executing it over and over again and is stuck in a loop.

    update top (500000) a set a.PERIODID = b.PERIODID  from GL30000 a,#dates b  where a.HSTYEAR = b.YEAR1 and  a.TRXDATE >= b.PERIODDT and a.TRXDATE <= b.PERDENDT  and a.PERIODID <> b.PERIODID  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Upgrade

    There are zero records in that table. When I upgraded from 10.00.0368 to GP 2010 RTM it went through fine. I will now try going to 11.00.2044. I will trun the DEXSQL.LOG and let you know how it goes.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 2010 Upgrade

    Hi Richard,

    Thanks for the question, there can be issues that can cause the upgrade to fail on the MC00200 but not anything that I know of that would cause it to hang. Can you run this script so we can see how many records are in the table:

    select count(*) from MC00200

    Did you have a DEX_SQL_LOG running while the upgrade was running? If so can you search that and see if it captured any errors relating to the MC00200. If so please let us know what the error is and I'll advise you further on this issue.

    Regards

    Rob

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans