How to Fix – Publishing Site Content Deployment Error – Duplicate First Name Column

Content Deployment was failing with the following error in the logs:

Title: Field name already exists. The name used for this field is already used by another field in the list. Select another name and try again.

Severity: Error

Object: User Information List

We had a publishing site that was upgraded from SharePoint 2007 to SharePoint 2010 that was using content deployent from a staging site to a deployed site.

We could see using SharePoint Manager 2010 that we had duplicates in the destination site that were not in the source site.

Duplicates in destination server

We opened a job with Microsoft and we found someone with a similar issue on the msdn forums

Microsoft gave us an executable ‘RemoveDuplicateColumn64‘ to remove the duplicates, we ran it for each duplicate.

The exe prompts you for all the required parameters, one of which is the duplicate internal name which in our case was FirstName0, again we used SharePoint Manager to find the internal name.

We have no idea how these duplicates got there but since removing them a couple of months ago there have been no problems with the content deployment.

This problem could likely be avoided by using the new snapshot content deployment available in SharePoint 2010.


About SharePoint Surfer

A SharePoint professional working in local council, experiencing the pointy end of SharePoint.

Posted on April 27, 2012, in Content Deployment, SharePoint and tagged , , , , . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: