You’re offline. This is a read only version of the page.
580
This problem is not major, but it has been there for a long time and I would love to squash this bug.
Scenario:
Company upgraded from GP 9.0 to GP 2013
There are multiple companies under a single Dynamics database
Following the upgrade there are two entries in the company listing for the first company when logging in only as sa
If you select the wrong one an error message is received "The files for this company have not been updated"
Select the second listed company, and it works
Several investigations of the SYS tables and numerous scripts have been tested to clean out orphaned companies, etc. with no luck
There simply is no actual duplicated company, it only shows that way when logging in as SA.
I know I have heard other GP people talk about this, and because it is so minor I guess no one really goes after it, but I was curious if someone had ever actually documented this, or if there is a fix
*This post is locked for comments
I wanted to be sure to be clear - this is a valid company. it is CompanyID 1, lets call it for example, XYZ Company, lets say there are 10 companies in this database, so when you open the Company lookup box ( as sa user) it looks like this
XYZ Company
XYZ Company
ABC Company
My Company
Your Company
Our Company
So Company ID 1 is listed Twice, even though it is in SY01500 only once, and when you select the SECOND instance of XYZ Company it says:
"Files for this company have not been updated"
This occurs even after a test upgrade from GP 2013R2 to GP 2016R2
So somewhere there is some record of an unupgraded company, that was already upgraded. All the tables you mention show this company correctly in one way or another as CompanyID =1 CompanyName = XYZ Company and DBName = XYZDB
Again, this only happens with sa, but it bothers me that the largest and most important company is somehow corrupted. I know that somewhere there is an entry in some table that needs to be removed I would imagine, but I don't know where. For example, the query that returns the list of companies available on the login screen is picking it up twice somehow
I have seen this happen before. I trust you've checked the SY01500 table in the DYNAMICS database? I had a spare in there and only sa had access to it. Also check the User Access table in the Dynamics database - SY60100. If you do have an extra entry in the SY01500, look across at the INTERID field and make sure you do not have an actual database created. If you find something in the SY01500 table, down load a free copy of APEX SQL Search and search all of your databases for that database name. Also, look in the DB_UPDATE, DU00010, DU00020 and DU00030 tables and see if there is any reference to that company.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
