I'm doing a test upgrade from Microsoft Dynamics GP 10.0 SP5 to GP 2010 SP1. Most of the companies were upgrading successfully. But, now, two companies are getting failures in GP Utilities during database conversion on the following tables:
Account Current Summary Master (GP10110), Account Summary History (GL10111), and General Ledger Report Options Temporary (GL70501).
The Details for each of these reads: "The conversion process encountered an error and the temporary table did not get removed. Remove the temporary table at the database level."
When I run the Failed Tables script in SQL, I get the following for each of these three tables: "Table did not have the correct structure prior to the conversion of this table."
Previously, I had successfully upgraded all of these companies from GP 8.0 SP5 to GP 10.0 SP5. And, I ran DBCC CHECKDB and DBCC CHECKCATALOG prior. So, I don't know why all of a sudden I'm getting errors on table structure.
Is there a way of removing the temporary table that it speaks of in SQL, so that I can get this back on track? I stopped and started SQL and re-ran the update. But, that did no good. I got the same result.
Attached is a dexsql log if that helps.