Wednesday, January 9, 2013

Dynamics GP 2013 Upgrade Error - The conversion process encountered an error and the temporary table did not get removed

During the upgrade process, dynamics GP shows errors or warnings for a few tables
In the details of the error, GP Utilities suggests "Remove the temporary table at the database level"
If you delete the tables, GP Utilities throws errors when it tries to upgrade the company again.

  • I have seen this happen when you make backup copies of tables that happen to be the same name as the temporary tables.
  • Delete any extra backup tables you may have  that pertain to the tables listed as giving trouble to update, then run the update again


I experienced issues with these tables (there was no data in any of them)

  • CM00103 Checkbook EFT format header
  • SVC00998 SVC_Contract_Line
  • SVC00601 SVC_Master_Default


Solution:
If the tables are empty, and they just refuse to upgrade, you can copy the table structure from another database that has successfully upgraded, or from a clean install of the new version.

  • Use SQL management studio to make a "drop and create" script for the table in your upgraded database.
  • Change the name of the database after "Use" to your old db
  • Run the create script to create the new version of the table in your old db
  • Re-run dynamics. There should be no issues, or the upgrade should complete with no errors.

Also, see this technique
http://community.dynamics.com/gp/f/32/t/78980

1) Ran the failed table script to verify what failed:
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
2) Then ran:
delete DYNAMICS..DU000030 WHERE Status <> 0 and Status <>15
3) Then ran:
delete dynamics..duLCK
4) Opened the Dex.ini file and set "Synchronize=TRUE" and saved changes
5) Re-ran GP Utilities and the companies upgraded successfully.

No comments:

Post a Comment