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"

Applies to: SQL Server 2008 R2

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.

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:
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