Microsoft KB Archive/231987

= BUG: ADOMD Hangs if no BeginTrans Corresponding to CommitTrans =

Article ID: 231987

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q231987



BUG #: 556 (plato7x)



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 = " cn.CommitTrans

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

Keywords: kbbug kbpending KB231987

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.