SSIS Sharepoint List Source Timeout Exception

Question

SSIS Sharepoint List Source Timeout Exception

Amith Vemuganti

Ten Centuries

Points: 1350
More actions
June 8, 2012 at 1:39 am

#275641

Hello All:
I have an SSIS package with SharePoint List adapter as data source connection. I'm experiencing the timeout issue very often. Can anyone please advise what is the solution to fix this issue. Can I increase the allotted time or Paging Size on the SharePoint List Source OR add some kind of logic to SSIS package to read the large data. Please find the exception details below.
Description: System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:59.9843999. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.TimeoutException: The HTTP request to 'http://SiteURL/_vti_bin/lists.asmx' has exceeded the allotted timeout of 00:01:00.
Appreciate your help!
Thanks,
Amith Vemuganti

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

S. Kusen SSChampion Points: 10936 More actions · Answer 1

Does it work sometimes just not all of the time? Have you check response time between source and destination to see if there are any network connectivity issues?

It's not the right solution, but have you tried increasing the timeout setting with any success?

Steve

Amith Vemuganti Ten Centuries Points: 1350 More actions · Answer 2

Thanks for the response Steve!

It happens only sometimes and I think only when trying to pull large data sets. Could you please tell how can I change the timeout settings for SharePoint List Source adapter in SSIS?

Thanks again,

Amith Vemuganti

Amith Vemuganti Ten Centuries Points: 1350 More actions · Answer 3

I think I'm not experiencing the issue because of the large data sets as I initially thought but because of the larger list size. I'm wondering if changing the Daily Time window or any other setting in SharePoint would fix the issue? I would really appreciate any help in this regard.

Thanks,

Amith Vemuganti

S. Kusen SSChampion Points: 10936 More actions · Answer 4

Sorry for leaving you hanging. I haven't had a chance to get back on to SSC in quite a while. Did you ever get a resolution to this? I'm not very familiar with the SharePoint lists or administering SharePoint, so I apologize for not being super helpful.

Did you have anyone check the network between where the package is running compared to where the SP list is hosted?

Try changing the batch file size to 1 so you can eliminate the batch size from timing out.

This link here may get you in the right direction:

http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/

If not, you might be able to reach out to the author of that article to get some assistance.

Cheers,

Steve

MattF SSCrazy Points: 2285 More actions · Answer 5

We were getting the same issue loading a sharepoint list which had been running without problems "Error: System.TimeoutException: The request channel timed out while waiting for a reply". Changing the batch size from default 200 to 20 fixed it.

Thanks

MattF