Upgrading from GP 2013 to GP 2015 Error "Table Error"

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (8)

Answers (0)

coquisalsa 2,725 on at

Like (0)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

Please Verify this answer if it has been useful to you. This could help others trying to solve the same or similar problem.
Suggested answer

coquisalsa 2,725 on at

Like (1)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

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
Suggested answer

Community Member Microsoft Employee on at

Like (2)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

Harry,

Thanks for the help. I gave it a try, Re-ran update utility and same error.
Suggested answer

Redbeard 12,931 on at

Like (1)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table 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.

community.dynamics.com/.../78980
Community Member Microsoft Employee on at

Like (0)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

Harry,

Ok, I checked out the tables and there is a dbo.Sy01500, but not a dbo.SY01500_Temp.

?
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

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.
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Upgrading from GP 2013 to GP 2015 Error "Table Error"

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.