Timeout expired error when i run an aspx page

Question

0.00/5 (No votes)

See more:

I have a Score.aspx page.When it is opened i am getting the follwing error.This page is working in my system.When i put the precompiled copy in clients machine the following error occurs.So plz help me

MSIL

System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Error in Scoring_Definition:Delete()-> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at CreditInvest.ReportScore.Delete() in C:\Users\abhilash\Desktop\24 Sep 2010 second edition\CreditInvestV3\CreditInvest.Class\Reports\Scoring\ReportScore.cs:line 253 at CreditInvest.ReportScore.Delete() in C:\Users\abhilash\Desktop\24 Sep 2010 second edition\CreditInvestV3\CreditInvest.Class\Reports\Scoring\ReportScore.cs:line 257 at CreditInvest.score.Page_Load(Object src, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at CreditInvest.Page.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.ciadmin_score_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
home

Posted 29-Sep-10 23:26pm

deepak thomas

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Xmen Real** · Answer 1 · 2010-09-30T00:12:00

Put a breakpoint on this

CreditInvest.ReportScore.Delete() in C:\Users\abhilash\Desktop\24 Sep 2010 second edition\CreditInvestV3\CreditInvest.Class\Reports\Scoring\ReportScore.cs:line 253

and check the command that method is executing, you may want to use System.Diagnostics.Debug.WriteLine()

Hiren solanki · Answer 2 · 2010-09-29T23:47:00

Solution 1

Please include your code in Try. Catch.
And Let us know the specified Error.

I think this Error mostly occurs while connecting to Database,

Check whether you can connect to DB.

-Update.

You could use Connection Timeout=30 inside your sql connection string in web.Config

or see the article for further understanding.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(VS.71).aspx[^]

Please vote and Accept Answer if it Helped.

Posted 29-Sep-10 23:47pm

Hiren solanki

Updated 30-Sep-10 0:26am

v3

Comments

deepak thomas 30-Sep-10 5:54am

yes i am able to connect to DB using windows authentication.

Hiren solanki 30-Sep-10 5:56am

are you getting this problem everytime you run ?

deepak thomas 30-Sep-10 5:58am

i am getting all the other pages before this one

Hiren solanki 30-Sep-10 6:01am

I think you are firing such a query which creates load on db and lead it to timeout expiration.

deepak thomas 30-Sep-10 6:02am

so what should i do?is it possible increase the timeout?

Hiren solanki 30-Sep-10 6:06am

see my updated answer above.

deepak thomas 30-Sep-10 6:23am

i have added Connect Timeout as you said.But the same error is occuring.

Hiren solanki 30-Sep-10 6:26am

also specify timeout to your command object,
using cmd.commandTimeout = 30, or increase the timeout.

Suthish Nair · Answer 3 · 2010-09-30T00:11:00

Try these things..

1.
The solution is simple, change the CommandTimeout
(objCmd.CommandTimeout = 0) property of your SqlCommand object. The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server.

2.
Or, do you have Connection Lifetime=60 or connection timeout=60 property for connection string.

3.

XML

<system.web>
   <customErrors mode="Off"/>
   <httpRuntime appRequestQueueLimit="100" executionTimeout="60000" />
</system.web>

thatraja · Answer 4 · 2010-09-30T00:11:00

Increase value for Timeout of your SQL Connection & SQL Command

For Connection in Web.Config,

<add key="ConnectionString" value="server=(local); uid=sa; password=sa; database=master;Connection Timeout=30"/>

For Command,

C#

public void CreateSqlCommand()
{
   SqlCommand cmd = new SqlCommand();
   cmd.CommandTimeout = 15;
   cmd.CommandType = CommandType.Text;
}

Timeout expired error when i run an aspx page

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0