web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Company missing aft...
Microsoft Dynamics GP (Archived)

GP Company missing after upgrade

(0) ShareShare
ReportReport
Posted on by Community Member

After our upgrade to GP 2015 I noticed that one of our companies is missing.  Not sure what happed to it but is there a way to get it back?  The database has been restored but how can we see it in GP Utilites so that it can be upgraded (and viewed) along with the other companies?

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: GP Company missing after upgrade

    Hello,

    It sounds like the company database could've been deleted for some reason, and you mentioned you now have it restored but can't see it in Utilities.

    If ClearCompanies script was run after the database was deleted, it would've removed all mention of the databases that don't physically exist in SQL Server from the DYNAMICS system database, to include the SY01500 (Company Master) at which Utilties looks to determine a list of company databases, as well as the system tables used during the upgrade: DB_Upgrade, DU000020 and DU000030, among others.

    The question is whether you see this restored company database in the DYNAMICS..SY01500 table? If not, then you'll most likely need to create a shell database with the same ID and name for this company database in Utilities, then restore a backup of this company into it, while running the script from KB 871973 next, to get the company ID values in the company database to match that of the SY01500 table.

    Also, if the ClearCompanies script was run, it's possible that user information, user access to the company database and/or user security in this company database could've been removed as well as SmartList Favorites for this company database, all of which are held in the DYNAMICS system database.

    Let us know if you have any further questions on this.

    Thank you!!

  • Suggested answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,877 on at
    RE: GP Company missing after upgrade

    Fonda....Just giving u a hint...Utility looks at this table DB_Upgrade when you upgrade GP. So, Just replace all the records for the failed company with the ones from the DYNAMICS db backup taken before the upgrade. And also make sure the SY01500 has the entry for the missing company. and then launch utilities and see if it picks up the missing company and resume the upgrade.

    Also make sure DU000030 is empty.

    Check the below link for more technical details about the these tables

    community.dynamics.com/.../microsoft-dynamics-gp-2015-the-database-upgrade

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans