I have 40000 items in a document library. The threshold is set to 2,000 items at CA.
All documents can render all the items.
But if I add grouping on a column "Contract Number" (which is a combination of letters and numbers) then the view fails and gives following error. The reason for grouping is there are 100s of contract that has the same Contract Number.
What are my options in order to get grouping on columns like these.
Server Error in '/' Application.
--------------------------------------------------------------------------------
Attempted to use an object that has ceased to exist. (Exception from HRESULT: 0x80030102 (STG_E_REVERTED))
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Attempted to use an object that has ceased to exist. (Exception from HRESULT: 0x80030102 (STG_E_REVERTED))
Source Error: