Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Company Missing from D...
Microsoft Dynamics SL (Archived)

Company Missing from Database update

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have an upgrade from SL 7.0 to SL 2011.

The databases have been moved to a new server and upgraded successfully.

The APP databases are missing from the Database Update Screen in SL and I am unable to login to the app databases though SL.

I am able to create and additional application database on the same system db and have logged into it.

Everything is correct in the Domain and Company tables.

I have updated views, synced ownership and security.

I have removed and re-added the company from both the domain and company tables using the SL screen.

Any suggestions?  I am totally at a loss on this one.  I have never seen it happen before.

THANKS!

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Update....  I submitted an incident with Microsoft.  This is a known issue that hasn't been written up just yet.  The MASTER password needs to be wiped out in the Domain table (SYS DB) and the MASTER Password needs to be wiped out in ZP field in the GLSetup table (APP DB).

  • stefann Profile Picture
    stefann 10 on at
    RE: Company Missing from Database update

    Hi Jenni, yes I saw them but I am not sure what the issue could be without looking at the actual system. You might be better off opening a case with MS.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Stefan.  did you get a chance to look at the screen shots I sent?  Any suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Butch.  Thanks for the suggestion.  This client does not have the Multi Company Module purchased so I am unable to load that screen.  I have reached TrialLoc mode. Any other suggestions?

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Company Missing from Database update

    From your snapshots it looks like it shows up properly in Database Maintenance 98.290

    Can you go to Foundation -> Multi-Company -> Company setup and see if the companies are visible there?

    If so, will you uncheck the "active" box, save, exit, go back and recheck the "active" box?

    I have seen a sort of similar situation in 2011.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Yes Stefan.  I was able to do all three except for #4, as the company is missing from the list to choose there.  This is a very odd thing.  I have never seen this before and I have done 100's of SL upgrades / installs since the 1995.  All I can think is that there is a proc or view somewhere that was not updated correctly.  I have tried upgrading the database and starting over.  I tried it on both fp1 and sp1.  All with no luck.  Do you have any other suggestions?

  • Stefan N Profile Picture
    Stefan N 80 on at
    RE: Company Missing from Database update

    Have you looked at these?

    support.microsoft.com/.../848027

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Stefan.

    Here is the 3rd file.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Stefan.

    Here is the 2nd file.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Company Missing from Database update

    Stefan.

     

    I am limited to a 64kb upload.  I have uploaded 3 zip files each with a screen shot.  Please let me know if you have any recommendations.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans