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
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!!
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
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
