如果您尝试在Windows 10上通过^{(Windows 10)}OneDrive for Business同步^(Business)SharePoint库并收到以下任何错误：

• 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; Error source=Groove
• Unspecified error, Error code=0x80004005; Error source=Groove

然后在这篇文章中，我们提供了解决这两个看似不同的错误的解决方案。

我们无法同步此库 0x80070093、0x80004005 - OneDrive错误

SharePoint 库^{(SharePoint library)}是网站上的一个位置，您可以在其中上传、创建、更新文件并与团队成员协作处理文件。每个库都显示文件列表和有关文件的关键信息。当您通过公司或学校提供的帐户使用 OneDrive 时，它​​称为OneDrive for Business。

错误^(Error)代码=0x80070093；错误^(Error)来源=凹槽

要解决此问题，您需要减少受影响的SharePoint Online列表中的查阅列数，然后尝试同步库。执行此操作，直到不再触发错误。

要删除列，请执行以下操作：

1. 导航到受影响的SharePoint Online列表。
2. 单击 SharePoint功能区上的^(SharePoint)库^(LIBRARY)选项卡，然后单击 库设置^{(Library Settings)}。
3. 在列列表中，单击要删除的列的名称。
4. 单击 “编辑列^{(Edit Column)}”页面底部的“删除^(Delete)” ，然后单击“ 确定^(OK)” 。

注意：^(Note:) Â 在删除列之前，请考虑这可能会如何影响列表。

错误^(Error)代码=0x80004005；错误^(Error)来源=凹槽

此问题通常来自损坏的客户端缓存，要修复它，您需要重建本地客户端缓存。

方法如下：

备份^(Backup)您同步的所有文件！如果您使用默认存储位置，所有文件都将在其中；

C:\Users\%username%\OneDrive for Business

现在，通过右键单击系统托盘中的OneDrive for Business图标，然后单击停止同步文件夹来停止同步所有内容。如果您有多个库，请对所有库重复此操作。

右键单击系统托盘中的Microsoft Office 上传中心^{(Microsoft Office Upload Center)}图标。单击设置^(Settings)，然后单击清除缓存^{(Clear Cache)}。

右键单击系统托盘中的^{(System Tray)}Microsoft Office 上传中心^{(Microsoft Office Upload Center)}图标，然后单击退出。^(Exit.)

接下来，按Ctrl+Shift+Esc启动任务管理器^{(Task Manager)}并终止正在运行的GROOVE.EXE和MSOSYNC.EXE进程。

现在，按Windows+R调用“运行”^(Run)对话框。将下面的路径复制^(Copy)并粘贴到框中，然后按 Enter^(Enter)：

%USERPROFILE%

重命名OneDrive for Business文件夹和 SharePoint 文件夹以进行备份。

再次打开Run对话框，但这一次，复制并粘贴下面的路径，然后按 Enter^(Enter)：

%USERPROFILE%\AppData\Local\Microsoft\Office\15.0\

在该位置，继续删除OfficeFileCache、SPW和WebServiceCache文件夹。跳过^(Skip)任何无法删除的文件，并且并非所有用户都拥有所有这些文件夹。

重新启动您的电脑。

在启动时，尝试重新同步库。您将收到一个提示，询问您希望同步哪些URL 。^(URLs)

专业提示^{(Pro Tip)}：不使用URL^(URLs)的更简单方法是打开要同步的网站集，然后单击功能区中的“同步”按钮。这会自动启动已安装的OneDrive客户端（如果您使用IE/Edge并且没有任何配置错误）。在默认的Windows安装中，这是开箱即用的。

We couldn't sync this library 0x80070093, 0x80004005 - OneDrive error

If when you try tо sуnc a SharePoint library vіa OneDrivе for Business on Windows 10 and receive any оf 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; Error source=Groove
• Unspecified error, Error code=0x80004005; Error source=Groove

then in this post, we provide the solution to remediate these two seemingly distinct errors.

We couldn’t sync this library 0x80070093, 0x80004005 – OneDrive error

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.

Error code=0x80070093; Error source=Groove

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:

1. Navigate to the affected SharePoint Online list.
2. Click the LIBRARY tab on the SharePoint ribbon, and then click Library Settings.
3. In the list of columns, click the name of the column that you want to delete.
4. 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.

Error code=0x80004005; Error source=Groove

This issue often comes from a damaged client cache, to remediate it, you’ll need to rebuild the local client cache.

Here’s how:

Backup 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.

Related posts

• 当同步自动暂停时禁用OnedRive通知

• Fix OneDrive error code 0x8004de40在Windows 10上

• 修复OnedRive错误代码0x8007016A

• OnedRive Error 0x80070194，cloud file provider意外退出

• Allow OneDrive以禁用permission inheritance在只读文件夹

• 你PC isn't连接到互联网，OneDrive Error 0x800c0005

• 如何使用OneDrive访问Windows 10 PC上的文件

• OneDrive Activity Center现在房子Settings and Pause menus

• OneDrive中的Remove Outlook .pst在Windows 10中的数据文件

• 如何检查OneDrive storage空间

• 如何解决在Windows 10 OneDrive sync问题

• 如何在Local Group Policy Editor中添加OneDrive同步设置

• Microsoft OneDrive Privacy Settings and Policy解释

• OnedRive Personal Vault显示了错误的语言

• OneDrive不节能Word文件 - 这不是一个有效的file name

• 如何在OneDrive中恢复以前版本的Document

• OneDrive缩略图未显示在Windows 10上

• 从Windows 10中从Context Menu中删除Move至OneDrive

• OnedRive VS Google Drive - 哪个是更好的Cloud Service？

• 此项目可能不存在或不再可用 - OneDrive错误