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
I have submitted my request to Sarah Purdy as she was the engineer that assisted with this incident.
Hi Richard,
You will need to contact the engineer that assisted on that case.
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
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.
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.
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
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.
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
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,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156