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.
To resolve this problem, apply the following two updates:
973409Â
(http://kbalertz.com/Feedback.aspx?kbNumber=973409/
)
Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (Coreserver.msp): August 25, 2009
973410Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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).