4 replies [Last post]
Wuersten
Offline
Joined: 11/25/2011
Error List View Lookup Threshold

Hi,

We have a list with 4 lookup field. I can not browse through this list in the Outlook-Plugin (Outlook 2007). I get the error:
"Die Abfrage kann nicht abgeschlossen werden, weil die Anzahl der darin enthaltenen Nachschlagespalten den vom Administrator durchgesetzten Schwellenwert für NAchschlagespalten überschreitet" (english: The query can not be completed because the number exceeds the contained lookup the threshold set by the administrator.)

With Outlook 2010 there is no problem.

Thanks,
Bernhard

jeanb
Offline
Joined: 04/26/2010
Error List View Lookup Threshold

Hi Bernhard,

I understand you got error “The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator”. SharePoint 2010 limits by default the number of lookup fields that can be queried.
Would you please ask your Sharepoint administrator to increase the number in the 'List View Lookup Threshold' parameter to a larger one in the 'Resource Throttling'. See the following link for more details: http://malikhan.wordpress.com/2009/12/22/throttling-new-features-of-list...

Please let me know before increasing such value what is your current value.

Regards.

----- Jean

Eyal Alalouf
Offline
Joined: 09/14/2010
Hi, Bernhard. I'd like first

Hi, Bernhard.

I'd like first to clarify that as far as we know the Outlook version (2007 or 2010) does not have an impact on this type of server errors.
After consulting with my colleagues, we believe that the best way to proceed would be to record the interaction between harmon.ie and the SharePoint server. Only afterwards we may proceed with a test patch.
If this is OK by you, please download and install fiddler (a utility to sniff http requests).
Please run fiddler, restart Outlook (while fiddler is running) and then navigate to the problematic library.
Fiddler should register all the http interaction. Please send me ALL of the fiddler interaction.
My email is 'eyala@harmon.ie'. If you have any issues with fiddler or the above instructions please don't hesitate to contactme directly by e-mail or via this forum.

Thanks, Eyal.

Eyal Alalouf
Offline
Joined: 09/14/2010
Thank you for reporting this

Thank you for reporting this issue. We were aware that throttling existed in 2010 and so resolved the issue there. We can definitely enable the same logic for 2007 as well. Will you be intereseted in a test fix to see if this indeed resolves the issue?
If so, please let me know your Outlook version and what kind of version you have installed (free, eneterprise, or evaluation).

Thanks, Eyal.

Wuersten
Offline
Joined: 11/25/2011
text fix

Hi,

There is no problem to test a fix.
We habe installed Office 2010 (SP1) on this PC this morning, but we have still the same error.
At this moment we try the free version (We will change to the enterpriseversion after resolve the problems).

Thanks,
Bernhard