If when you try to sync a SharePoint library via OneDrive for Business on Windows 11/10 and receive any of these errors:
- The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator. Error code=0x80070093
- Unspecified error, Error code=0x80004005
then in this post, we provide the solution to remediate these two seemingly distinct errors. It implies that you have entered a value that was not recognized by the OneDrive. In other words, you are not complying with the predefined value set by your administrator.
We couldn’t sync this library OneDrive error 0x80070093, 0x80004005
A SharePoint library is a location on a site where you can upload, create, update, and collaborate on files with team members. Each library displays a list of files and key information about the files. When you use OneDrive with an account provided by your company or school, it’s called OneDrive for Business.
Fix OneDrive Error code 0x80070093
To remediate this issue, you need to reduce the number of lookup columns in the affected SharePoint Online list, and then try to synchronize the library. Do this until the error is no longer triggered.
To delete a column, do the following:
- Navigate to the affected SharePoint Online list.
- Click the LIBRARY tab on the SharePoint ribbon, and then click Library Settings.
- In the list of columns, click the name of the column that you want to delete.
- Click Delete at the bottom of the Edit Column page, and then click OK.
Note: Before you delete a column, consider how this might affect the list.
Fix OneDrive Error code 0x80004005
This issue often comes from a damaged client cache, to remediate it, you’ll need to rebuild the local client cache.
Here’s how:
Back up all files you have in sync! If you use the default storage place all files would be in-
C:\Users\%username%\OneDrive for Business
Now stop syncing everything by right-clicking on the OneDrive for Business icon in the system tray then clicking stop syncing a folder. Repeat this for all libraries if you have more than one.
Right-click on the Microsoft Office Upload Center icon in the System Tray. Click Settings and then click Clear Cache.
Right-click on the Microsoft Office Upload Center icon in the System Tray and click on Exit.
Next, press Ctrl+Shift+Esc to launch the Task Manager and terminate GROOVE.EXE and MSOSYNC.EXE processes if they are running.
Now, press Windows+R to invoke the Run dialog box. Copy and paste the path below into the box and hit Enter:
%USERPROFILE%
Rename your OneDrive for Business folder and your SharePoint folder for backup purposes.
Open the Run dialog box again but this time, copy and paste the path below and hit Enter:
%USERPROFILE%\AppData\Local\Microsoft\Office\15.0\
At the location, proceed to delete the OfficeFileCache, SPW and WebServiceCache folders. Skip any files that cannot be deleted and not all users will have all these folders.
Restart your PC.
On boot, try to re-sync the library. You’ll get a prompt asking you which URLs you wish to sync.
Pro Tip: The easier way instead of using URLs is to open the site collection you want to get synced and then click the “sync” button in the ribbon. This automatically launches the installed OneDrive client (if you use IE/Edge and if nothing is configured wrong). On a default Windows installation, this is working out of the box.
What is error code 0x80004005 on OneDrive?
The error code 0x80004005 appears while using OneDrive for Business when your computer has stored old cache files. As a user, you won’t be able to set up or synchronize your library via SharePoint Online Client. As a result, Windows fails to let you use OneDrive for Business – no matter whether you use Windows 11, Windows 10, or any other version.
What is Microsoft account issue error code 0x80004005?
There are three things you need to know about this error code or why it appears on your computer. First, this error arises when your computer fails to set up OneDrive for Business. Second, it implies that there is a problem with the subscription. In that case, you need to check with the system administrator. Third, if there is an old cache stored on your computer, you can find the same error code while setting up OneDrive for Business.
That’s all! I hope this guide helped you.