Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Organization ID is mai...
Customer experience | Sales, Customer Insights,...
Suggested answer

Organization ID is maintained when importing from another deployment

(0) ShareShare
ReportReport
Posted on by WillD44 152

If you import an organization from one deployment to another using a SQL backup, the organization keeps it's organization ID.  If you import a second organization from a later backup, it still keeps the ID.  I suppose that might be by design as it's just a later backup of the same SQL database.  How do we import a later backup as a new organization?  

This all becomes relevant when performing an upgrade.  The deployment manager seems to get lost when performing an organization upgrade if it's working on a duplicate organization ID.

  • WillD44 Profile Picture
    WillD44 152 on at
    Organization ID is maintained when importing from another deployment
    This OrgID issue is also part of the server-side sync with Exchange.  Apparently when you Test & Enable the users mailbox, it writes the OrgID to Exchange.  So in the case of the organization on our new CRM server, the OrgID is the same as the one we imported from.  That sounds like it will cause problems when we cut over to the new CRM server.
  • WillD44 Profile Picture
    WillD44 152 on at
    Organization ID is maintained when importing from another deployment
    Sounds like that internal procedure isn't working.  Is there a way to execute it manually?
  • WillD44 Profile Picture
    WillD44 152 on at
    RE: Organization ID is maintained when importing from another deployment

    Build # : 9.1.0016.0020

    We are migrating CRM to new server and also upgrading versions from 8.2 to 9.1.

    We restore a backup of the 8.2 organization into the new 9.1 server in order to do user testing.  This data becomes stale after short period.  So we do another restore of new backup into the 9.1 server.  This is when the problem occurs.

    Once all testing & training is complete, we will do a final restore from the 8.2 server to the 9.1 server and this will become our new production environment.  The 8.2 server will be decommissioned then.

  • Pedro Cadavez de Freitas Profile Picture
    Pedro Cadavez de Fr... on at
    RE: Organization ID is maintained when importing from another deployment

    What CRM version are you using?

    Share the full build number from Deployment manager, servers section.

    This shouldn't occur.

    importing a clone DB into a deployment manager that has already the same orgID should trigger a new orgID.

    In any case, cloning DB's should be avoided due to inconsistencies like this.

    What you your business case that you need to import clones?

    What about working on them on different deployments?

  • WillD44 Profile Picture
    WillD44 152 on at
    RE: Organization ID is maintained when importing from another deployment

    The MSCRM_CONFIG.Organization table and also the <mydatabase>.OrganizationBase table is where I'm seeing the IDs.  This seems to be where the organization upgrade gets lost according to the log files.

  • Suggested answer
    Pedro Cadavez de Freitas Profile Picture
    Pedro Cadavez de Fr... on at
    RE: Organization ID is maintained when importing from another deployment

    Hello WillD44 ,

    Hope you are well.

    There is an internal procedure when you import a CLONE org into the same deployment that checks if there is already an ORG with the same orgID on that deployment. If yes, the procedure will generate a new orgID and update all required tables columns that use ORGID with the new orgID.

    So, we don't expect you have 2 ORGs on the same deployment with the same orgID, as that would cause a whole lot of problems.

    Are you sure they have the same ORGID? where are you checking that?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,946 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,420 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans