Managed Metadata Item Term Limit

It looks like there is a limit to the number of Managed Metadata terms a particular item can have.  In my experimenting, it was 192.  The 193 would generate a SQL Server exception and limitation.  SQL Server has a limit of 2,100 parameters per stored procedure and per user-defined function.  While walking through the code with 192 terms, the SharePoint List item was saved successfully.  When adding the 193rd item, the query fails:

Capture[5]

The managed metadata terms used on this item were:

Adding another term to that list, in my case, “81”, would generate the above error upon saving the document.  SharePoint will report the following in the Application Event Log:


Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 7/22/2012 10:34:23 AM
Event ID: 5586
Task Category: Database
Level: Error
Keywords:
User: NAUPLIUS\trevor
Computer: SHAREPOINT.nauplius.local
Description:
Unknown SQL Exception 8003 occurred. Additional error information from SQL Server is included below.

The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

Additionally, the ULS log will report the same error under SharePoint Foundation –> Database at both High and Critical levels.  Unfortunately, there is nothing about this type of limitation on the SharePoint Software Boundaries and Limits page.

To view the query generated by attempting to update the item with more than 2,100 parameters, take a look at the following SQL script.

2 Comments

  1. Does anyone know if this limitation is Changed in SharePoint 2013?

Leave a Reply