Forum Discussion
robertchamplin
Oct 21, 2021Copper Contributor
SharePoint Caching Problems with Lists
I have been having odd behaviors with regard to configuring SharePoint lists that started occurring the last 2 days: (1) When adding list columns they do not show up until I refresh the page (2) Wh...
- Jan 13, 2022
Hi group, I did some digging on this and believe I have found the issue for our tenant.
The OneDrive client appears to be syncing Lists from SharePoint Online (et. al) by default. To verify this is what is happening, you can perform the following steps:
- Open Dev Tools on Chrome (F12)
- Navigate to "Network"
- Select "Fetch/XHR" as type
- Enter "RenderListDataAsStream" as a filter
- Attempt to sort a list that is cached
The results should show "localhost", "::1", or an equivalent loopback address under the "Remote Address" column.
You can then use resmon, netstat or Get-NetTCPConnection/Get-Process to find the IM of the process name and ID of the port being used for these local XHR requests to the RenderListDataAsStream endpoint. In my scenario, it was port 42050 (probably randomized), which was shown in use by the Microsoft.SharePoint.exe application, located under \AppData\Local\Microsoft\OneDrive\<version number>.
If you see this behavior, you can attempt to mitigate the caching by:
- Setting
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
(per MS Docs - Use Group Policy to control Lists sync settings ) - Rebooting machine, or force closing the task with IM of "Microsoft.SharePoint.exe".
- Reloading the list page (may need to force-refresh).
This appears to be working on our test machines (all Modern UI queries are forced to use the SPO servers instead of OD), but I'm not entirely sure of the effect this setting could have in regards to SP, OneDrive, Teams, etc - so it should probably be used with caution.
Hopefully this helps your tenants as well. Good luck!
Matthew Carter
Feb 22, 2022Iron Contributor
Did you try any of the fixes and if so, did they work?
robertchamplin
Feb 23, 2022Copper Contributor
I am unfortunately not in a position to push a change like that out to everyone's PC to fix it, and it doesn't help me to only fix it on my PC because everyone else still overwrites the formatting when they access the list, so I've had to push it to the back burner and move on.
- pdfrigFeb 24, 2022Brass ContributorFor now, maybe try changing List Settings - > Advanced Settings -> Set Offline Client Availability to 'No' to the list you’re having issues with. This way, you don’t have to push out any changes to users. This appears to be working for us so far.
- jonasloesleJul 27, 2023Copper Contributor
pdfrig Is there anything else I need to do besides disabling offline availability. One user is having trouble with a list but when I disable the feature the sync icon is still there. When I clear the cache, the problem is gone for a short time and is back after a reload of the page.
- naufal-PutraMar 28, 2023Copper Contributor
Thank you for this!
We were experiencing this issue yesterday, it happened when we filtered a column to a specific value and it shows an empty list. But we know the data is there because when we check through another filter it is showing.
I thought by clearing the cache was the solution, but apparently it's just a temporary one. Your advice works!