Good Morning Everyone,
We are in the process of doing a test upgrade for a customer from GP10 -> GP2013. They have 4 companies to upgrade and all went as planned excluding 1 (and of course its their main company). When GPUtils runs to upgrade this company it fails with "the Conversion Process Encountered an Error and the temporary table did not get removed". The tables it is speaking of specifically are the Item Master and Item Master 11.80.0001 tables (IV00101). I did a little research on my own for this and found some people that had similar issues and ran this series of scripts to remove the tables:
SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID
FROM DYNAMICS.dbo.DU000030 a
JOIN
DYNAMICS.dbo.DU000010 b
ON a.fileNumber = b.fileNumber AND a.PRODID = b.PRODID
JOIN
DYNAMICS.dbo.SY01500 c
ON a.companyID = c.CMPANYID
WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15
Then ran to delete the temp tables that failed:
delete DYNAMICS..DU000030 WHERE Status <> 0 and Status <>15
3) Then ran to delete the table that states GP is being upgraded currently:
delete dynamics..duLCK
This successfully deleted the tables from the Dynamics SQL Databases but when I attempt to restart the GPUtils upgrade, I get the exact same error and the tables return to the Dynamics DB.
What would be the next recommended course of action to remove/ modify these tables for a successful upgrade?
Thank You for the Assist!
*This post is locked for comments
I have the same question (0)
