FatalError: Exception from HRESULT: 0x80040E2F when importing a list

Nov 17, 2009 at 6:17 PM
Edited Nov 17, 2009 at 6:49 PM

I just installed beta 2.7 of the Sharepoint Content Deployment Wizard to export a list called 'Issues' that I had with versioning on in one of the fields (columns).  My intention was to copy the list (with all content, metadata, versions, and user info intact) in a Meeting Workspace with to another Meeting Workspace, say from http://sitename/pwa/projworkspace1/meetingworkspace1/lists/issues to http://sitename/pwa/projworkspace2/meetingworkspace2/lists/issues.

Release 2.7 provides the following:

Ability to export/import list items between different lists, so long as list fields are the same (e.g. same content type). (This can be thought of as "re-parenting" list items. Previously it was only possible to import to the same named list e.g. our.site.dev/Lists/Announcents/ - > our.site.test/Lists/Announcents/. Thanks to Alex Angas for submitting this patch.)

Based on the above, my understanding is that I could therefore export the list from http://sitename/pwa/projworkspace1/meetingworkspace1/lists/issues then import it to http://sitename/pwa/projworkspace2/meetingworkspace2/lists/issues.  I was able to export without any error, but when I tried importing and specifying http://sitename/pwa/projworkspace2/meetingworkspace2/lists as the Import Web URL, I found that the content was imported back to http://sitename/pwa/projworkspace1/meetingworkspace1/lists/issues.  What the import did was to create duplicate records for the versions of the field with versioning on, such that if an item was at version 5, a copy of all 5 versions were duplicated, numbered 6 to 10 (I had version options set to Append).  I could have deleted each duplicate version manually.  Instead I deleted all items, thinking that I would be able to import them again.

When I tried to import again into the empty list I got a FatalError: Exception from HRESULT: 0x80040E2F with the log as seen below.  Below the unsuccessful import log is the successful import log when all items were still in the list.  Notes on the logs.

Unsuccessful Import log: The import operation was able to import the first item and the first version, but seemed to stop at the next version.  The error occured after the line which says "Progress: Importing User domain\user1".  Two users were updating the list.

Successful Import log: After the first item was imported successfully, the import operation was able to import user1 and user2 successfully, then proceeded to import the remaining items (18 more were imported successfully).

Appreciate your thoughts on what could have gone wrong and how to rectify it.

Logs follow below. 

******************************************

Unsuccessful Import Log (where error occured), importing to empty list

[11/17/2009 11:21:12 PM]: Start Time: 11/17/2009 11:21:12 PM.
[11/17/2009 11:21:12 PM]: Progress: Initializing Import.
[11/17/2009 11:21:12 PM]: Progress: Starting content import.
[11/17/2009 11:21:12 PM]: Progress: De-Serializing Objects to Database.
[11/17/2009 11:21:12 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues.
[11/17/2009 11:21:12 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues/Attachments.
[11/17/2009 11:21:12 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues/Issue.
[11/17/2009 11:21:12 PM]: Progress: Importing File Lists/Issues/active.aspx.
[11/17/2009 11:21:12 PM]: Progress: Importing File Lists/Issues/AllItems.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/DispForm.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/EditForm.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/Group By Category.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/Group By StatusCategory.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/MyItems.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/NewForm.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing File Lists/Issues/PersonalViews.aspx.
[11/17/2009 11:21:13 PM]: Progress: Importing List Issues.
[11/17/2009 11:21:14 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=1.
[11/17/2009 11:21:14 PM]: Progress: Importing User domain\user1.
[11/17/2009 11:21:14 PM]: FatalError: Exception from HRESULT: 0x80040E2F
   at Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish)
   at Microsoft.SharePoint.SPListItem.AddOrUpdateItem(Boolean bAdd, Boolean bSystem, Boolean bPreserveItemVersion, Boolean bNoVersion, Boolean bMigration, Boolean bPublish, Boolean bCheckOut, Boolean bCheckin, Guid newGuidOnAdd, Int32& ulID, Object& objAttachmentNames, Object& objAttachmentContents, Boolean suppressAfterEvents)
   at Microsoft.SharePoint.SPListItem.UpdateInternal(Boolean bSystem, Boolean bPreserveItemVersion, Guid newGuidOnAdd, Boolean bMigration, Boolean bPublish, Boolean bNoVersion, Boolean bCheckOut, Boolean bCheckin, Boolean suppressAfterEvents)
   at Microsoft.SharePoint.SPListItem.MigrationAddOrUpdate(Boolean bAddNew, Boolean bIsPublish, Guid newGuidOnAdd, Boolean bNoVersion, Boolean suppressAfterEvents)
   at Microsoft.SharePoint.Deployment.ListItemVersionSerializer.AddListItemVersion(SPWeb web, SPListItem listItem, Guid newId, Boolean editHistory, Boolean existsInDb, Boolean isFirst, Boolean isLast, Boolean isDocLib, StreamingContext context, XmlElement listItemData, SPImportSettings settings, ImportObjectManager objectManager, SerializationInfoHelper listItemInfoHelper, String& listItemServerRelativeUrl, ISurrogateSelector selector)
   at Microsoft.SharePoint.Deployment.ListItemSerializer.UpdateListItemVersionData(SerializationInfoHelper infoHelper, SPWeb web, SPListItem& listItem, Guid newId, Boolean existsInDb, Boolean isDocLib, String& listItemServerRelativeUrl, StreamingContext context, SPImportSettings settings, ISurrogateSelector selector)
   at Microsoft.SharePoint.Deployment.ListItemSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
   at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject)
   at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope)
   at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream)
   at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream)
   at Microsoft.SharePoint.Deployment.ImportObjectManager.ProcessObject(XmlReader xmlReader)
   at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects()
   at Microsoft.SharePoint.Deployment.SPImport.Run()
[11/17/2009 11:21:14 PM]: Progress: Import Completed.
[11/17/2009 11:21:14 PM]: Finish Time: 11/17/2009 11:21:14 PM.
[11/17/2009 11:21:14 PM]: Completed with 0 warnings.
[11/17/2009 11:21:14 PM]: Completed with 1 errors.

Successful Import Log, importing to existing list, import created duplicate version records

[11/17/2009 11:12:20 PM]: Start Time: 11/17/2009 11:12:20 PM.
[11/17/2009 11:12:20 PM]: Progress: Initializing Import.
[11/17/2009 11:12:20 PM]: Progress: Starting content import.
[11/17/2009 11:12:20 PM]: Progress: De-Serializing Objects to Database.
[11/17/2009 11:12:20 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues.
[11/17/2009 11:12:20 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues/Attachments.
[11/17/2009 11:12:20 PM]: Progress: Importing Folder /pwa/projworkspace1/meetingworkspace1/lists/Issues/Issue.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/active.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/AllItems.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/DispForm.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/EditForm.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/Group By Category.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/Group By StatusCategory.aspx.
[11/17/2009 11:12:20 PM]: Progress: Importing File Lists/Issues/MyItems.aspx.
[11/17/2009 11:12:21 PM]: Progress: Importing File Lists/Issues/NewForm.aspx.
[11/17/2009 11:12:21 PM]: Progress: Importing File Lists/Issues/PersonalViews.aspx.
[11/17/2009 11:12:21 PM]: Progress: Importing List Issues.
[11/17/2009 11:12:22 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=1.
[11/17/2009 11:12:22 PM]: Progress: Importing User domain\user1.
[11/17/2009 11:12:22 PM]: Progress: Importing User domain\user2.
[11/17/2009 11:12:22 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=10.
[11/17/2009 11:12:22 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=11.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=12.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=13.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=14.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=15.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=16.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=17.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=18.
[11/17/2009 11:12:23 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=19.
[11/17/2009 11:12:24 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=2.
[11/17/2009 11:12:24 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=3.
[11/17/2009 11:12:24 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=4.
[11/17/2009 11:12:25 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=5.
[11/17/2009 11:12:25 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=6.
[11/17/2009 11:12:25 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=7.
[11/17/2009 11:12:26 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=8.
[11/17/2009 11:12:26 PM]: Progress: Importing ListItem /pwa/projworkspace1/meetingworkspace1/lists/Issues?id=9.
[11/17/2009 11:12:26 PM]: Progress: Import Completed.
[11/17/2009 11:12:26 PM]: Finish Time: 11/17/2009 11:12:26 PM.
[11/17/2009 11:12:26 PM]: Completed with 0 warnings.
[11/17/2009 11:12:26 PM]: Completed with 0 errors. 

Nov 17, 2009 at 6:53 PM

Just a followup question: In case I'm not able to successfully import the items to the empty list I described above, is there a way to read the compressed export file so that I can list the contents somehow and enter the items and version updates manually?

Nov 17, 2009 at 7:00 PM

Two more follow up questions if you don't mind:

  1. Beta 2.7 provides copying lists between 2 sites.  Is it possible to copy lists to a different folder in the same site such as from http://sitename/pwa/projworkspace1/meetingworkspace1/lists/issues to http://sitename/pwa/projworkspace2/meetingworkspace2/lists/issues in my example above?
  2. After I exported just the Issues list, I also exported all the contents of http://sitename/pwa/projworkspace1/meetingworkspace1.  Will importing all content to the same location restore the Issues list to its original state if just importing to the empty list in my example above won't work?
Jun 24, 2011 at 2:44 PM

Hi,

I have the same issue at the moment on just 1 list.

Did you worked out the problem already?