Error message when you try to run a search query in SharePoint Server 2007 by using the SOME ARRAY clause: "Your Query Malformed"

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
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:
Your Query Malformed.
This problem occurs when the SOME ARRAY clause contains more than 32 elements.
RESOLUTION
To resolve this problem, apply the following two updates:
973409 Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (Coreserver.msp): August 25, 2009
973410 Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): August 25, 2009
After 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.

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).
Properties

Article ID: 973101 - Last Review: 01/16/2015 04:01:58 - Revision: 1.0

  • Microsoft Office SharePoint Server 2007
  • kbnosurvey kbarchive kbexpertiseadvanced kbqfe kbsurveynew kbprb KB973101
Feedback