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: |
Public Const mdwrnSkipped = 901 | The processing of an object was skipped. | Public Const mdwrnCubeNeedsToProcess = 902 | Reserved for future use. | Public Const mdwrnCouldNotCreateIndex = 903 | The Analysis server could not create an optional index for an aggregation during the processing of a ROLAP dimension or partition. | Public Const mdwrnTimeoutNotSetCorrectly = 904 | DSO failed while attempting to set a timeout value on a relational data source. | Public Const mdwrnExecuteSQL = 905 | The execution of an optional SQL statement failed during processing. | Public Const mdwrnDeletingTablesOutsideOfTransaction = 906 | The 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 = 907 | DSO failed to process a partition that uses indexed views. In this case, DSO resumes processing the partition by using aggregation tables. |
STATUSMicrosoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0.
Modification Type: | Minor | Last Reviewed: | 4/24/2003 |
---|
Keywords: | kbBug kbnofix KB289748 kbAudDeveloper |
---|
|