Article ID: 973101 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Consider the following scenario. You define a multiple value choice column in a Microsoft Office SharePoint Server 2007 document library. A managed property is mapped to the column. You try to run a search query. In this scenario, when the value of the managed property is returned by the SOME ARRAY clause, you receive the following error message:
This problem occurs when the SOME ARRAY clause contains more than 32 elements.
Your Query Malformed.
To resolve this problem, apply the following two updates:
(https://support.microsoft.com/kb/973409/ )Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (Coreserver.msp): August 25, 2009
973410After you apply these updates, if the element type is String, the size of the SOME ARRAY clause can be increased to a maximum of 500 elements.
(https://support.microsoft.com/kb/973410/ )Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): August 25, 2009
If the element type is not String, the size of the SOME ARRAY clause can be increased to a maximum of 1,000 elements.
The total maximum size of the array query is 4 kilobytes (KB).