DataSource Controls :: Timeout On Simple Calls?
Feb 8, 2010
I am creating a simple function that loops through a database, grabs all the tables and (for now) just spits out the first column name. The query I am using is very quick and simple and takes about 1 second to excecute in SQL, I have double and tripple checked this time. However, when my app makes the call, I keep getting a timeout error on about 25% of my calls, none of them should take over 2 seconds...let alone the entire timeout period, and I have no idea why.The section of code that errors out is inside the loop through all the table names (sqldr is the datareader and "name" will get me the name of the table)
[code]...
View 1 Replies
Similar Messages:
Jan 20, 2010
Hopefully I am posting this in the correct forum.
I am having a problem with my ASP.Net Web application. The application is developed using vb.net and is linked to a SQL Server database. Let me explain how the application works and the problem I am experiencing. The system is an online web app which allows registered users to create a CV online. One of the pages within the app gives users the chance to add a cover note to their CV. The page that allows them to do this consists of only a textarea control and a button control. The textarea allows users to input up to 4,000 characters.
Once the user clicks the 'Save' button to save their cover note info, the following code then executes.This code checks to see if the CV already has cover note info, if it does, then the application runs an update statement, otherwise, it runs an insert statement.The table within the database which records the cover note information is called tbl_covernote and has three columns, covernote_id (int and autoincrement), cv_id(int), covernote_text (nvarchar(max)).
The error which occurs sometimes is as follows:
Dim dr As SqlDataReader
Dim param(0) As SqlParameter
Finally [code]...
View 11 Replies
Feb 17, 2010
I have the following Page_Load function...
protected void Page_Load(object sender, EventArgs e)
{
XmlDataSource1.Data = GetXmlFromFile(Request.QueryString["file"]);
XmlDataSource1.DataBind();
Repeater1.DataBind();
}
The page in which this Page_Load resides is called by a parent page. Each time this Page_Load gets called the value of "file" in the query string will be different. So each time I will be receiving the XML contents from a different file which are inserted into the XmlDataSource and then bound against by the Repeater. Getting the XML data from the file works great but when I bind against the repeater that only works the first time through Page_Load. Each time after that when this code is executed the same results from the first XML file are displayed in the repeater.
What am I missing here. How can I get the XML data to be bound against the repeater on each page load instead of just the first one?
View 3 Replies
Mar 8, 2011
I'm making an ajax call using jquery to an asp.net mvc controller action:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult GetWeek(string startDay) {
var daysOfWeek = CompanyUtility.GetWeek(User.Company.Id, startDay);
return Json(daysOfWeek);
}
When session times out, this call will fail, as the User object is stored in session. I created a custom authorize attribute in order to check if session was lost and redirect to the login page.
View 2 Replies
Jun 28, 2010
I have searched the vast information highway and found nothing but road blocks!I have created a simple web application that calls a COM object like we've all done before. Well this time, the COM interop don't want to work due to DCOM Identity CRISIS. The only way I can get it to work is to physically log in to the web server and thenrun my web application.
View 1 Replies
Oct 25, 2010
If a normal session timeout occurs we could handle the session timeout.
But say we are using a lot of ajax calls, webhandlers etc. How would we catch session timeout here and redirect to error/login page.
View 5 Replies
Jul 6, 2010
In my application at some places we have used ObjectDataSource and at other normal method calls to retrieve data.My question is then what exactly are the benefits of using ObjectDataSource ?In the example below "CODE ONE" makes a call to the Business Layer and then Binds the results to the Grid abd "CODE TWO" is using ObjectDataSource to do the same.Then how is ObjectDataSource better?
SuitableApplicant sa = new SuitableApplicant();
IList<HD.Recruitment.SuitableApplicant> list = new List<HD.Recruitment.SuitableApplicant>();
list = HS.Recruitment.RecruitmentService.GetSuitableAppls();
GridView1.DataSource = list;
[code]....
View 5 Replies
Jun 9, 2010
We are seeing the following timeout error being logged into our Event Viewer every now and then. We are using LINQ to connect to the SQL Server 2008 and the connection string is defined in the web.config file.One wierd thing I noticed is that the .NET framework is timing out trying to detect if this is SqlCe connection string. Why is it trying to waste time and then timing out when we have a SQL Server 2008 as the database?
What can I do to fix this problem?
Server: Windows 2008 R2 64-Bit
\IIS 7.5.7600.16385 Application Pool: Integrated Mode with 32-Bit Applications Enabled. Queue Length = 5000, Indentity = Network Service.Database Server: SQL Server 2008
[code]...
View 2 Replies
Feb 22, 2010
On one of our applications we are getting a timeout error on an 'additional details' field in our database, the field type is nVarChar(MAX).
The error seems to be happening when a user enters more than 4000 characters into the additional details field. It is my understanding that this fieldtype can store up to 8gb of data and should be used in stead of the "Text" field type?
We have since limited the user from entering more than 4000 characters via the application, however the DB still contains legacy data - when the 'additional details' with more than 4000 characters is pulled out - "Timeout Error".
View 4 Replies
Jan 1, 2010
I am working with the web application for a Money Chain business group. I have to calculate the full payout for the associate members of the website twice in a month. The problem is, when i am executing a stored procedure which obviously take a long time to process all the associate details and calculate the payout, before i get the result the timeout happens in the server. What can i do to correct this problem?
View 4 Replies
Feb 26, 2010
I have records with and without a email entered in the field called 'email'.
This one works:
Return From p In db.myTable _
Where p.Email.Length > 0 _
Select New With {.p.Name, p.Email}
but this doesn't
Return From p In db.myTable _
Where p.Email.Length = 0 _ ( nor does Where NOT p.Email.Length > 0 )
Select New With {.p.Name, p.Email}
Am I missing something?
View 2 Replies
Jun 21, 2010
VS2010/C#. I have a gridview bound to a SQL Server table with the default SELECT statement returning only a few rows. This is straight out of the box, so no need to show markup.
Upon a button click event I update the datasource: SqlDataSource1.SelectCommand = hdnSQL.Value; Then bind: qlDataSource1.DataBind();
But when I run this, I get this error:
System.Data.SqlClient.SqlException was unhandled by user code. Message=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I am clueless. I have done this many times in the past and NEVER encountered a timeout.
View 4 Replies
Jan 27, 2011
We have the timeout value set to 120 in our <form> tag within the web.config. We do not have a session timeout set.. and we have various connection strings.
We are having a problem where a session variable will disappear (become NULL) .. but, the form evidently remains 'open'.. or no re-login is required..... so, my question(s):
1. what is the relationship between form timeout and session timeout
2. how do I set session timeout
View 1 Replies
May 19, 2010
I'm getting the following error after uploading my site on live server:Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.i'm using the following code:
public static IQueryable<Property> Properties(string name, string city, string state, int pageIndex, int pageSize, ref int total)
{
ServerDataContext server = new ServerDataContext();
total = server.Properties.Count(x => x.Name.StartsWith(name) && x.City.StartsWith(city) && x.State.Contains(state));
return server.Properties.Where(x => x.Name.StartsWith(name) && x.City.StartsWith(city) && x.State.Contains(state)).Skip(pageIndex * pageSize - pageSize).Take(pageSize);
}
View 1 Replies
Jan 2, 2010
I have to Encrypt and Decrypt Back the Password field in sql server i have used the pwdencrypt and pwdCompare() but i dont have to compare but i have to display the password back using the Decrypt technique Is there any algorithm which i can use only for encryption and decryption of password field?
View 4 Replies
Mar 24, 2010
i want to insert regular, strings in sqldatasource.
in the "sss" i put joe and in the saw i put 'no' and it doesnt work!
<asp:SqlDataSource
ID="sql3"
runat="server"
InsertCommand="insert
into inbox(message,title,sss,to,saw) values(@message,@title,'joe',@to,'no')"
SelectCommand="select
* from inbox"
ProviderName="System.Data.OleDb"
ConnectionString='<%$connectionstrings:
sql %>'>
<InsertParameters>
<asp:Parameter
Type="String"
Name="message"
/>
<asp:Parameter
Type="String"
Name="title"
/>
<asp:Parameter
Type="String"
Name="sss"
/>
<asp:Parameter
Type="String"
name="to"
/>
<asp:Parameter
Type="String"
Name="saw"
/>
View 6 Replies
May 10, 2010
I have a webservice (ASP.NET) deployed on a webfarm. A client application consumes it on daily basis. The problem is that some of its calls are duplicated (with difference of milliseconds). For example I have a function Foo(string a,string b). The client app calls this webmethod as Foo('test1','test2') once but my log shows that it is being called twice or sometimes 3 or 4 times randomly. Is this anything wrong with the webfarm or the code? Note that the webmethod has simple straighfarward insert and update statements.
View 1 Replies
Apr 20, 2010
im tryin to create a login form.
and am receiving the following error:
Object reference not set to an instance of an object
[Code]....
and heres my aspx page:
[Code]....
Stored procedure:
[Code]....
View 2 Replies
Jun 21, 2010
I want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.
Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?
I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.
View 4 Replies
Feb 15, 2010
I have an ASP.Net application that makes an AJAX request to retrieve at report. The report can run for a long time so I set the asyncpostbacktimeout in <asp:ScriptManager /> to 600. However, when I try to run the report, if it runs for longer than 90 seconds it fails to come back. I can see in the IIS logs that the POST request succeeded with a 200 status and I can see the time taken is much less than 600.
The web page dutifully waits for the entire 600 seconds before returning with a timeout error:
Error:
Sys.WebForms.PageRequestManagerTimeoutException:
The server request timed out.
Is there any setting I should be checking in IIS? Connection timeout is 900 seconds.
View 1 Replies
Sep 1, 2010
a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2 Thus representing a simple "1 to many" or "parent/child" relationship in the database!
SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there).
SqlDataSource2 has parameters that filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.
HOWEVER - THE PROBLEM ARISES...
The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.
I've tried setting the SqlDataSource2 parameters to:
<SelectParameters>
<asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataKey(2)" />
</SelectParameters>
but it doesn't seem to like that approach. I'm expecting the answer is something similar .
View 1 Replies
Feb 1, 2010
The session state timeout is set using this web.config element
<sessionState mode="InProc" cookieless="false" timeout="120" />
The forms auth is configured using this web.config element
<system.web>
<authentication mode="Forms">
<forms loginUrl="Login.aspx"
protection="All"
timeout="30"
name=".ASPXAUTH"
path="/"
requireSSL="false"
slidingExpiration="true"
defaultUrl="default.aspx"
cookieless="UseDeviceProfile"
enableCrossAppRedirects="false" />
</authentication>
</system.web>
What is the difference between the timeouts specified in each of these elements? If both are different, how would it work?
View 2 Replies
Jul 29, 2010
I have a page of each every click has ajax call to my server (hence, the ASP extends the session)
I have ASP.NET session set to Xmin. I want when X+1 min expires, I have expiration page. what I did was to set the JS timer to validate every x+1min to see if the session expired (the problem is that the JS and the ASP session timeouts are not synced)
View 2 Replies
Mar 10, 2011
[Code]....
I have an issue to where my users are logged into my system but thier session is null so when they try to do something in the system after 20 minutes, i get null reference expceptions because my session is gon
What is the best practice for handleing the session, should i kick the users out before thier session ends and when they log back in thier session will return or atleast a new one will be created right? How should I handle this?
View 2 Replies
Jul 1, 2010
I have 2 drop downs that control the generation of dynamic controls.
Problem is that when the async post back happens the results are giving the previous values selected in the drop downs and not the new selected value in the drop down as would be expected from a traditional postback event.
So the calls to generate the dynamic controls are always 1 step behind.
View 2 Replies
