TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

NullKeyNotAllowed Element (ASSL)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueReportAndContinue
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementErrorConfiguration
Child elementsNone

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.

ValueDescription
IgnoreErrorProcessing ignores the error and continues.
ReportAndContinueProcessing reports the error and continues.
ReportAndStopProcessing 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.

ErrorConfiguration Element (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft