Transaction Timeouts And Connection Pools ?
Jan 10, 2012
In an asp.net 2.0 application I maintain, we were experiencing issues with transaction aborted errors (timeout). Code that fails seems to cause a timeout, then the page logging functionality that uses transactionscope (default constructor) fails (but not always). The timeout is set to 2 minutes. Some example code that is similar to what we have in our app is below:[code].....
From what I've seen and read, my guess is that since the using block is never reached, the transaction times out.Then the logging code (done with any page request) tries to enlist in the existing transaction, which has timed out and results in a transaction aborted error (as soon as the constructor is called). Is this assumption correct? Why would only some requests fail going forward and not all (assuming they all use transactionscope)? how does connection pooling play into this? If user A hits the bad code, would user B then be potentially affected by this? This is the behavior we've seen. If not, what else might cause this? I've been to MSDN, but I can't find anything that really clicks with me as to what is happening and why.Here is the relevant portion of the connection string:
Enlist=true;Pooling=true;Connection Lifetime=20;Max Pool Size=25;Min Pool Size=5
FYI. Not sure if this is relevant, but the app uses an Oracle 11g database with the EntLib database factory pattern.
View 1 Replies
ADVERTISEMENT
Oct 31, 2011
I want to know that do you still need to rollback your transaction if you haven't commit the transaction that was created earlier.
[Code]...
View 3 Replies
May 9, 2011
I get this error at the Commit of a transaction in a desktop application:
This OleDbTransaction has completed; it is no longer usable.
Other posts I have seen with similar error suggests this can occur if it takes a long time, or contains large amounts of data. This is not the case here.Logging tells me it takes 140 ms from Begin to Commit and about 10 commands executed inside the transaction.It is using an Oracle database.This class is a simplified version of my database class:
Class MyDatabase
Private mConnection AS OleDbConnection
Private mTransaction AS OleDbTransaction
[code]....
Is it not allowed to run a select inside a transaction like this? Or can it be done by running the transaction in a specific isolation level (I see that the BeginTransaction method has an optional parameter for doing this) ? ..Or some other sollution..? In my case, it was not a problem to move the select to run before the transaction started, but what if you need to run selects that must run inside the transaction?
View 1 Replies
Apr 29, 2009
I've seen plenty of examples of transactions in the actual store procedure's SQL. But I'm wanting to do the transaction and keep track of it in code. I tried this but it says that my insertcommand's transaction object is null. How can I fix this?
vb Dim conn As SqlConnection = DBConnections.SQLServerConnection
conn.Open()
Dim params(1) As SqlParameter
[CODE]....
View 3 Replies
Mar 5, 2009
What is this kind of exception?
Error : Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The transaction property of the command has not been initialized..
This one causes the error: Dim oOperation As COperationOutputTypeBS
oOperation = COperationOutputTypeBS.GetOperationOutputType(txtOperationCode.Text)
View 1 Replies
Nov 8, 2007
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
View 7 Replies
Jun 30, 2010
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
View 1 Replies
May 3, 2011
I'm using HTMLAgilityPack in a parser that I have up on a server, but I'm having issues with one of the websites that I'm parsing: Every day around 6am they tend to shut down their servers for maintenance, which throws off the Load() method for HTMLWeb, and makes my app crash. Do any of you guys have a more secure way of loading a website into HTMLAgilityPack, or maybe some way to do error checking in C# to prevent my app from crashing? (my c# is a little rusty). Here is my code right now:
HtmlWeb webGet = new HtmlWeb();
HtmlDocument document = webGet.Load(dealsiteLink); //The Load() method here stalls the program because it takes 1 or 2 minutes before it realizes the website is down
View 2 Replies
Apr 20, 2011
The current version of my application was using the WebClient object to download files from the internet and all was working well until some users reported that they were getting server timeouts. I looked into this issue and decided to move to the WebRequest object as it allows me to specify a Timeout value. The problem is, when using it synchronously, if I specify a timeout value of -1, I am worried that in the event of some weird server anamoly, my application would hang as it would be waiting for a response that isn't coming. So then I thought of using the WebRequest ansynchronously.
[Code]....
View 8 Replies
Jul 28, 2009
I'm writing a web crawler for a specific site. The application is a VB.Net Windows Forms application that is not using multiple threads - each web request is consecutive. However, after ten successful page retrievals every successive request times out. I have reviewed the similar questions already posted here on SO, and have implemented the recommended techniques into my GetPage routine, shown below:
[Code]...
View 4 Replies
Feb 19, 2009
I'm running some unit tests for a large VB.Net application I help maintain and am running into problems with tests timing out. The test run is set up so that there's no timeout limit on the overall test run, but a limit of 2 minutes per individual test. However, a couple of the tests take a lot longer than this to run, so we tried adding the timeout attribute to the test's declaration, i.e
<TestMethod(), Timeout(15 * 60 * 1000)> Public Sub DoSomething()
for a 15 minute timeout. However, the 2 minute timeout set in the test run properties seems to be taking precedence, even though it says that the timeout attribute should override it.
View 1 Replies
Jan 18, 2011
I have been using the following Stream Reader code for over a year now to pull information from 3 websites w/ no issues. Recently my users are getting massive amounts of "Timeout" errors. I have opened a ticket w/ the IT department but they have not found any issues (we are experiencing off/on issues w/ our web traffic speeds in our department). Per the code I have the timeout set to 20 seconds but the Timeout error occurs in only a few seconds from the System.Net.WebException.
Imports System.Text.RegularExpressions
Imports System.Net
Imports System.IO
[code]....
View 5 Replies
Oct 14, 2010
I have code in an ASP.NET form that needs to, depending on user entry create messages in the database. We are speaking of potentially thousands of db entries. How do I protect against deadlocks, I mean apart from using Transactions and setting IsolationLevel to Serializable, as well as using WITH(NOLOCK) statement on my select statements since I don't mind a dirty read.
[Code]...
View 1 Replies
Sep 12, 2011
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Replies
Sep 22, 2010
I am getting the following error while handling transaction(Isoloation level is serializable) in Ado.Net."Transaction (Process ID 75) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."
View 3 Replies
May 20, 2010
Can I code to add transaction for some subs? If there is an error in any sub will roll back.For example,
sub1 delete some tables
sub2 insert data into tables which just be deleted
sub3 send out confirmation email
sub4 make submit button disable
I knew that transaction will work for sub1 and sub2 but I do not know if transaction will work for all of subs
View 1 Replies
May 24, 2012
I searched araound and having some difficulties in implementing one scenario with SQL Server 2000 and sybase.I have two SQL servers on different locations naming ServerA (MSSQL Server) and ServerB (Sybase server).I have a table called SALARY.Whenever I insert one record to customer SALARY in ServerA, I also will insert it into ServerB.If should any of them failed, both of them should be rolled back.I am using Asp .Net with VB for the programming.I do not have the right to change / add table in Server B. The only thing allowed in Server B is insert/delete/update record.I looked around and find a method to use TransactionScope but I am not quite sure it is the right way to do.url...
View 1 Replies
Sep 27, 2011
I've found my current side project has become a great learning experience and have decided to keep it going that way. What I'm trying to do is update a table from a DataTable. The datatable has been created and isn't a direct result of a
query otherwise I'd just use a update and not learn anything new. This is what I have for code thus far[code]...
View 2 Replies
Jun 12, 2011
I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized." Pointing to this block.[code...]
View 1 Replies
Mar 7, 2012
While working on some functions that update my database, I was writing some quick tests just to make sure my functions were executing properly. When it comes time to actually update the database I can pass a transaction to a function and then commit it:
user.Assignment("assignment value for some column in table", connection, transaction)
transaction.Commit()
I am curious if there is a way to write a quick test that can verify that the transaction will actually update certain rows before committing?
(pseudoish-code)
user.Assignment("assignment value for some column in table", connection, transaction)
If Not transaction["SomeColumn"] = "Expected value for SomeColumn"
assert("ColumnName was not going to be updated to the expected value!")
transaction.Rollback()
View 2 Replies
Mar 20, 2012
In my project i am using begin transaction commit or rollback changes. but this causes lock to the tables in that particular functionality.
So if the any other user does any other functionality those locked table are not available until the transaction is completed. I want to know if there is any alternative to transaction which insures data security but the tables are not locked out.
View 1 Replies
Jun 21, 2010
i am building a transaction called client search the location of movie in store which mean client search the movie then get the direction of the movie where it is located in store. So now i need to build classes for this transaction which i am unable to find it because i am confuse about direction table .
View 1 Replies
Oct 8, 2011
I am using visual studio 2008. and i put dataset to use report wizard. but, when i compiled it, i got this errors.
Error1Property 'Transaction' is 'ReadOnly'.C:\Documents and Settings\mahalia\Desktop\NewProject\NewProject\DataSet2.Designer.vb292321NewProject
Error6'OracleDbTypeEx' is not a member of 'Oracle.DataAccess.Client.OracleParameter'.C:\Documents and Settings\mahalia\Desktop\NewProject\NewProject\DataSet2.Designer.vb299113NewProject
--- and when i locate it, i saw it in dataset.designer.vb.
View 4 Replies
Sep 5, 2011
I am generating new code for a transaction.
View 11 Replies
Mar 5, 2010
I'm learning about VB.Net and need to work with an SQLite database using the open-source System.Data.SQLite ADO.Net solution.The examples I found in the HOWTO section are only in C#. Would someone have a simple example in VB.Net that I could study to understand how to use transactions when INSERTing multiple parameters?[code]
View 2 Replies
May 28, 2009
However, I've just inherited a problem and was wondering if anyone knows if I can solve it with a command line application written in .NET. Basically, we have a SAP transaction which has been written which imports data from a csv file.At the moment, it will be a manual process requiring someone to log in and run the transaction. Does anyone know if it's possible to action this from a command line app which we could then set up as a scheduled task?
View 1 Replies
May 4, 2012
We are developping an application VB.net 2.0 and SQL 2005. Users are allowed to cancel a reception based on a purchase which may contains many received goods. But, during the process of cancellation, some questions are asked to users such as "Do you want to cancel Good #1".
If yes, delete. Then, "Do you want to cancel Good #2", no, do not delete and one another question (if received item is issued, a process must be made manualy by the user). And, at the end, if all goods were successfully cancelled, we have to cancel the reception itself. But sometime, if an error occurs or some conditions occurs once asked to user in this process, we want to cancel any actions made from the beginning and make it back to his original state. So I thought about Transaction.
[Code]...
View 1 Replies
Mar 7, 2012
I am trying to use a transaction for the duration that the dialog is open and then commit the changes once the dialog has been ok�d or rollback'd if canceled by the user.My problem is when I use the transaction it is locking the whole of the tables that I�m using to update and insert new records too.I update the record in the first (current) table and insert a new record into the second (history) table. Obviously this is causing me problems as I only want the transaction to lock the specific records i'm updating and not allow a new insert record with my PK associated to my that I�m updating, not lock the whole of the 2 tables.This is my code[code]....
View 3 Replies
Nov 11, 2011
I have 2 tables which I want to insert data into, table "CAM" and table "COut", after inserting data in "CAM" it shall return a retAutoID which will be hand to "COut" as one of the parameter required for it's insertion. I implemented a rollback in my Business Logic such that if "Cout" hits an exception error while inserting, the previous insertion for "CAM" will rollback even if successful.With the code below, I am getting this error after trying to do perform insertion:"ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized." [code]
View 2 Replies
Jan 4, 2012
I'm trying to add transaction support to our database object.This object is a Remoting object. (this to ensure that on the Windows Client, no database connection is required.)Now I want to add support for transactions;Basically, a client will need to use it like this;
BeginTransaction
ExecuteNonQuery("insert...")
ExecuteNonQuery("insert...")
[code].....
View 2 Replies
