Mar 21 2019 05:04 AM
Some colleagues have had issues for a week now accessing files which are stored on SharePoint via the OneDrive sync App.
When opening them they get the Error code 0x80070185 (See image)
Hitting OK doesn't do anything. Skip opens the files sometimes. No correlation about file format or location.
We reset OneDrive, unlinked it, cleared space... to no avail. Any ideas?
This is Windows 10 with the latest OneDrive release. Files on Demand is enabled.
Thanks
Mar 21 2019 05:34 AM - edited Mar 21 2019 05:34 AM
Mar 21 2019 05:34 AM - edited Mar 21 2019 05:34 AM
Just noticed these posts with the same issue and similar error code. Apparently is not new:
https://techcommunity.microsoft.com/t5/OneDrive-for-Business/Files-on-Demand-The-Cloud-sync-engine-f...
Apr 30 2019 08:50 AM
May 01 2019 02:11 AM
Same problem here and a bit frustrering :(
Tried:
Reinstall Onedrive client
Clean tool
Reinstall Office 365 (desktop clients)
May 01 2019 02:17 AM
May 24 2019 01:18 PM
Hello All. I had the same issue. After a few days of troubleshooting I developed a fix. You essentially need to open each file in the cloud and get people to restart their OneDrive client. Opening the file triggers the repair. Below is my findings. I included a fix at the bottom.
Effected Files: Only Office files that were migrated from network drives using the SharePoint migration tool (likely ''SharePoint Migration Tool Public Preview). Confirmed it affects old legacy office files (.doc, .xls, etc...) and new (docx., xlsx, etc...). Does not happen with PDFs. I can consistently reproduce the problem on multiple sites and with multiple computers/users but only on files migrated using the tool.
Troubleshooting:
-Most of the time pressing retry 1-3 times works. The file then open successfully even if it's loaded back to the cloud and re-downloaded. Noticed the file sometimes gets ~2kb's bigger as soon as you open it for the first time (right after file is downloaded before it opens in Office). Opening it a second time only fixes it for the local computer. The file is fixed on all computers as soon as it is modified and uploaded back to the cloud.
- Confirmed it was not anti-virus. Uninstalled Vipre and issue still happened. I have noticed that Vipre crashes sometimes after the OneDrive error message. Replicated issue on two computers. Uninstalling Vipre does not fix OneDrive error. Confirm Vipre crashing is a separate known issue (VPBAGENT-3652 - Microsoft OneDrive users could encounter a VIPRE service crash when attempting to access OneDrive documents. link)
- Confirm issue still occurs on other wifi networks. Confirmed it happens on wired and wireless connection.
- Confirmed it happens with small and large files (22 KB - 25+ MB).
- Confirmed issue is happening on latest OneDrive version 19.070.0410.0005.
- Confirmed issue happens on sites where all the default library settings are kept (no special columns or metadata).
- Started re-index of document library. Checked 24+ hours later and confirmed issue is still occurring.
- Confirmed previewing the file in SharePoint Online does not trigger the file size increase/fix it.
The following steps appear to fix the problem on an individual file/folder:
Here is what I did to fix the problem on our sites without having to move any files:
Get-ChildItem -Path 'INSERT MAPPED DRIVE HERE' -Include "*.xls*","*.doc*","*.ppt*" -Recurse | ForEach-Object {
$_.FullName
Get-Content -Path $_.FullName -first 1 | Out-Null
}
End result is people no longer get the error message and I didn’t need to move the files. It also maintains all file properties since I am just reading the file. Also has no impact on users who have documents open so it can be run during office hours.
If you have files that are over 50 mb you may need to modify your registry so the WebClient service can open them. Otherwise you will get an 'The file size exceeds the limit allowed and cannot be saved.' message in powershell. https://www.thewindowsclub.com/file-size-exceeds-limit-allowed-cannot-saved
Jun 17 2019 04:03 AM - edited Jun 17 2019 04:04 AM
We have tried the simple fix as described by Kevin here
and can happily say it has resolved our issues.
Select files to "keep offline" and then select "free up space"
Jun 19 2019 06:34 PM
Came back here to follow JustinKropp's guide and found I can no longer reproduce the error. Has this been fixed?
Jun 19 2019 06:41 PM - edited Jun 19 2019 06:43 PM
Jun 19 2019 09:29 PM
I believe they have, or at least it seems to work now. When we first encountered this error, it was part of a very large network shared drive that was migrated with the MS migration tool - the clients haven't been accessing files via OneDrive yet. I encountered the bug on about 10 files before I realised it was site-wide. Recent testing, as the clients are ready to move, in directories noone would explore to, I have not been able to duplicate the error. Unfortunately, I only have this one site to test with.
Jul 09 2019 07:18 PM
@JustinKropp - Thanks a million for your work here.
I have been struggling with this exact problem for around 3 months, and have been working through the basic steps with MSFT Partner Support. After being able to find no fault, their position was "you need to reduce the file count in the libraries and only sync one library". Needless to say, that wasn't an acceptable solution for the customer.
After being pointed to your thread, I ran your scripts against the relevant libraries and then reset the local OneDrive cache. A week later, the team report absolutely no errors trying to open Excel files from the library!
Thanks very much for all your work here, and for sharing your analysis and the powershell scripts. Absolutely fantastic.
If you ever find yourself in northern Australia, the beers are on me.
Cheers,
Matt
Dec 11 2019 02:09 PM
Jun 30 2020 06:30 AM
Tive o mesmo problema com uma pessoa na rede da em empresa onde eu trabalho.
Abri o SP no navegador (qualquer um) e validei com o o login de rede do colaborador da empresa, houve um sincronismo online e o erro parou de ser exibido.
Mar 30 2023 10:59 PM
Same here.
Tried all the generously provided tips.
Wait for more
Thanks to all for trying