“This SqlTransaction has completed; it is no longer usable.”… configuration error?

I believe this error message is due to a “zombie transaction”.

Look for possible areas where the transacton is being committed twice (or rolled back twice, or rolled back and committed, etc.). Does the .Net code commit the transaction after the SP has already committed it? Does the .Net code roll it back on encountering an error, then attempt to roll it back again in a catch (or finally) clause?

It’s possible an error condition was never being hit on the old server, and thus the faulty “double rollback” code was never hit. Maybe now you have a situation where there is some configuration error on the new server, and now the faulty code is getting hit via exception handling.

Can you debug into the error code? Do you have a stack trace?

Related Posts:

  1. What is a stored procedure?
  2. Must declare the scalar variable
  3. Must declare the scalar variable
  4. T-SQL split string based on delimiter
  5. SQL Server WITH statement
  6. SQL Server Insert if not exists
  7. SQL Server: Invalid Column Name
  8. SQL Server IF NOT EXISTS Usage?
  9. What is the difference between a stored procedure and a view?
  10. What’s the best way to search for a UPC code in a Database?
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  13. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  14. What is the difference between UNION and UNION ALL?
  15. Selecting COUNT(*) with DISTINCT
  16. Case in Select Statement
  17. ORA-00904: invalid identifier
  18. SQL WITH clause example [duplicate]
  19. Unknown column in ‘field list’ error on MySQL Update query
  20. Unknown column in ‘field list’ error on MySQL Update query
  21. SQL Inner-join with 3 tables?
  22. The wait operation timed out. ASP
  23. What is SELF JOIN and when would you use it? [duplicate]
  24. The wait operation timed out. ASP
  25. Conversion failed when converting date and/or time from character string while inserting datetime
  26. Self Join to get employee manager name
  27. How do I UPDATE from a SELECT in SQL Server?
  28. how to fix oracle ORA-01722 invalid number error
  29. SQL query to select dates between two dates
  30. MySQL – Operand should contain 1 column(s)
  31. SQL SELECT WHERE field contains words
  32. Conversion failed when converting date and/or time from character string while inserting datetime
  33. When should I use CROSS APPLY over INNER JOIN?
  34. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  35. Insert Data Into Temp Table with Query
  36. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  37. MySQL create table if not exists and insert record only if table was created
  38. error, string or binary data would be truncated when trying to insert
  39. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  40. NOT IN vs NOT EXISTS
  41. SQL SELECT WHERE field contains words
  42. Online SQL Query Syntax Checker
  43. How can I do an UPDATE statement with JOIN in SQL Server?
  44. ORA-00979 not a group by expression
  45. ORA-00907: missing right parenthesis
  46. How do I use properly CASE..WHEN in MySQL
  47. Rename column SQL Server 2008
  48. Why do we need “Relationships” between tables at all?
  49. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  50. Using group by on multiple columns
  51. Efficiently convert rows to columns in sql server
  52. How can I do a FULL OUTER JOIN in MySQL?
  53. Nested select statement in SQL Server
  54. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  55. Using group by on multiple columns
  56. SQL SELECT WHERE field contains words
  57. MySQL query String contains
  58. How do I escape a single quote in SQL Server?
  59. What’s the difference between VARCHAR and CHAR?
  60. SQL Server IF EXISTS THEN 1 ELSE 2
  61. Case statement in MySQL
  62. How to declare a variable in MySQL?
  63. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  64. Finding duplicate values in a SQL table
  65. ORA-01843 not a valid month- Comparing Dates
  66. MySQL Cannot Add Foreign Key Constraint
  67. Drop a temporary table if it exists
  68. How do I escape a single quote in SQL Server?
  69. ORA-00918: column ambiguously defined in SELECT *
  70. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  71. How Stuff and ‘For Xml Path’ work in SQL Server?
  72. IDENTITY_INSERT is set to OFF – How to turn it ON?
  73. Oracle error : ORA-00905: Missing keyword
  74. How to split the name string in mysql?
  75. How to reset AUTO_INCREMENT in MySQL
  76. How do I import an SQL file using the command line in MySQL?
  77. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  78. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  79. mysql Foreign key constraint is incorrectly formed error
  80. How do I limit the number of rows returned by an Oracle query after ordering?
  81. Sql Server equivalent of a COUNTIF aggregate function
  82. Oracle SELECT TOP 10 records
  83. MySQL: Invalid use of group function
  84. must appear in the GROUP BY clause or be used in an aggregate function
  85. Column name or number of supplied values does not match table definition
  86. Inserting data into a temporary table
  87. Can a foreign key be NULL and/or duplicate?
  88. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  89. Why does NULL = NULL evaluate to false in SQL server
  90. How to Select Top 100 rows in Oracle?
  91. Simple PHP Pagination script
  92. How do composite indexes work?
  93. CREATE VIEW must be the only statement in the batch
  94. How can I return pivot table output in MySQL?
  95. SQL Server FOR EACH Loop
  96. Difference between JOIN and INNER JOIN
  97. ORA-12560: TNS:protocol adaptor error
  98. Compare dates in MySQL
  99. Best way to do nested case statement logic in SQL Server
  100. How can I select the first day of a month in SQL?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)