TimeOut Expired. Using Temporary tables

From: DotNetJunkies User (User_at_-NOSPAM-DotNetJunkies.com)
Date: 07/30/04 

Date: Thu, 29 Jul 2004 22:11:17 -0700

Hi,
I have a temporary table which contains around 2.7 million records. I am iterating through these records in a WHILE Loop and performing certain business rules on these records. Within the loop too i am using a large number of temporary tables.

This entire processing is being done in a stored procedure which is being executed using ADO.NET's ExecuteNonQuery method. The COMMAND object on which this is being executed has its CommandTimeOut property set to 0.

However after around 18 hrs of processing time i get a TimeOut error. This error comes everytime and it takes around 18 hrs each time.

Plz help.

Snapshot of the error log entry is as follows:

*********************************************
Error Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 10
LineNumber: 0
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Number: -2
Procedure: ConnectionRead (WrapperRead()).
Server:
State: 0
Source: .Net SqlClient Data Provider
TargetSite: System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean)
HelpLink: NULL
******************************************* 

---
Posted using Wimdows.net NntpNews Component - 
Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Relevant Pages

  • Re: TimeOut Expired. Using Temporary tables
    ... you might use a sql job object to ... executed using ADO.NET's ExecuteNonQuery method. ... > However after around 18 hrs of processing time i get a TimeOut error. ... engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Threading a server
    ... SMTP. ... needed the watchdog and with a reasonable amount of time. ... I am guessing that to deal with the timeout behaviour, ... The next message you posted commented on the loop. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Form OnKeypress event not firing while test loop running
    ... Paul E. Schoen wrote: ... Once this happens the display shows the running time and current value, and this may be repeated until a certain number of pulses occur, or a preset timeout is reached. ... The data analysis is accomplished in a rather large loop which fires on a 200 mSec timer event, and it processes about 480 integer data values. ... ESC key for example, then while your in that loop, you can test for that value incase the user wants to terminate the current function.. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Need Help in Loop Foreach
    ... I'd like to insert a loop, in such a way that it reads all the "System ID" ... # Query all the systems status by inputting the SystemIDs on Expect Script ... intial expect until a timeout occured. ... # may want to break after sending exit in above section if this does ...
    (comp.lang.tcl)
  • Re: creating a new thread to run while loop
    ... > connection suddenly dropped, so i have to go for an alternative which ... thread) is not able to timeout / return error / etc and is basically being ... The only options seems to be to terminate the ... The example that you supplied w/ the loop in the main thread that causes the ...
    (microsoft.public.windowsce.embedded.vc)