Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Importing Users View modes: 
User avatar
Member
Member
martinagency - 4/21/2011 10:17:45 AM
   
Importing Users
When I attempt to import users i get the following message. How can I pinpoint the issue?

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

User avatar
Member
Member
martinagency - 4/21/2011 10:18:40 AM
   
RE:Importing Users
Just to be clear I get this message when I import sites or objects and I am only selecting the users.

User avatar
Member
Member
martinagency - 4/21/2011 10:25:32 AM
   
RE:Importing Users
ERROR:@Error loading 'Users' data
Message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Stack Trace:
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
at CMS.CMSImportExport.ImportProvider.LoadObjects(SiteImportSettings settings, String objectType, Boolean siteObjects)


ERROR:@
Message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Stack Trace:
at CMS.CMSImportExport.ImportProvider.LoadObjects(SiteImportSettings settings, String objectType, Boolean siteObjects)
at CMS.CMSImportExport.SiteImportSettings.LoadDefaultSelection(String objectType, Boolean siteObjects, ImportTypeEnum importType)

User avatar
Member
Member
martinagency - 4/21/2011 2:41:37 PM
   
RE:Importing Users
I think my issue is that I do not have the same user fields setup in the dev area. I'm going to fix that and see if i still have an issue.

User avatar
Kentico Support
Kentico Support
kentico_radekm - 4/22/2011 3:52:06 AM
   
RE:Importing Users
Hello.

Are you running that export / import between the same versions of Kentico CMS? Are they standard CMS users? What tool are you using? Standard export / import procedure, or some SQL tool, like SQL Import Toolkit? Thank you.

Best Regards,
Radek Macalik

Top