0

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example

<Where>
    <Eq>
      <FieldRef Name='Column' LookupId='TRUE' />
      <Value Type='Lookup'>2</Value>
    </Eq>
</Where>
<OrderBy><FieldRef Name='Title' /></OrderBy>

However when I try to make a filter for another item and this item has more than 6k of an error timeout

Caml:

<Where>
    <Eq>
      <FieldRef Name='Column' LookupId='TRUE' />
      <Value Type='Lookup'>1</Value>
    </Eq>
</Where>
<OrderBy><FieldRef Name='Title' /></OrderBy>

Error:

at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) 
   at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) 
   at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() 
   at Microsoft.SharePoint.SPListItemCollection.get_Count() 

Note I'm using the RowLimit = 20. Have any alternative for this error?

  • What is the lookup threshold on the list? – Robert Lindgren Dec 12 '13 at 16:55
  • List View Lookup Threshold: 50 – Tiago Dec 12 '13 at 17:22
  • List View Threshold: +500k – Tiago Dec 12 '13 at 17:32
  • how many items are there total in the list? What do the ULS Logs say? – Mike Dec 12 '13 at 19:09
  • the total number of items is +164 k. I never saw the uls log – Tiago Dec 12 '13 at 20:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.