keyduplicate-element-assl.md

title	KeyDuplicate Element (ASSL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	KeyDuplicate Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	KeyDuplicate
helpviewer_keywords	KeyDuplicate element
ms.assetid	d7000b8b-e81f-4401-8738-00c2e0f73a59
caps.latest.revision	33
author	Minewiskan
ms.author	owend
manager	erikre

KeyDuplicate Element (ASSL)

Determines how [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] handles a duplicate key error if it encounters one during processing.

Syntax

  
<ErrorConfiguration>  
   ...  
      <KeyDuplicate>...</KeyDuplicate>  
   ...  
</ErrorConfiguration>  

Element Characteristics

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

Element Relationships

Relationship	Element
Parent element	ErrorConfiguration
Child elements	None

Remarks

Duplicate key errors are generated only during dimension processing, when an attribute key is encountered more than once. Because attribute keys must be unique, [!INCLUDEssASnoversion] discards the duplicate records. Duplicate key errors typically indicate a flaw in the design of the dimension, specifically in the relationships between attributes.

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

Value	Description
IgnoreError	Processing should ignore the error and continue.
ReportAndContinue	Processing should report the error and continue.
ReportAndStop	Processing should report the error and stop.

The enumeration that corresponds to the allowed values for KeyDuplicate in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.ErrorOption.

See Also

Properties (ASSL)