The commit / rollback transaction request has no corresponding BEGIN TRANSACTION

Article ID: 987
Last updated: 01 Feb, 2008
Article ID: 987
Last updated: 01 Feb, 2008
Revision: 1
Views: 8682
Posted: 03 Dec, 1999
by Dean J.
Updated: 01 Feb, 2008
by Dean J.
Problem


The error message(s):

 

The rollback transaction request has no corresponding BEGIN TRANSACTION.

or

 

The commit transaction request has no corresponding BEGIN TRANSACTION.

are occurring in my application even though a BEGIN TRANSACTION call is made.


Cause


One cause of these error messages is a permission error on the database server. According the Sybase and MS-SQL Server documentation:

 

Permission errors roll back transactions to the first begin transaction.

All work that was attempted inside of the transaction (or transactions) that failed will be rolled back.


Action


Be aware that Sybase and MS-SQL Server both behave in this manner, and write your applications to take the possibilitiy of these errors into account. One method would be to check specifically for these error messages (or error codes) and then handle the situation as necessary. For more information on error handling in DBTools, please see section 8.3 of your online or printed DBTools.h++ documentation.
This article was:   Helpful | Not helpful
Report an issue
Article ID: 987
Last updated: 01 Feb, 2008
Revision: 1
Views: 8682
Posted: 03 Dec, 1999 by Dean J.
Updated: 01 Feb, 2008 by Dean J.

Others in this category