Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Sharepoint List Source Timeout Exception


SSIS Sharepoint List Source Timeout Exception

Author
Message
Amith Vemuganti
Amith Vemuganti
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 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
S. Kusen
S. Kusen
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1198 Visits: 1111
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
Amith Vemuganti
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 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
Amith Vemuganti
Amith Vemuganti
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 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
S. Kusen
S. Kusen
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1198 Visits: 1111
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
MattF
Old Hand
Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)

Group: General Forum Members
Points: 334 Visits: 395
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search