Forum Discussion
SharePoint Caching Problems with Lists
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!
At least we are not the only ones. When you say it is "solved" by clearing the cache, do you mean permanently? Whenever I clear the cache it loads correctly the next time, but then the problems return when they navigate away from and back to the list (including the issue of deleting my list item JSON formatting code).
- At my company we have something similar for some users. And this is working only when the browser cache is cleared but only once you are working with the list.
If you go to another website and jump back in the list the issue comes back. So basically you will have to close the browser each and every time you go out of the list. INSANE!
Our issue is with with the view/edit form of the standard SharePoint list. If you double click on a selected item, the standard view/edit form is blank and no data is showing. Even if you were to click button: EDIT ALL in the view/edit form, the data wouldn't appear for that particular item.
Additionally, the view-formatting JSON is not saved as well if you were to paste it in.
The thing is that not all of the lists are affected by this issue.
However, if you were to copy the link to the item and paste the link into another browser tab the data is shown in the full screen form view, with the view-formatting JSON applied correctly.
Some users say that this issue occurred after a Windows Update. Not sure if that is the main reason.