BUG: ADOMD Hangs if no BeginTrans Corresponding to CommitTrans (231987)

The information in this article applies to:

Microsoft SQL Server OLAP Services 7.0

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

Modification Type:	Major	Last Reviewed:	10/16/2003
Keywords:	kbbug kbpending KB231987