BUG: ADOMD Hangs if no BeginTrans Corresponding to CommitTrans

ID: Q231987

BUG #: 556 (plato7x)
The information in this article applies to:

SYMPTOMS

A program using ADOMD may hang with 100% CPU if it has a CommitTrans with no corresponding BeginTrans. In the same scenario ActiveX Data Objects (ADO) gives the following run-time error:

-2147168242 : No Transaction is active


WORKAROUND

Always pair BeginTrans with CommitTrans.


STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.


MORE INFORMATION

The problem can be easily reproduced by running the following code in Visual Basic: 


Dim cn As New ADODB.Connection
cn.Open "Provider=MSOLAP; Data Source = <servername>"
cn.CommitTrans

Additional query words: Transactions, commit, ADO, ADOMD, ADO MD, freeze, lock up, hang 


Keywords          : SSOSadomd 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: June 3, 1999