Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot use the same name for a named query and a DSV file in SSAS 2012


View products that this article applies to.

Symptoms

Assume that you create a project by using the "Analysis Services Multidimensional and Data Mining Project" template in Microsoft SQL Server Data Tools on a computer that has Microsoft SQL Server 2012 Analysis Services installed. In the project, you create a Data Source View (DSV) file and a named query that have the same name. In this situation, you cannot process the dimension that is based on that named query. Additionally, you receive an error message that resembles the following:

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

↑ Back to the top


Cause

This issue occurs because the named query does not have a unique identifier.

In a DSV file, you cannot define the same name for a named query together with a Data Source View or any other objects that might load at the same time as the named query when you process the dimension. This behavior is by design.

↑ Back to the top


Workaround

To work around this issue, use a unique name for the named query when you create it.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbsurveynew, kbtshoot, kbexpertiseadvanced, kb

↑ Back to the top

Article Info
Article ID : 2818448
Revision : 1
Created on : 1/7/2017
Published on : 3/26/2013
Exists online : False
Views : 267