This constraint cannot be enabled as not all values have corresponding parent


  • Hi,

    I'm migrating sites from WSS3 to SP2010 Ent edition via DB attach and STSADM export/import commands.

    When executing the Export command (stsadm
    -o export -url <url> -filename C:\export -includeusersecurity -versions 4
    -nofilecompression -overwrite) I receive the following FatalError:

    [7/25/2012 4:28:34 PM] FatalError: This constraint cannot be enabled as not all values have corresponding parent values.
    [7/25/2012 4:28:34 PM] Debug:    at System.Data.ConstraintCollection.AddForeignKeyConstraint(ForeignKeyConstraint constraint)
       at System.Data.ConstraintCollection.Add(Constraint constraint, Boolean addUniqueWhenAddingForeign)
       at System.Data.DataRelationCollection.DataSetRelationCollection.AddCore(DataRelation relation)
       at System.Data.DataRelationCollection.Add(DataRelation relation)
       at System.Data.DataRelationCollection.Add(String name, DataColumn parentColumn, DataColumn childColumn)
       at Microsoft.SharePoint.Deployment.ListObjectHelper.GetNextBatch()
       at Microsoft.SharePoint.Deployment.ObjectHelper.RetrieveDataFromDatabase(ExportObject exportObject)
       at Microsoft.SharePoint.Deployment.ListObjectHelper.RetrieveData(ExportObject exportObject)
       at Microsoft.SharePoint.Deployment.ExportObjectManager.GetObjectData(ExportObject exportObject)
       at Microsoft.SharePoint.Deployment.ExportObjectManager.MoveNext()
       at Microsoft.SharePoint.Deployment.SPExport.SerializeObjects()
       at Microsoft.SharePoint.Deployment.SPExport.Run()
    [7/25/2012 4:28:34 PM] Progress: Export did not complete.

    Any thoughts why?

    Thanks a lot in advance

    Wednesday, July 25, 2012 4:01 PM


All replies

  • Hi,arevach


    The issue has been fixed in the KB955594: when you try to use the stsadm.exe –o export command to export content from a SharePoint site, you will receive an error message.


    For more information, please refer to :



    Friday, July 27, 2012 6:02 AM
  • Thanks Jack,

    But the article refers to wss3 while I run the export command from my stage SP2010 server. after performing dbattach command.

    Any thoughts?

    Sunday, July 29, 2012 1:32 PM
  • Hi arevach,

    Because your site is migrated from wss3.0. So, you have to install  the latest cumulative update.

    Please refer to the following link.



    Monday, July 30, 2012 3:26 AM
  • I have the exact same error exporting from my MOSS 2007 SP3 environment:

    Same Export parameters / same error.

    WSS 3.0 SP3 and MOSS 2007 Standard SP3.

    David McKenzie

    Friday, August 03, 2012 6:25 PM
  • Hi, In my issue, I dont migrate from wss 3.0 but when i want export sharepoint 2010 sub site, this error fired:

    This constraint cannot be enabled as not all values have corresponding parent values


    Sunday, August 05, 2012 2:49 PM