Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shaila24072009
Starting Member
7 Posts |
 Posted - 2009-07-29 : 01:19:27
|
| We are getting error 'Root Transaction wanted to Commit, but transaction aborted' message, when trying to insert huge data transaction on one of the tables. We are using Windows operation system Windows server 2003, Service pack 2. If we uninstall Service pack 2 then the problem gets solved automatically. Please let us know the reason for this problem. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Shaila24072009
Starting Member
7 Posts |
Posted - 2009-07-29 : 23:32:17
|
Here is the complete description of the problem.We have a module in our project, which reads data from XML file and merges the data into the database. This merging at one end happens to a SQL Server 2005/SQL Server 2000 datbase. At the other end it happens to a Oracle database. We have a portal application developed in ASP.NET from where, we merge the data. When the data to be merged is very huge, we get this message. 'The root transaction wanted to commit, but transaction aborted'. Right now we are getting this message, when we try to merge data on to a oracle database. But this problem is very intermittent. It happens only when there is huge amount of data to be inserted to one table. As i have mentioned in my post, we use Windows server 2003 operation system with service pack 2. This error does not come when we do the same operation with service pack 1. So is it OS dependent? quote:
Originally posted by tkizer
And what are you using for SQL Server? What programming language is this? This doesn't look like a SQL Server message.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Root transaction wanted to commit, but transaction