BUG: Missing Values For Database Event Constants (289748)



The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services

This article was previously published under Q289748
BUG #: 11981 (plato7.x)

SYMPTOMS

SQL Server 2000 Books Online supplies the names of constants used by the Action parameter in the ReportAfter, ReportBefore, ReportError, and ReportProgress events of the Database interface, supported by the Decision Support Objects (DSO) library, but does not supply their values.

CAUSE

The documentation incorrectly assumes that the constants are included as part of an enumeration. The constants, detailed in the "Events" topic in SQL Server 2000 Books Online, are not actually supplied as an enumeration in order to maintain backwards compatibility.

WORKAROUND

You may use the following list of constants and associated values as needed in client applications that reference the DSO library and use the events supported by the Database interface:

Public Const mdactProcess = 1
Public Const mdactMerge = 2
Public Const mdactDelete = 3
Public Const mdactDeleteOldAggregations = 4
Public Const mdactRebuild = 5
Public Const mdactCommit = 6
Public Const mdactRollback = 7
Public Const mdactCreateIndexes = 8
Public Const mdactCreateTable = 9
Public Const mdactInsertInto = 10
Public Const mdactTransaction = 11
Public Const mdactInitialize = 12
Public Const mdactCreateView = 13
Public Const mdactWriteData = 101
Public Const mdactReadData = 102
Public Const mdactAggregate = 103
Public Const mdactExecuteSQL = 104
Public Const mdactNowExecutingSQL = 105
Public Const mdactExecuteModifiedSQL = 106
Public Const mdactConnecting = 107
Public Const mdactRowsAffected = 108
Public Const mdactError = 109
Public Const mdactWriteAggsAndIndexes = 110
Public Const mdactWriteSegment = 111
Public Const mdactDataMiningProgress = 112
				


Also, the following undocumented constants are used to provide warning information in the ReportError and ReportProgress events:

ConstantDescription
Public Const mdwrnSkipped = 901The processing of an object was skipped.
Public Const mdwrnCubeNeedsToProcess = 902Reserved for future use.
Public Const mdwrnCouldNotCreateIndex = 903The Analysis server could not create an optional index for an aggregation during the processing of a ROLAP dimension or partition.
Public Const mdwrnTimeoutNotSetCorrectly = 904DSO failed while attempting to set a timeout value on a relational data source.
Public Const mdwrnExecuteSQL = 905The execution of an optional SQL statement failed during processing.
Public Const mdwrnDeletingTablesOutsideOfTransaction = 906The relational provide does not support the use of SQL data definition language (DDL) commands within a transaction. In this case, DSO then deletes tables outside of the transaction during processing.
Public Const mdwrnCouldNotProcessWithIndexedViews = 907DSO failed to process a partition that uses indexed views. In this case, DSO resumes processing the partition by using aggregation tables.

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0.

Modification Type:MinorLast Reviewed:4/24/2003
Keywords:kbBug kbnofix KB289748 kbAudDeveloper