?
Solved

CRM Organization ID

Posted on 2009-05-14
7
Medium Priority
?
1,014 Views
Last Modified: 2013-11-24
Hi,

After an import of an Org from an existing DB for some reason the Org ID in the config db and in the MSCRM db do not match, any idea on how to change one of the, i would rather not try another import as this took over 12 hours the first time.

Cheers
Mark.
0
Comment
Question by:squizzer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 9

Expert Comment

by:Biffster007
ID: 24390902
Hi,

Can you lay down the steps you did to import the organisation please.

Cheers,
MH
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 24397709
Also, what errors are you getting as a result?
0
 
LVL 2

Author Comment

by:squizzer
ID: 24409657
Hi,

I restored the backup of the database to the new server, installed a vanilla CRM 4 with a different name to the existing organisation, then ran the import tool from the deployment manager, it took 17 hours to run through, then at the end of it the ORG ID is different to the one in the config file, it hasn't changed the org ID anywhere in the ORG_MSCRM database to match the new one in the MSCRM_Config db so when you set that one as enabled and default it will not load.

Cheers
Mark.
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 15

Expert Comment

by:WilyGuy
ID: 24414113
So, entirely new environment, new SQL and new CRM.
You had a "dummy" org that you installed with, then restored the database to the SQL and ran the import.  The Import took 17 hours????  How big is the database?  How many users?

I think you should do the import again as it shouldn't take 17 hours unless your user set is humongous.  Were there any errors in the Event Log?

0
 
LVL 2

Author Comment

by:squizzer
ID: 24419239
Hi, the user base was about 120, but the database was 35Gb, so quite big :-)
No errors just ran through, the only thing that i can see that wasn't changed for some reason was the Org id throughout the db.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 24421194
As an aside, what Rollup are you on in each environment?

Also, did it map the users correctly? (was it a different domain and if so, did those records change in the DB).

I ask because I had recent experience with some different weirdness in the Import.

There are logs created in the Docs and Settings for the user who did the import:
\Application Data\Microsoft\MSCRM\Logs... you're looking for crm40dmsnapin.log files.  See if you can find any errors.
0
 
LVL 2

Accepted Solution

by:
squizzer earned 0 total points
ID: 24526039
Hi,
They were on roll up 2 so i made sure that the roll up on the "Empty" system was the same before import. Haven't been able to sort it so have just kept the vanilla one and am importing the data using the data migration wizzard. Should do the trick just a bit long winded :-)

Thanks for the replies
Mark.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question