FIX: Error message when you try to create a named query in a project that uses SQL Server 2008 R2 Parallel Data Warehouse as a data source: "Keyword not supported"

Article translations Article translations
Article ID: 2431362 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • On a computer that is running SQL Server 2008 R2, you create an Analysis Services project or a Report Model project in SQL Server Business Intelligence Development Studio (BIDS). 
  • In the project, you create a data source that uses the Microsoft SQL Server 2008 R2 Parallel Data Warehouse .NET Provider to connect to the Microsoft SQL Server Parallel Data Warehouse. 
  • You create a data source view that is based on the data source. Then, you try to create a named query. 
In this scenario, the named query is not created. 

When this problem occurs, you may receive an error message that resembles the following:

Keyword not supported

Note The use of the .NET provider for SQL Server 2008 R2 Parallel Data Warehouse is supported only for Report Model projects. Analysis Services projects for the SQL Server Parallel Data Warehouse should use the OLE DB provider instead. 

CAUSE

The issue occurs because the SQL editor that is used to edit the named queries does not support the SQL Server Parallel Data Warehouse version of the SQL language. 

RESOLUTION

Cumulative update information

SQL Server 2008 R2

The fix for this issue was first released in Cumulative Update 4. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
2345451 Cumulative Update package 4 for SQL Server 2008 R2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

STATUS

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

MORE INFORMATION

For more information, visit the following Microsoft webpages:
Defining Named Queries in a Data Source View (Analysis Services)
How to: Add, View, Modify, or Delete a Named Query Using Data Source View Designer (Analysis Services)
Create/Edit Named Query Dialog Box (Analysis Services - Multidimensional Data)
For more information about a related issue, click the following article number to view the article in the Microsoft Knowledge Base:
2428397 FIX: Error "Type mismatch" when you try to delete an embedded PowerPivot database from a SQL Server 2008 R2 Analysis Service instance installed in the SharePoint integration mode

Properties

Article ID: 2431362 - Last Review: October 18, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Analysis Services
Keywords: 
kbautohotfix kbqfe kbhotfixserver kbfix KB2431362

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com