如何修复“[OData Source [56]] 错误:无法从运行时连接管理器获取托管连接."SSIS中的错误? [英] How to fix "[OData Source [56]] Error: Cannot acquire a managed connection from the run-time connection manager." error in SSIS?

问题描述

我在运行从 SharePoint 列表中提取数据的 SSIS 时遇到问题.SSIS 包运行良好，直到 2 周前，突然包失败并出现此错误:

I am having problem when running SSIS which extracts data from SharePoint list. SSIS Package was running fine till 2 weeks back and suddenly the package is failing with this error:

[OData Source [56]] 错误:无法从运行时连接管理器获取托管连接.[SSIS.Pipeline] 错误:OData 源验证失败并返回错误代码 0xC020801F.[SSIS.Pipeline] 错误:一个或多个组件验证失败.错误:任务验证过程中出现错误

[OData Source [56]] Error: Cannot acquire a managed connection from the run-time connection manager. [SSIS.Pipeline] Error: OData Source failed validation and returned error code 0xC020801F. [SSIS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation

试过了:

1. 将包属性中的 64 位调试选项更改为 false
2. http:// 而不是 https://

我希望 SSIS 包能够从 SharePoint 列表中提取数据而没有任何问题，但最近遇到了上述错误消息，该错误消息运行了一年多.

I expect SSIS package to extract data from SharePoint list without any issues but facing the above error message recently which was working fine for more than a year.

服务器详情:Windows server 2012 R2.

Server detail: Windows server 2012 R2.

应用详情:Visual Studio 2010，.NET 框架 - 4.5

Application details: Visual studio 2010, .NET framework - 4.5

---

更新@2019-02-17

我们没有使用 Windows 身份验证，即使在以管理员身份运行 SSDT 后，SSIS Passage 也会失败.我们可以在 ODATA 源中预览 Sharepoint 列表数据，但在触发时包会失败并出现上述错误消息

---

Update @ 2019-02-17

We are not using windows authentication and SSIS Passage is getting failed even after running SSDT as administrator. We are able to preview the Sharepoint list data in ODATA Source, but package is getting failed with the mentioned error message when triggered

推荐答案

我们收到此错误，因为在服务器中启用了代理.启用代理后，SSIS 包在执行期间无法访问 Sharepoint 列表.在 Internet 选项中将连接更改为自动检测设置"后，此功能运行良好.

We got this error since proxy was enabled in the server. SSIS Package is not able to access Sharepoint List during execution when the proxy is enabled. This is working fine after changing the connection to "automatically detect settings" in the internet options.

这篇关于如何修复“[OData Source [56]] 错误:无法从运行时连接管理器获取托管连接."SSIS中的错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！