https://www.tntware.com/donorhub/faqs/en/how-can-i-get-past-a-quot-timeout-expired-quot-error-when-i-try-to-pump-data.aspxen-USCommunityServer 2008.5 SP2 (Debug Build: 40407.4157)https://www.tntware.com/donorhub/faqs/en/how-can-i-get-past-a-quot-timeout-expired-quot-error-when-i-try-to-pump-data.aspxSat, 01 Jun 2019 19:55:12 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:3Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/how-can-i-get-past-a-quot-timeout-expired-quot-error-when-i-try-to-pump-data/comments.aspxCurrent revision posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 7:55:12 PM<br /> <h2>How can I get past a &quot;Timeout Expired&quot; error when I try to pump data?</h2> <div style="font-size: 90%;">Filed under: Troubleshooting</div> <p><span style="text-decoration: line-through; color: red;">When</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">&quot;Pump</span> <span style="text-decoration: line-through; color: red;">All</span><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">or</span>&nbsp;<span style="text-decoration: line-through; color: red;">&quot;Pump</span> <span style="text-decoration: line-through; color: red;">Selected</span><span style="text-decoration: line-through; color: red;">&quot;,</span> <span style="text-decoration: line-through; color: red;">if</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">taking</span> <span style="text-decoration: line-through; color: red;">too</span> <span style="text-decoration: line-through; color: red;">long</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">get</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">source</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">might</span> <span style="text-decoration: line-through; color: red;">get</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">&quot;Timeout</span> <span style="text-decoration: line-through; color: red;">Expired</span><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">error</span><span style="text-decoration: line-through; color: red;">.</span><p>This <span style="text-decoration: line-through; color: red;">means</span> <span style="text-decoration: line-through; color: red;">that</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">request</span> <span style="text-decoration: line-through; color: red;">for</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">source</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">not</span> <span style="text-decoration: line-through; color: red;">responding</span> <span style="text-decoration: line-through; color: red;">quickly</span> <span style="text-decoration: line-through; color: red;">enough</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">By</span> <span style="text-decoration: line-through; color: red;">default</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">timeout</span> <span style="text-decoration: line-through; color: red;">limit</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">30</span> <span style="text-decoration: line-through; color: red;">seconds</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">There</span> <span style="text-decoration: line-through; color: red;">are</span> <span style="text-decoration: line-through; color: red;">two</span> <span style="text-decoration: line-through; color: red;">solutions</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">this</span> <span style="text-decoration: line-through; color: red;">problem</span><span style="text-decoration: line-through; color: red;">:</span></p> <ol> <li><span style="text-decoration: line-through; color: red;">Resolve</span>&nbsp;<span style="text-decoration: line-through; color: red;">any</span> <span style="text-decoration: line-through; color: red;">performance</span> <span style="text-decoration: line-through; color: red;">issues</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">computer</span> <span style="text-decoration: line-through; color: red;">hosting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">source</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">Make</span> <span style="text-decoration: line-through; color: red;">sure</span> <span style="text-decoration: line-through; color: red;">that</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">computer</span> <span style="text-decoration: line-through; color: red;">hosting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">source</span> <span style="background: SpringGreen;">FAQ</span> <span style="background: SpringGreen;">article</span> has <strong><span style="text-decoration: line-through; color: red;">adequate</span> <span style="text-decoration: line-through; color: red;">RAM</span></strong> <span style="text-decoration: line-through; color: red;">and</span> <strong><span style="text-decoration: line-through; color: red;">hard</span> <span style="text-decoration: line-through; color: red;">drive</span> <span style="text-decoration: line-through; color: red;">space</span></strong><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">Also</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">might</span> <span style="text-decoration: line-through; color: red;">try</span> <strong><span style="text-decoration: line-through; color: red;">restarting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">computer</span></strong> <span style="text-decoration: line-through; color: red;">hosting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">source</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">For</span> <span style="text-decoration: line-through; color: red;">example</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">if</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">re</span> <span style="text-decoration: line-through; color: red;">pulling</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">database</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">try</span> <span style="text-decoration: line-through; color: red;">restarting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">computer</span> <span style="text-decoration: line-through; color: red;">hosting</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">for</span> <span style="text-decoration: line-through; color: red;">that</span> <span style="text-decoration: line-through; color: red;">database</span><span style="text-decoration: line-through; color: red;">.</span></li> <li><strong><span style="text-decoration: line-through; color: red;">Increase</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">timeout</span> <span style="text-decoration: line-through; color: red;">limit</span></strong> <span style="text-decoration: line-through; color: red;">for</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">specific</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">causing</span> <span style="text-decoration: line-through; color: red;">this</span> <span style="text-decoration: line-through; color: red;">problem</span><span style="background: SpringGreen;">become</span> <span style="background: SpringGreen;">obsolete</span>.&nbsp; <span style="text-decoration: line-through; color: red;">If</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">re</span> <span style="text-decoration: line-through; color: red;">not</span> <span style="text-decoration: line-through; color: red;">sure</span> <span style="text-decoration: line-through; color: red;">which</span> <span style="text-decoration: line-through; color: red;">specific</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">causing</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">problem</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">each</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">then</span> <span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">&quot;Pump</span> <span style="text-decoration: line-through; color: red;">Selected</span><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;Manage</span> <span style="text-decoration: line-through; color: red;">Data</span> <span style="text-decoration: line-through; color: red;">Pumps</span><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">screen</span> <span style="text-decoration: line-through; color: red;">until</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">narrow</span> <span style="text-decoration: line-through; color: red;">down</span> <span style="text-decoration: line-through; color: red;">which</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> &nbsp;</p> <p><span style="background: SpringGreen;">DonorHub</span> is <span style="text-decoration: line-through; color: red;">causing</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">problem</span><span style="text-decoration: line-through; color: red;">.</span></li> </ol> <h2><span style="text-decoration: line-through; color: red;">Increasing</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">timeout</span> <span style="text-decoration: line-through; color: red;">limit</span> <span style="text-decoration: line-through; color: red;">for</span> a <span style="text-decoration: line-through; color: red;">specific</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span></h2> <ol> <li> <p><span style="text-decoration: line-through; color: red;">Under</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Tools</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">menu</span><span style="background: SpringGreen;">fully</span> <span style="background: SpringGreen;">managed</span> <span style="background: SpringGreen;">cloud</span> <span style="background: SpringGreen;">service</span>, <span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">System</span> <span style="text-decoration: line-through; color: red;">Setup</span></strong><span style="text-decoration: line-through; color: red;">&quot;.</span></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Data</span> <span style="text-decoration: line-through; color: red;">Pumps</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">tab</span><span style="background: SpringGreen;">hosted</span> <span style="background: SpringGreen;">by</span> <span style="background: SpringGreen;">TntWare</span>.</p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">data</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">row</span> <span style="text-decoration: line-through; color: red;">that</span> </p> <p><span style="background: SpringGreen;">Let</span> <span style="background: SpringGreen;">us</span> <span style="background: SpringGreen;">know</span>&nbsp;<span style="background: SpringGreen;">if</span>&nbsp;you<span style="text-decoration: line-through; color: red;">want</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">change</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">then</span> <span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Edit..</span><span style="text-decoration: line-through; color: red;">.</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">button</span><span style="text-decoration: line-through; color: red;">.</span></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Under</span> <span style="text-decoration: line-through; color: red;">where</span> <span style="text-decoration: line-through; color: red;">it</span> <span style="text-decoration: line-through; color: red;">says</span> <span style="text-decoration: line-through; color: red;">&#39;</span><strong><span style="text-decoration: line-through; color: red;">&quot;Source&quot;</span> <span style="text-decoration: line-through; color: red;">Query</span>&#39;</strong><span style="text-decoration: line-through; color: red;">,</span>&nbsp;<span style="text-decoration: line-through; color: red;">remove</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">check</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Use</span> <span style="text-decoration: line-through; color: red;">Template</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">box</span><span style="text-decoration: line-through; color: red;">.</span></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Edit..</span><span style="text-decoration: line-through; color: red;">.</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">button</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">right</span><span style="text-decoration: line-through; color: red;">.</span></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Change</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">seconds</span> <span style="text-decoration: line-through; color: red;">until</span> <span style="text-decoration: line-through; color: red;">timeout</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">&quot;30&quot;</span> <span style="background: SpringGreen;">d</span> <span style="background: SpringGreen;">like</span> to <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">bigger</span> <span style="text-decoration: line-through; color: red;">number</span><span style="text-decoration: line-through; color: red;">.</span><br /><br /><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/8424.ChangeTimeOut.gif"><span style="text-decoration: line-through; color: red;"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/8424.ChangeTimeOut.gif" alt="" /></span></a></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Click</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Save</span> <span style="text-decoration: line-through; color: red;">Changes</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">then</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">Exit</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span></p> </li> <li> <p><span style="text-decoration: line-through; color: red;">Finally</span><span style="text-decoration: line-through; color: red;">,</span>&nbsp;<span style="text-decoration: line-through; color: red;">click</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">OK</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">&quot;</span><strong><span style="text-decoration: line-through; color: red;">OK</span></strong><span style="text-decoration: line-through; color: red;">&quot;</span> <span style="text-decoration: line-through; color: red;">one</span> <span style="background: SpringGreen;">learn</span> more<span style="text-decoration: line-through; color: red;">time</span><span style="text-decoration: line-through; color: red;">.</span><span style="background: SpringGreen;">:</span>&nbsp; <a href="mailto:info@tntware.com"><span style="background: SpringGreen;">info@tntware.com</span></a></p>https://www.tntware.com/donorhub/faqs/en/how-can-i-get-past-a-quot-timeout-expired-quot-error-when-i-try-to-pump-data/revision/1.aspxThu, 12 Mar 2009 15:00:08 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:183Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/how-can-i-get-past-a-quot-timeout-expired-quot-error-when-i-try-to-pump-data/comments.aspxRevision 1 posted to Frequently Asked Questions by Troy Wolbrink on 3/12/2009 3:00:08 PM<br /> <p>When you click on &quot;Pump All&quot; or&nbsp;&quot;Pump Selected&quot;, if a data pump is taking too long to get data from the data source, you might get a &quot;Timeout Expired&quot; error.&nbsp; This means that a request for data from the data source is not responding quickly enough.&nbsp; By default, the timeout limit is 30 seconds.&nbsp; There are two solutions to this problem:</p> <ol> <li>Resolve&nbsp;any performance issues on the computer hosting the data source.&nbsp; Make sure that the computer hosting the data source has <strong>adequate RAM</strong> and <strong>hard drive space</strong>.&nbsp; Also, you might try <strong>restarting the computer</strong> hosting the data source.&nbsp; For example, if you&#39;re pulling in data from a SQL Server database, try restarting the computer hosting SQL Server for that database.</li> <li><strong>Increase the timeout limit</strong> for the specific data pump causing this problem.&nbsp; If you&#39;re not sure which specific data pump is causing the problem, click on each data pump and then click on &quot;Pump Selected&quot; on the &quot;Manage Data Pumps&quot; screen until you narrow down which data pump is causing the problem.</li> </ol> <h2>Increasing the timeout limit for a specific data pump</h2> <ol> <li> <p>Under the &quot;<strong>Tools</strong>&quot; menu, click on &quot;<strong>System Setup</strong>&quot;.</p> </li> <li> <p>Click on the &quot;<strong>Data Pumps</strong>&quot; tab.</p> </li> <li> <p>Click on the data pump row that you want to change and then click the &quot;<strong>Edit...</strong>&quot; button.</p> </li> <li> <p>Under where it says &#39;<strong>&quot;Source&quot; Query&#39;</strong>,&nbsp;remove the check from the &quot;<strong>Use Template</strong>&quot; box.</p> </li> <li> <p>Click on the &quot;<strong>Edit...</strong>&quot; button to the right.</p> </li> <li> <p>Change the &quot;<strong>seconds until timeout</strong>&quot; from &quot;30&quot; to a bigger number.<br /><br /><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/8424.ChangeTimeOut.gif"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/8424.ChangeTimeOut.gif" alt="" /></a></p> </li> <li> <p>Click &quot;<strong>Save Changes</strong>&quot; then &quot;<strong>Exit</strong>&quot;</p> </li> <li> <p>Finally,&nbsp;click &quot;<strong>OK</strong>&quot; and &quot;<strong>OK</strong>&quot; one more time.</p> </li> </ol>