Error when importing a survey

[ihill]

I'm trying to import a survey from one instance of Checkbox on one server to another instance on a different server. I receive an error "Unable to save data". Is there a certain survey item that doesn't adhere to the Checkbox XML schema? Because this is the only survey that doesn't work when I'm transferring surveys to this other instance of Checkbox.

Exception Table
Message Unable to save data.
Data System.Collections.ListDictionaryInternal
InnerException UndefinedValue
TargetSite Void Save()
StackTrace
at Checkbox.Common.PersistedDomainObject.Save()
at CheckboxWeb.Forms.SurveyImport.ReadXmlFile()
HelpLink UndefinedValue
Source Checkbox.Common

Any ideas on why this could be happening? and how to correct?

[ncushing]

We've seen a couple installations where the ResponsePipes section of the xml caused a problem when importing the survey xml. Does your export file contain a <ResponsePipes /> section? If so, try to remove that section then import again.

You also may want to check the exception log. Import errors often cause more than one error to be logged and one of those errors may have more information.

[jpratt]

A common error that occurs in your Exception Log is:

The following errors occurred while importing the XML file:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ckbx_ResponsePipe_ckbx_Item'. The conflict occurred in database 'checkbox', table 'ckbx_Item', column 'ItemID'. The statement has been terminated.

As ncushing previously stated, removing the <responsespipes> directly from the survey XML resolves this issue.