locked
Throttling limit is exceeded by the operation RRS feed

  • Question

  • We receive this error when accessing SharePoint documents from within CRM for document libraries that have more than 5,000 documents within the library. Removing documents from any of the libraries in question to get the total count under 5,000 resolves the issue.

    Does anyone know of a workaround? Was on with MS support and they could only come up with the idea of creating additional document libraries within SharePoint - then having Accounts (default library created by CRM/SP integration), Accounts2, Accounts3, etc. each having less than 5,000 documents. But then how to have the Account entity in CRM linked to each document library without having to manually add the document library for the Account record?

    We are a service organization using Resco mobile for CRM, and the goal is for technicians to go into a customer records and take photos of client equipment. The photos then sync to CRM and invisibly are added to Account document library in SharePoint. Was working great as a process until we reached 5,000 record limit.

    Monday, December 8, 2014 3:15 PM

Answers

  • So, until there is a cleaner solution, create a new Document library (or libraries) in SharePoint. The number of libraries to create should depend upon the number of documents that get uploaded through CRM for a given time period. For us, we have about 3,000 documents added to an entity each month, so will create a document library for each month. Let's say we are talking about Accounts.

    By default, we have a SharePoint document library called Accounts. Will create new libraries for:

    Account_Dec2014

    Account_Jan2015

    etc.

    Solution, in this case, is to create a workflow that will add documents to the appropriate SharePoint site child location based upon the month that the document is being created.

    Monday, December 15, 2014 8:59 PM

All replies

  • Does anyone think it would be possible to potentially write some sort of plugin that would create a separate document library for each account within SharePoint? Would SharePoint allow thousands of document libraries?
    Tuesday, December 9, 2014 2:55 PM
  • I'm encountering the exact same issue..

    Any feedback would be appreciated.

    Saturday, December 13, 2014 9:12 AM
  • So, until there is a cleaner solution, create a new Document library (or libraries) in SharePoint. The number of libraries to create should depend upon the number of documents that get uploaded through CRM for a given time period. For us, we have about 3,000 documents added to an entity each month, so will create a document library for each month. Let's say we are talking about Accounts.

    By default, we have a SharePoint document library called Accounts. Will create new libraries for:

    Account_Dec2014

    Account_Jan2015

    etc.

    Solution, in this case, is to create a workflow that will add documents to the appropriate SharePoint site child location based upon the month that the document is being created.

    Monday, December 15, 2014 8:59 PM
  • Hello Rocky,

    Is it the only solution to have multiple document libraries for one entity in CRM?

    When opening the docs from CRM how the dynamic mapping works if we have to maintain more than once document library in sharepoint?

    Waiting on your reply

    Thanks,

    Raj.


    Raj

    Thursday, February 18, 2016 11:30 AM
  • If you have more than 5000 items in a document library (irrespective of how they are divided into folders/document locations in CRM) you can still view documents in a CRM view but if you try to sort by any column other than location like name/content type etc. you'll receive this error. It is coming from Sharepoint's CAML query limit.
    This is documented in the SDK - see the section on Resource Throttling - https://technet.microsoft.com/en-us/library/dn792527.aspx

    The only work around is to create separate document libraries to keep the number of items below 5000 but I find that sorting in CRM isn't really needed since users can use the 'Open in SharePoint' button if they want to do more advanced views of the documents.



    Scott Durow
    Blog www.develop1.net    Follow Me
    Rockstar365
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Friday, February 19, 2016 5:57 PM
    Answerer