Hi all,
I've a customer that is currently testing GP 2018R2 upgrade from 2015R2.. The initial upgrade was done in Nov. 2018 and didn't encounter much problem during the upgrade. Fast forward 6 months later and they wanted a data refresher, which was done by their IT people in restoring all the GP companies (50) and the DYNAMICS system DB.
48 out 50 companies upgraded without any issues, despite all the 3rd-party products that are installed, and which mostly upgraded their tables just fine at the first GP client launch.
However, during the GP Utilities upgrade process, 2 companies wouldn't upgrade and would keep blocking at 2 table upgrades (POP10300 & POP30300).. The most funny is that in those 2 companies, the POP module isn't used at all and the tables are empty.
What bugs me is the version numbers showing up for the tables (16.00.0580) as if GP wanted to process an intermediary update on those 2 tables ..
The system claims that a temp table should be removed, but I can't find any of those.. I've checked the GP team's blog about upgrade issues, but couldn't find anything helpful. Since the 2 companies are stuck in the upgrade process, I can't fix the tables itself, and even tried to restart the upgrade multiple times by clearing the db_upgrade table status for those 2 companies.
Any hint would be really appreciated.