Asked by:
import of an organization in CRM 2011

Question
-
Hi all! Please help me.
I have a problem during an import of an organization which failed with following error:
Message: Exception during import of organization (Name=’‘, Id=3e58a0cc-c277-df11-b2c1-0050569473db):
System.Data.SqlClient.SqlException: A row with a duplicate key cannot be added to the object ‘dbo.SystemUserOrganizations’-object with unique index ‘SystemUserOrganizations_CrmUserId’The organization which I tried to import is a backup of an organization which was created in the same deployment. The import runs successful on every other deployment/
I tryed to deactivate OptimizeOrgImport, but it didn't help. I tryed to create a OptimizeOrgImport dword and set it to 0 (then i tryed to set it to 1), but it all didn't help
- Edited by Elka_ Friday, December 16, 2011 12:04 PM
Friday, December 16, 2011 12:03 PM
All replies
-
You are sure you don't already have this same organization database already imported on the server?
if not, I would try again but try to manually map your users to see if that helps. That might create a new unique record for that organization user.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Edited by Jamie MileyModerator Monday, December 19, 2011 3:07 PM
Monday, December 19, 2011 3:06 PMModerator -
Hello, thanks for answer
Yes, i've already have the same organization database on the server, i tryed to import a backup of this organization.
I tryed to import with manually map users , but it didn't help :(
Friday, December 23, 2011 9:28 AM -
Hmm. If no one chimes in I would maybe open a support incident with Microsoft on this issue.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!Friday, December 23, 2011 5:41 PMModerator -
Did you get this figured out? How did you fix it?
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!Monday, August 20, 2012 2:02 PMModerator