SharePoint 2007 2010 migration – cannot activate Publishing Infrastructure – column limit exceeded

You migrated your SharePoint 2007 site to SharePoint 2010 using database attach.

Your site was publishing but after migration, you notice that Publishing Infrastructure site collection feature is not activated.

You try to activate and you get:

Column Limit Exceeded.

There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type.

I found this post helpful to solve this issue

After deleting fields from Quick Deploy Items I get another error when activating:

Failed to create “Reusable Content” library. Original exception: Column ‘ShowInRibbon’ does not exist. It may have been deleted by another user.

Ok, tricky,  in some msdn posts suggest to delete Reusable Content list, which obviously exists on the site. In my case, I cannot delete it as it contains lots of reusable content.

So I tried be smart and I just have created column “ShowInRibbon”.

After that – Activation succeeded!

I am not sure if this is the end of adventures with this particular site, I am still missing few things, such as “Create page” in site Actions… Wish me luck :)



Leave a Reply