NullKeyNotAllowed Element (ASSL)

Determines how the Microsoft SQL Server Analysis Services processing engine handles a null key error encountered during processing.

Syntax

<ErrorConfiguration>
   ...
   <NullKeyNotAllowed>...</NullKeyNotAllowed>
   ...
</ErrorConfiguration>

Element Characteristics

Characteristic	Description
Data type and length	String (enumeration)
Default value	ReportAndContinue
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent element	ErrorConfiguration
Child elements	None

Remarks

Null key errors occur when a null value is encountered in a key column in which null values are not allowed, forcing the record to be discarded during processing. However, this error occurs only if the NullProcessing element for the DataItem ancestor of the ErrorConfiguration parent element is set to Error.

The value of this element is limited to one of the strings in the following table.

Value	Description
IgnoreError	Processing ignores the error and continues.
ReportAndContinue	Processing reports the error and continues.
ReportAndStop	Processing reports the error and stops.

The enumeration that corresponds to the allowed values for NullKeyNotAllowed in the Analysis Management Objects (AMO) object model is ErrorOption.

See Also

Reference

ErrorConfiguration Element (ASSL)