I sometimes get a timeout error when populating my datagrid,
the code is
WizardConnection.Open()
UpdateCommand.CommandText = "EXECUTE sp_assign_user '" &
PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'"
UpdateCommand.ExecuteNonQuery()
WizardConnection.Close()
Any suggestions?
Thanks
Paul
The error is :
Server Error in '/EmpLinkage' Application.
Timeout expired
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.OleDb.OleDbException: Timeout expired
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e31): Timeout expired]
System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr)
System.Data.OleDb.OleDbDataReader.NextResult()
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandB
ehavior behavior)
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
EmpLinkage.WebForm1.datagrid() in
\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:18 3
EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in
\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:26 1
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
System.Web.UI.Page.ProcessRequestMain() 4 3901
Hi Paul:
It doens't look like the problem is DataGrid related, but in the
stored procedure you use to update a record in the database.
I'd review the stored procedure SQL in a query tool and see how long
the query is taking. Perhaps the stored procedure is trying to update
a record in a large table and does not have an index available to find
the record quickly.
HTH,
--
Scott http://www.OdeToCode.com
On Wed, 5 May 2004 11:30:50 -0400, "Paul" <pe@nospam.com> wrote: I sometimes get a timeout error when populating my datagrid,
the code is WizardConnection.Open()
UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'"
UpdateCommand.ExecuteNonQuery()
WizardConnection.Close()
Any suggestions? Thanks Paul
The error is :
Server Error in '/EmpLinkage' Application.
Timeout expired 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.OleDb.OleDbException: Timeout expired
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e31): Timeout expired] System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr) System.Data.OleDb.OleDbDataReader.NextResult() System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbCom mand.ExecuteReader(CommandB ehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) EmpLinkage.WebForm1.datagrid() in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:1 83 EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:2 61 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IP ostBackEventHandler.RaisePo stBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) System.Web.UI.Page.ProcessRequestMain()
The sproc is reading not updating any database, depending upon the selection
criteria the sproc can take upto 30 seconds to complete, but asp.net doesn't
seem to want to wait that long.
Thanks
"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:47********************************@4ax.com... Hi Paul:
It doens't look like the problem is DataGrid related, but in the stored procedure you use to update a record in the database.
I'd review the stored procedure SQL in a query tool and see how long the query is taking. Perhaps the stored procedure is trying to update a record in a large table and does not have an index available to find the record quickly.
HTH,
-- Scott http://www.OdeToCode.com
On Wed, 5 May 2004 11:30:50 -0400, "Paul" <pe@nospam.com> wrote:
I sometimes get a timeout error when populating my datagrid,
the code is WizardConnection.Open()
UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'"
UpdateCommand.ExecuteNonQuery()
WizardConnection.Close()
Any suggestions? Thanks Paul
The error is :
Server Error in '/EmpLinkage' Application.
Timeout expired 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.OleDb.OleDbException: Timeout expired
Source Error:
An unhandled exception was generated during the execution of the current
webrequest. Information regarding the origin and location of the exception
canbe identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e31): Timeout expired] System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr) System.Data.OleDb.OleDbDataReader.NextResult() System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbCom mand.ExecuteReader(Command
B ehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord,Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) EmpLinkage.WebForm1.datagrid() in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:1 83 EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:2 61 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IP ostBackEventHandler.RaiseP
o stBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) System.Web.UI.Page.ProcessRequestMain()
You could set a longer timeout but that's already quite long. I would check
first if it makes sense it take so much time. How many records are returned
?
"Paul" <pe@nospam.com> a écrit dans le message de
news:uI**************@TK2MSFTNGP12.phx.gbl... The sproc is reading not updating any database, depending upon the
selection criteria the sproc can take upto 30 seconds to complete, but asp.net
doesn't seem to want to wait that long.
Thanks
"Scott Allen" <bitmask@[nospam].fred.net> wrote in message news:47********************************@4ax.com... Hi Paul:
It doens't look like the problem is DataGrid related, but in the stored procedure you use to update a record in the database.
I'd review the stored procedure SQL in a query tool and see how long the query is taking. Perhaps the stored procedure is trying to update a record in a large table and does not have an index available to find the record quickly.
HTH,
-- Scott http://www.OdeToCode.com
On Wed, 5 May 2004 11:30:50 -0400, "Paul" <pe@nospam.com> wrote:
I sometimes get a timeout error when populating my datagrid,
the code is WizardConnection.Open()
UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'"
UpdateCommand.ExecuteNonQuery()
WizardConnection.Close()
Any suggestions? Thanks Paul
The error is :
Server Error in '/EmpLinkage' Application.
Timeout expired Description: An unhandled exception occurred during the execution of
thecurrent web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Timeout expired
Source Error:
An unhandled exception was generated during the execution of the
current webrequest. Information regarding the origin and location of the exception canbe identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e31): Timeout expired] System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr) System.Data.OleDb.OleDbDataReader.NextResult() System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior
behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbCom mand.ExecuteReader(Command Behavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) EmpLinkage.WebForm1.datagrid() in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:1 83 EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in \\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:2 61 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IP ostBackEventHandler.RaiseP ostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) System.Web.UI.Page.ProcessRequestMain()
Hi Paul:
Sorry for the confusion, the source code you posted shows
ExecuteNonQuery, but the stack trace shows the exception occurs on a
Fill method.
The CommandTimeout property of an OleDbCommand object defaults to 30
seconds. Seems possible it could occasionally be going over.
One approach would be to look at ways to speed up the query, and
check for locking and blocks in the database. Another approach would
be to bump the CommandTimeout property up to a number where the query
can always safely complete.
--s
On Wed, 5 May 2004 13:30:51 -0400, "Paul" <pe@nospam.com> wrote: The sproc is reading not updating any database, depending upon the selection criteria the sproc can take upto 30 seconds to complete, but asp.net doesn't seem to want to wait that long.
Thanks
"Scott Allen" <bitmask@[nospam].fred.net> wrote in message news:47********************************@4ax.com.. . Hi Paul:
It doens't look like the problem is DataGrid related, but in the stored procedure you use to update a record in the database.
I'd review the stored procedure SQL in a query tool and see how long the query is taking. Perhaps the stored procedure is trying to update a record in a large table and does not have an index available to find the record quickly.
HTH,
-- Scott http://www.OdeToCode.com
On Wed, 5 May 2004 11:30:50 -0400, "Paul" <pe@nospam.com> wrote:
>I sometimes get a timeout error when populating my datagrid, > >the code is >WizardConnection.Open() > >UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & >PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'" > >UpdateCommand.ExecuteNonQuery() > >WizardConnection.Close() > > >Any suggestions? >Thanks >Paul > >The error is : > > >Server Error in '/EmpLinkage' Application. > > >Timeout expired >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.OleDb.OleDbException: Timeout expired > >Source Error: > >An unhandled exception was generated during the execution of the currentweb >request. Information regarding the origin and location of the exceptioncan >be identified using the exception stack trace below. > >Stack Trace: > >[OleDbException (0x80040e31): Timeout expired] > System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr) > System.Data.OleDb.OleDbDataReader.NextResult() > System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior >behavior, String method) > System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) >
System.Data.OleDb.OleDbCommand.System.Data.IDbCo mmand.ExecuteReader(Command B >ehavior behavior) > System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 >startRecord, Int32 maxRecords, String srcTable, IDbCommand command, >CommandBehavior behavior) > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32startRecord, >Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior >behavior) > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) > EmpLinkage.WebForm1.datagrid() in >\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:1 83 > EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in >\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:2 61 > System.Web.UI.WebControls.Button.OnClick(EventArgs e) >
System.Web.UI.WebControls.Button.System.Web.UI.I PostBackEventHandler.RaiseP
o >stBackEvent(String eventArgument) > System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler >sourceControl, String eventArgument) > System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) > System.Web.UI.Page.ProcessRequestMain() >
--
Scott http://www.OdeToCode.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Adel |
last post by:
Hello guys
Does any one know about how to inforce sorting on a
specific coloumn in a datagrid before populating it ?
Thanks in advance
|
by: Robert |
last post by:
I'm sure this is a fairly basic question, but I've been looking all over the
web for days for suggestions on how to do this.
I've got a datagrid that's bound to a dataset on my form. It includes...
|
by: Dan |
last post by:
I've created a web form which fills a DataGrid with a DataSet generated from
the SqlDataAdapter.Fill method. The adapter's query takes about 30 seconds
to complete when I run it in the SQL Server...
|
by: |
last post by:
Trying to learn about manipulating collections of objects, and populating
these objects dynamically from datasources. Could someone post a code sample
that shows the following:
Instantiating a...
|
by: fripper |
last post by:
I want to populate the cells of a DataGrid at run time. I don't want to
bind a database to it I simply want to do some calculations and put results
into the grid programmatically. I did this in...
|
by: Mike P |
last post by:
I am populating a drop down column in a datagrid on page load. Here is
my code :
<asp:TemplateColumn>
<ItemTemplate>
<asp:DropDownList ID="ddlUserName" Font-Name="Verdana"
Font-Size="8pt"...
|
by: Ron |
last post by:
Hi,
I had a stored procedure on SQL 2000 server to run calculation with
large amount of data. When I called this stored procedure via
System.Data.SqlClient.SqlCommand on production, i got error...
|
by: sorcerdon |
last post by:
Hello!
I am looking for someone who has solved this multi-million people's
problem. EVERYONE seems to ahve this problem.
Im a creating a data set and populating it with a call to a store proc.
...
|
by: Brock |
last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The
reason for this is that I want the user to be able to change values
without updating the database, but still have their report...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |