Odata: Cannot acquire a managed connection from the run-time connection manager

2
votes

Problem

Get the error (see below) when executing an SSIS Odata connection to the Medicare Data site despite successfully previewing data.

Tried

  • Running as 32-bit

enter image description here

SSIS Error in Debug

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

2
sql-serverssisodataetl
Have you tried to increase the Timeout value from the ODATA connection manager? - Hadi
social.msdn.microsoft.com/Forums/en-US/… - Hadi
@Hadi Just did and unfortunately, still get the same issue. I even tried increasing the max connections to 60. I noticed it fails right away like it didn't even try if that is relevant. - Vinh Ton

2 Answers

0
votes

Can you open the SSIS package from within Visual Studio shell, and then look at the oData connection and test it? I'm having a similar problem, and when I test my connection, I'm getting an Internal Server Error (500) returned from the SharePoint server where I'm trying to connect.