SQL Server :: Command Timeout In QA Environment?
Aug 5, 2010
My stored proc execution runs perfectly on local developement environment, but in QA environment it just returns an error after 5 min.s(My stored proc. takes arround 15 min.s to complete), when i run my Stored proc from query analyzer it runs perfectly in 15 min.s.
I tried to debug the code by pointing my local code to QA database, but that didn't give any error and ran perfectly. So i suspect there is something like commandtimeout happening in QA environment. Then i went on to check code at QA environment, it passes commandtimeout = 0 to the command object which means infinite.
View 3 Replies
Similar Messages:
Jun 3, 2013
I am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj;
OdbcCommand cmdObj;
OdbcDataAdapter daObj = new OdbcDataAdapter();
public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) {
conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
[code]....
View 1 Replies
Jun 23, 2010
Is there a way to set the command timeout for everything generated by subsonic?
View 1 Replies
Mar 7, 2011
What is the difference between connection timeout and command timeout?
In our application sometimes it is showing a timeout error. When we increased the command timeout value to 100(from default 30), its working. Is there any issue in increasing the command timeout value.
View 2 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
Oct 15, 2010
I'm working with ASP.Net web services and am having a problem with a long-running process that takes about 5 minutes to complete, and it's timing out. To fix this, I was able to set the executionTimeout on the server's web.config to 10 minutes, and then set the .Timeout property on the Web Service object to approximately 9 minutes. Now, I'm worried that this may possibly cause some other web service calls to sit there for 10 minutes before they time out rather than the previous 90-100 seconds. I know the default on the client side is 100 seconds, but wasn't sure if updating the server's timeout setting would affect this.
Bottom line is - Is it safe to update the server's timeout setting to a long amount like 10 minutes, and rely on the default timeout on the client, or could this end up causing some problems?
View 1 Replies
Aug 4, 2010
I have an aspx page that references a server control from an assembly and lives in Sharepoint (knowledge/experience in Sharepoint is not required to answer this question, i'm simply giving you context). The implementation looks something like this:
<%@ Register TagPrefix="wc" Assembly="Test.Controls" Namespace="Test.Controls" %>
<wc:WYSIWYG runat="server"></wc:WYSIWYG>
I can NOT change the .aspx page's content which currently lives in Sharepoint and I have to to take the same code and run it outside of Sharepoint but still on an ASP.NET environment. It's cool and crazy at the sametime, I know.
When this aspx page is running in Sharepoint, I have to get the WYSIWYG editor control to use Sharepoint's WYSIWYG control. When the same aspx page is running outside of Sharepoint but still in an ASP.NET environment, I need it to use a different server control that's not dependent/from Sharepoint. How could I modify the code-behind to perform this toggling? Is this even possible?
View 1 Replies
Sep 17, 2010
have added an asp menu to my site which i populate depending on the user/group from an entity framework object using a re-entrant function. This successfully adds menu items with associated child menu's to level n in the development environment.The problem comes when i publish to the server. when i view the published site the menu view changes and instead of a nice neat menu bar it shows a big list of the correct menuitems in a flat structure blanking out the rest of the page(asp menu is set to horizontal normally)server - windows server 2003 x64 - iis6 - asp 4.0.30319 + net4 framework packsdev - windows 7 - Visual studio 2010i am checking both sites with the same browsers so its not a browser issue.
View 6 Replies
Sep 17, 2010
I am sorry to be asking what is probably a really stupid question, but i have a problem with my asp menu, when i run it on my dev machine(thru vs2010) it works perfectly, all the menu's are displayed correctly with the correct child items in the correct order but when i publish it to the server all the menu items become flat and take up the whole page. I am populating the menu using a reentrant function as follows to call the function and add the menus i am using
Dim childMenuItems As List(Of MenuItem) = CreateMenuLevel(0, uniquemenulist)
childMenuItems.ForEach(Sub(n) NavigationMenu.Items.Add(n))
Public Function CreateMenuLevel(ByVal parentId As Integer, ByVal menulist As List(Of MenuList)) As List(Of MenuItem)
Dim menuItems As New List(Of MenuItem)
For Each menuListItem As MenuList In menulist.Where(Function(n) n.ParentId = parentId)
Dim MenuItem As New MenuItem
If (Not String.IsNullOrEmpty(menuListItem.PagePath)) Then
MenuItem.NavigateUrl = menuListItem.PagePath
End If
MenuItem.Text = menuListItem.MenuName
MenuItem.Selectable = True
MenuItem.Enabled = True
menuItems.Add(MenuItem)
Dim childMenuItems As List(Of MenuItem) = createMenuLevel(menuListItem.MenuId, menulist)
childMenuItems.ForEach(Sub(n) MenuItem.ChildItems.Add(n))
Next
Return menuItems
End Function
now as i say this all works fine in the dev environment so i dont think its a coding issue unless i am missing something mad.
server 2003 x64
iis 6.0
asp 4.0.303.19
relevant .net 4 framework packs installed
dev environment
visual studio 2010
am using the same browser for to check both dev and server
View 2 Replies
Feb 24, 2010
We are looking to integrate Memcached into our infrastructure, but have a security concern before we do. We run several platforms including ASP.NET and ColdFusion and have many app developers working many little applications across the different platforms. The concern is this: App A places item "dog" into cache.
App B reads item "dog" (or worse: App B updates item "dog")
After this happens, App A either retrieves bad information, or has already had its information viewed, aka "stolen". What we would like to do is make it so that each app can only interact with its own sandbox, and may not interfere with or read other application's data.
View 3 Replies
Nov 22, 2010
We have an UpdatePanel that is showing a gridview with loads of data in it. We have loads of well written sprocs that don't take very long, BUT we have a few horrible ones that take ages.
We do intend to rewrite them but in the interim we have put the ADO.NET commandtimeout up to 180s. The scriptManager.AsyncPostBackTimeout is set to 240s. We want to handle this on the serverside. One of the reports still fails (it's got a couple of nested cursors in it - someone who hasn't had SQL lesson 101 from me!).
Half the time, the nice error timeout message is shown using server side handling of the command timeout. The problem is that the other half of the time the commandtimeout doesn't seem to fire.
View 1 Replies
Feb 9, 2011
I have an intranet ASP.NET web application in which I need to get the IP of the client's machine. I do this vis the following code:
HttpContext.Current.Request.ServerVariables.Item("REMOTE_HOST")
It used to work when my ASP.NET site was only hosted on a single server. However once we got the load balancer installed and migrated our apps to a web farm, the code above returns the IP of the Load Balancer device and not of the client anymore.
I am working with the networking folks to determine what can be configured differently with the load balancer, but in the meantime I was wondering if there was another way I could get the client's IP other than using that IIS Server Variable?
View 1 Replies
Jan 18, 2011
I've read up on SQL Server 2008's encryption function, but I'm not convinced that's the route I want to go. My problem ultimately boils down to the fact that we're either using symmetric keys or assymetric keys encrypted by a symmetric key. Thus it seems like a SQL injection attack could lead to a data leak. I realize permissions should prevent that, permissions should also prevent the leaking in the first place.
It seems to me the better method would be to asymmetrically encrypt the data in the web application. Then store the private key offline and have a fat client that they can run the few times a year they need to access the restricted data so the data could be decrypted on the client. This way, if the server get compromised, we don't leak old data although depending on what they do we may leak future data. I think the big disadvantage is this would require re-writing the web application and creating a new fat application (to pull the restricted data). Due to the recent problem, I can probably get the time allocated, so now would be the proper time to make the recommendation.
View 3 Replies
Feb 5, 2010
I have a form where a user asks for a quote and we need to send an attached application form. all this worked in the dev environment but when I post the changes onto our hosted server (third party ISP) I get an error when the attachment is added. I have tired to use URL's but that does not work, at the moment I am using a relative path, but have also tried to place the file in the forms page folder.
Here is my attachment code:
string strFullPath = System.Web.HttpContext.Current.Server.MapPath(pRelativePath);
Attachment myAttachment = new Attachment(strFullPath, System.Net.Mime.MediaTypeNames.Application.Pdf);
myMsg.Attachments.Add(myAttachment);
this is in a try - catch block and I get the error "Could not find file".
View 2 Replies
Jul 16, 2010
Created a new virtual directory on my web sit in IIS 6.. set proper settings and wild card extensions... published via file system from dev environment to the server but i get a page cannot be found 404 error when browsing the site...
View 4 Replies
Jan 28, 2011
I have a .net web application in a load balanced environment over 3 servers. The load balancing is done with a load balancer. My site is [URL]with serveral javascript files such as [URL]
Is it possible to set it up that when request goes to server1 for [URL] then all javascript, css requests also go to server1, server2 or server3? Is there any web.config configuration that can be put in place to handle this?
View 1 Replies
Jul 4, 2010
some differences hosting a website on some remote server VS running it locally on dev environment.The reason why i am asking is, If I run my website locally it works fine no exceptions, runs smooth. But when deployed on a remote hosting server. Its like a nightmare to me :(very often i get object Instance not set to instance of object..... I am ok with the error message, But the same situation should happen locally,
View 6 Replies
Jan 27, 2011
I have to choose between Server.transfer and Response.redirect for an Intranet application for navigation. I have chosen Server.Transfer as of now because it avoid extra round trip to server and which will help when so many users will be accessing the application. (I believe this is the main difference between reponse.redirect and server.transfer). But the problem is now that URL won't change on Server.Transfer(I don't want to implement Http headerS, as I am afraid it will take time to implement that).on redirection, I want to do something like taking benefit of server.redirect(in avoiding server processing, which happens in response.redirect) and changing the URL(as it happens in reponse.redirect).Can anyone please suggest a quick solution to it or may be help me Telling How many users can reponse.redirect can support ?
View 11 Replies
May 7, 2010
Followed the code sample of Chapter 10 (Logging in) of the Book, Microsoft ASP.NET 2.0, I created an ASP.NET 3.5 website with Forms Authentication. The sample code used Website Administration Tool (WAT) to manage the users, roles, and authorization.When running in the ASP.NET Development server environment, I can first login, then click to open the links for each for the 3 roles.
However when running the sample code in the IIS server environment, I can login but can not open the links for the role subfolders.Clicking each link popped up an error message for opening a login.aspx from the specific subfolder. I don't have a Login.aspx file in each subfolder.The 3 role subfolders were configured as the virtual folders in the IIS Server. Why the sample code worked fine inASP.NET Development server environment, but got an error message from theIIS Server environment? Why an authenticated user can not open the subfolder homepage?
View 5 Replies
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 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
Nov 17, 2010
I'm currently developing a website using VS2010 Express/SQL Express 2008, and am using the applications development server to test.
I have created an access layer which effectively takes all my cachable data and creates datasets.
I've also created a system wheras for each dataset, For each dataset I also create a token cached object (a string), which is set to expire before the dataset. The theory behind this is that when my token expires and is removed from cache, it calls a routine to rebuild the dataset, and re-caches the new result, then creates a new token. Think of it as a poor mans SQL dependency.
What this allows me to do is rebuild datasets behind the scenes with little interruption/delay throughout the day. It all works great - for instance when a user updates a table containing 100,000+ records on the site, the dataset rebuilds at hourly intervals reworking and consolidating the data in the background before representing it in a smaller cachable form.
What I would like to know is this. If I was to replace the database during the usable day (only updating the tables that users don't update), lets say adding 50 new records, would it cause the cache to be dropped. The reason I ask is because it the cache remains until its exipry time, I can replace the database and rebuild datasets incorporating new data in the background when the token expires. If the cache is dropped when I update the database, it will mean interuption whilst I reload the datasets and will change my strategy on uploading new data.
I ask the question because I'm currently working on the development server and unable to test in a live server environment at present.
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 31, 2010
Environment.WorkingSet incorrectly reports the memory usage for a web site that runs on Windows 2003 Server.(OS Vers: Microsoft Windows NT 5.2.3790 Service Pack 2, .NET Vers: 2.0.50727.3607)
It reports memory as Working Set(Physical Mem.): 1952 MB (2047468061).
Same web site runs locally on Windows Vista with a Working Set(Physical Mem.): 49 MB (51924992).
I have limited access to the server and support is so limited.
so i have computed the total memory by traversing with VirtualQuery.
Total of pages with state: MEM_FREE is 1300 MB.
(I guess server have 4 GBs of RAM and PAE is not enabled, max user mode virtual address is 0x7fff0000.)
So, i know working set is not only about virtual memory. But, is it normal to have such a high working set while its very low on another machine?
View 2 Replies
Aug 28, 2010
i have done one website and i upload to all file in server..After two day i got error from website starting page Timout error.. too many connections are there so polling timeout..
View 2 Replies
