BUG: ADOMD Hangs if no BeginTrans Corresponding to CommitTrans

• Microsoft SQL Server OLAP Services version 7.0

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