question

HamadaAbdulmonsif-9343 avatar image
0 Votes"
HamadaAbdulmonsif-9343 asked RockellJillM-2429 commented

OData error Cannot acquire a managed connection from the run-time connection manager

I'm suddenly facing the following error since 3 days while extracting SharePoint list by SSIS package, however my jobs were running without any issue since 2 years

Error: Cannot acquire a managed connection from the run-time connection manager.
[SSIS.Pipeline] Error: Contract Management failed validation and returned error code 0xC020801F.
Progress: Validating - 25 percent complete

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered RockellJillM-2429 commented

Hi @HamadaAbdulmonsif-9343,

Someone who had met the same error said that they 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.

You may have a try.

Here are some other detailed resolution in this link, you may carefully refer to see if it will be useful.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

I am also having the same issue. Can you please send instructions on where to change the internet options? Is that inside of SSIS?

Thanks,

Jill

0 Votes 0 ·

Hi @ RockellJillM-2429,

Go to the Control Panel > Internet Options > Connections tab and then click on LAN settings.

98436-screenshot-2021-05-21-142044.jpg
https://docs.microsoft.com/en-us/troubleshoot/browsers/automatically-detect-settings-enabled

0 Votes 0 ·

Unfortunately this did not resolve our issues. We have tried several fixes posted on this forum and none of them have worked. :(

0 Votes 0 ·