Problem
You might get random timeout error (see below) when you fetch data using SSIS Google Analytics Source
System.Exception: The operation has timed out. This error may occur due to long running operations or slow network speed.
You can increase default timeout setting and try again.
Possible Cause
Google Service is slow to respond your API request and your timeout setting is too low on Google Data Connection so request is timing out.
On December 14 Google experienced massive outage across many services since then we have many users complaining about timeout issue, You can also see from API usage graph (Go to your API console of Google Analytics API). See below after December 14th how API response time increased.
This error may occur due to long running operations, slow network or slow API server. There are mainly two way to fix this error.
[1] You can increase default timeout setting and try again (See Task Advanced Tab / or HTTP Connection UI).
[2] Another setting you can try is enable Retry or Web Errors. See connection UI Error Retry Tab. Usually such timeout error can happens due to parallel API calls (many network activities / threads) or slow response from API server.
In short try 3 things [1] Reduce parallel requests if possible [2] increase timeout setting [3] enable error retry setting if supported by connection UI.
Possible Solutions
To fix this error you can try two different ways see which one helps.
Setting#1 : First try to change error retry settings see it helps. For example Go to Google Data Connection UI and on Error Retry Settings Tab set below way and try to run you SSIS Package see it helps.
Setting#2 : Try to increase default timeout on Google Data Connection. Default is 100000 ms (i.e 100 seconds). Try to change to 2-3 times more see it helps? For example change to 300000 rather than 100000
Contact Us
If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com
Comments
0 comments
Please sign in to leave a comment.