0

I am working with document sets in a document library with roughly 700k items. I am experiencing list view throttling errors while trying to create a document set version via the "Capture Version" button in the ribbon. Each document set contains 6 documents at maximum. List view threshold is 5k for users and 20k for administrators.

The error message is straightforward.

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

When I look up the error in the logs via the correlation Id, the log states:

Throttled:Big list slow query. List item query elapsed time: 0 milliseconds

Here is the CAML query that is causing the error. This is out of the box functionality, not a custom query someone wrote.

<View>
    <Query>
        <Where>
            <IsNotNull>
                <FieldRef Name='CheckoutUser'/>
            </IsNotNull>
        </Where>
        <OrderBy Override='TRUE'>
            <FieldRef Name='FileDirRef' />
            <FieldRef Name='FileLeafRef' />
        </OrderBy>
    </Query>
    <ViewFields>
        <FieldRef Name="ID" />
        <FieldRef Name="Title" />
        <FieldRef Name="FileRef" />
        <FieldRef Name="FileDirRef" />
        <FieldRef Name="FileLeafRef" />
        <FieldRef Name="FSObjType" />
        <FieldRef Name="ContentTypeId" />
    </ViewFields>
    <RowLimit Paged="TRUE">2147483647</RowLimit>
</View>

Any idea why SharePoint is throwing this throttling error when trying to capture the document set version through the UI?

0

Well, this is not an answer because I do not know how this CAML query is related to capturing the version, but I can tell you that indeed this CAML query will not work for large lists.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.