如何解决"[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源[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://

1. Changing 64bit debug option in package properties to false
2. http:// instead of 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 Framework-4.5

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

---

更新@ 2019-02-17

我们没有使用Windows身份验证，即使以管理员身份运行SSDT之后，SSIS Passage也会失败.我们可以在ODATA Source中预览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包将无法在执行过程中访问共享点列表.将连接更改为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屋！