I just started to get the above error all of a sudden during the bulk import. I was importing pictures all day and all of a sudden, I started getting this error message and I cannot import a single picture any more. My web application timeout is set to 3000,
but it times in less than a minute. The culprit seems to be the AddPhoto function. I restarted SQL Server 2000, IIS, and the whole machine, but to no avail. There's no code change since it was working earlier in the day. Any ideas?
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
Source Error:
Line 125: command.Parameters.Add(New SqlParameter("@BytesPoster", ResizeImageFile(BytesOriginal, 198)))
Line 126: command.Parameters.Add(New SqlParameter("@BytesThumb", ResizeImageFile(BytesOriginal, 100)))
Line 127: command.ExecuteNonQuery()
Line 128: End Sub
I am also getting the same error. Time out expired. the timeout period elpased prior to the completion of the operation.....
Actually, I am trying to run a data migration tool to transfer the data from one big table to multiple tables...
there are around 5000-10000 records.... the program starts giving error after some 3000 records... and then it does not migrate even a single record if I start the tool again..
I have tried everything... checkin the locks.... blocking.... connection pooling... etc etc...
I'm back to where I started with this. After implementing the manual closing of the connections, I got a few more uploads in, but now I'm stuck again. There's something fundementally wrong with this...
Well, I had not set it, but now that I have it seems to work. What's taking so long to process these requests? Do you think it's related to database optimization problems?
In any case, thanks a lot for your help. It's a relief to have the Import capability back in action.
I would run your SQL in query analizer and see how many seconds it takes for each set. Then debug your code from there to see if you have any issues elsewhere. For me it was the SP, running 45 seconds....
ersheido
Member
448 Points
117 Posts
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the s...
Jul 20, 2005 01:41 AM|LINK
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
Source Error:
ersheido
Member
448 Points
117 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Jul 28, 2005 07:22 PM|LINK
abhishek_bha...
Member
5 Points
1 Post
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 16, 2005 03:48 PM|LINK
Hi,
I am also getting the same error. Time out expired. the timeout period elpased prior to the completion of the operation.....
Actually, I am trying to run a data migration tool to transfer the data from one big table to multiple tables...
there are around 5000-10000 records.... the program starts giving error after some 3000 records... and then it does not migrate even a single record if I start the tool again..
I have tried everything... checkin the locks.... blocking.... connection pooling... etc etc...
but nothing seems to be working
Please help me in this...
Thanks in advance..
ersheido
Member
448 Points
117 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 16, 2005 09:20 PM|LINK
drock22
Contributor
2131 Points
495 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 04:34 PM|LINK
CommandTimeout = 120 in the connection string and it still gets the error
drock22
Contributor
2131 Points
495 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 06:59 PM|LINK
<
add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>Please reply back if this works....
ersheido
Member
448 Points
117 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 07:19 PM|LINK
drock22
Contributor
2131 Points
495 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 07:32 PM|LINK
ersheido
Member
448 Points
117 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 08:01 PM|LINK
Well, I had not set it, but now that I have it seems to work. What's taking so long to process these requests? Do you think it's related to database optimization problems?
In any case, thanks a lot for your help. It's a relief to have the Import capability back in action.
drock22
Contributor
2131 Points
495 Posts
Re: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or t...
Aug 18, 2005 08:03 PM|LINK