Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Sharepoint List Source Timeout Exception Expand / Collapse
Author
Message
Posted Friday, June 8, 2012 1:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 1, 2014 10:53 PM
Points: 48, Visits: 245
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
Post #1312918
Posted Friday, June 8, 2012 1:45 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:09 PM
Points: 971, Visits: 979
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
Post #1313370
Posted Monday, June 11, 2012 12:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 1, 2014 10:53 PM
Points: 48, Visits: 245
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
Post #1313681
Posted Thursday, June 14, 2012 12:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 1, 2014 10:53 PM
Points: 48, Visits: 245
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
Post #1315629
Posted Monday, August 6, 2012 8:07 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:09 PM
Points: 971, Visits: 979
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
Post #1340971
Posted Wednesday, December 12, 2012 6:02 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:41 PM
Points: 224, Visits: 192
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
Post #1395951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse