SharePoint 2013 “Content Viewing” audit report takes forever to “working on it"

Shri-6058 326 Reputation points
2021-04-07T06:24:10.64+00:00

Hi
My intranet shows 115000 documents after completing the search indexing/crawling. I want to find out all the documents, content based on the view/visit list/library data.

There is a "Content Viewing" option under Site Settings -> Audit report . It works if I narrow down I use Custom report, check event "Opening or downloading documents, viewing items in lists, or viewing item properties", the custom report is generated quickly for the specific list or library but if I make selection as the default Content Viewing option, it takes forever and sometime it throws error:

[Forced due to logging gap, cached @ 04/07/2021 00:01:47.77, Original Level: Verbose] SQL connection time: 0.103218956898713 for Data Source=SPPortalServerDB;Initial Catalog=WSS_Content_Intranet;Integrated Security=True;Persist Security Info=False;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;PoolBlockingPeriod=Auto;Asynchronous Processing=False;Connection Reset=True;MultipleActiveResultSets=False;Replication=False;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;Load Balance Timeout=0;Packet Size=8000;Type System Version=Latest;Application Name=".Net SqlClient Data Provider";User Instance=False;Context Connection=False;Transaction Binding="Implicit Unbind";ApplicationIntent=ReadWrite;MultiSubnetFailover=False;TransparentNetworkIPResolution=True;ConnectRet... 90d435erter-3c37-c080-0a76-7666bad57930

Will you please assist me on generating the report? Please let me know any guidance on fixing this.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,625 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,799 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jerry Xu-MSFT 7,921 Reputation points
    2021-04-08T08:03:30.337+00:00

    Hi, @Shri-6058 ,

    Forced due to logging gap is in fact not an error message but a message of time out. You can check the ULS log for more detailed information for possible error message. You can use a ULS viewer for troubleshooting.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments