Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    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 Profile Picture
    coquisalsa 2,725 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Redbeard 12,931 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Redbeard 12,931 on at
    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 Profile Picture
    Redbeard 12,931 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans