Error when Activating the SharePoint Server Publishing Infrastructure feature
Seem to be getting a strange error when trying to activate the SharePoint Server Publishing Infrastructure: The error is: Error 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. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 277c8525-6023-489c-bde8-d17dd066f8fb Date and Time: 16/02/2011 10:24:36 In Event Log the error is: Event log message was: 'Failed to create the 'Quick Deploy Items' list.'. Exception was: 'Microsoft.SharePoint.SPException: 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. ---> System.Runtime.InteropServices.COMException (0x8102003A): 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. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) --- End of inner exception stack trace --- at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) at Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) at Microsoft.SharePoint.SPFieldCollection.AddInternal(String strDisplayName, SPFieldType type, Boolean bRequired, Boolean bCompactName, Guid lookupListId, Guid lookupWebId, StringCollection choices) at Microsoft.SharePoint.SPFieldCollection.Add(String strDisplayName, SPFieldType type, Boolean bRequired, Boolean bCompactName, StringCollection choices) at Microsoft.SharePoint.SPFieldCollection.Add(String strDisplayName, SPFieldType type, Boolean bRequired) at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.CreateQuickDeployItemsList()' This is not an upgrade of any kind, it was a new installation and i am in the progress of setting up the FAST Search features however without being able to activate this feature i cannot do this. Thanks
February 18th, 2011 9:28pm

Microsoft SharePoint Foundation is SharePoint 2010, so I'd expect Mike to move this to the correct forum quite soon. In response to your question, this behaviour happens when you try to add more columns than your Windows SharePoint Services list supports. There are limits on the number of columns that you can create in a Windows SharePoint Services list. The limits are determined by the column type that you use for the list. I'm not sure what the SharePoint 2010 ones are, but for example the SharePoint 2003 ones were as follows: - 64 Single line of text and Choice (drop-down menu or radio buttons) 31 Multiple lines of text and Choice (check boxes (allow multiple sections)) 32 Number and currency 32 Hyperlink 16 Date and time 16 Lookup 16 Yes/No 8 Calculated Now, to your instance, can tell us if you've used the Quick Deploy Feature? It looks like this is the root of your issue. Please check this link for how to check/turn off Quick Deploy jobs: http://technet.microsoft.com/en-us/library/cc262560.aspx. If you've got one running, try stopping them all and reactivating the feature on your site. http://www.final-exodus.net
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 10:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics