You are currently offline, waiting for your internet to reconnect

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"

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
Properties

Article ID: 2431362 - Last Review: 10/18/2010 21:38:00 - Revision: 1.0

Microsoft SQL Server 2008 R2 Analysis Services

  • kbautohotfix kbqfe kbhotfixserver kbfix KB2431362
Feedback
ay: none; " src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">e; " src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">