Trying to do a test upgrade of our company and during upgrade of table receive table error. "The Conversion process encountered an error and the temporary table did not get removed."
"Recommended action: Remove the temporary table at the database level."
This is against the DYNAMICS database "Company Master" SY_Company_MSTR" "SY01500.
I am not really up on Query analyzer to correct this issue. Any help would be appreciated.
Is there a way to prevent this error during final upgrade?
*This post is locked for comments
Please Verify this answer if it has been useful to you. This could help others trying to solve the same or similar problem.
Hi Tim,
I had the same problem and fixed it using the SQL script ClearCompanies.sql which Jon is suggesting.
The problem was caused by some rows in SY01500 table which were referencing GP company databases that didn't exist anymore in my SQL Server.
I hope this help.
Thanks
Jorge
Hey Tim,
This is a bit odd, let's make sure there aren't any references to invalid companies in your SY01500 table.
Run all queries in SQL Server Management Studio while signed in as 'sa'. I hope you aren't still using Query Analyzer!
Here's what I would try:
1. Restore a fresh copy of the DYNAMICS database to your test SQL server
2. Run the ClearCompanies.sql script against the DYNAMICS database.
Download it from here: support.microsoft.com/.../855361
Then run:
delete DYNAMICS..DU000030 WHERE Status <> 0 and Status <>15
Then run:
delete dynamics..duLCK
3. Download/install the latest patch for GP 2015
4. Open the GP 2015 Dex.ini file and set "Synchronize=TRUE" and save/close.
5. Try the upgrade again
Harry,
Thanks for the help. I gave it a try, Re-ran update utility and same error.
Tim,
Here is a similar post, with a verified answer, which seems to thoroughly cover the topic. You may have missed it in your initial search because it involved a different version of GP and a different table. I would recommend using the steps outlined in the verified answer.
Harry,
Ok, I checked out the tables and there is a dbo.Sy01500, but not a dbo.SY01500_Temp.
?
I can't think of a way to keep the error from happening again, it may not occur without any intervention.
Typically when something doesn't delete correctly, you're looking for some kind of interruption to normal processing, like the workstation going to sleep. You may want to check your power management settings on the workstation in the control panel.
Tim,
You'll want to browse out to the Temp table in the Dynamics Database, in order to determine what it's name is, which will likely be something like SY01500_Temp.
DROP TABLE DYNAMICS.dbo.SY01500_Temp
Be sure to have a backup of the Dynamics DB prior to executing any scripts. Make sure you correctly identify the table to be deleted.
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,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156