On SharePoint 2013 I have a basic document library with enterprise keywords enabled and one additional "People or Group" column set to "People only" (not as a multi value field).
Now I try to sync the library with SkyDrive Pro. It fails with the following error message:
The message details:
The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator. Error code=0x80070093; Error source=Groove
Ok, if you count the enterprise keywords and the people field as lookup fields I have 2. The default "List View Lookup Threshold" (Central Admin –> Web Application –> Resource Throttling) is 8.
Then I tried to set the value to 16. Bam! Now everything is working again. I have no idea why and how 8 shouldn’t be enough with my 2 additional columns (which are of course not even lookup columns).