SharePoint 2010 Project Templates Missing After VS2010 SP1 Installation

After I installed VS2010 SP1, I am now missing the SharePoint 2010 project templates.  Slightly annoying to open projects that used to work fine and seeing this:

The project type is not supported by this installation.

Solution is relatively simple, rebuild the project and item caches in Visual Studio, wish they had this option in the menu system or at least a little more intuitive, but it is what it is Smile

You can try the steps below to reset VS templates:

  1. Open Windows Explorer, and navigate to C:\Program Files \Microsoft Visual Studio 10.0\Common7\IDE
  2. Delete the ItemTemplatesCache, ProjectTemplatesCache folder
  3. Open Visual Studio Command Prompt (2010) with Administrator privilege: right-click the program -> Run as administrator
  4. Run devenv /InstallVSTemplates
    1. Registers project or item templates that are located in <Visual Studio installation path>\Common7\IDE\ProjectTemplates\ or <Visual Studio installation path>\Common7\IDE\ItemTemplates\ so that they can be accessed through the New Project and Add New Item dialog boxes.
  5. Run devenv /Setup
    1. Forces Visual Studio to merge the resource metadata that describes menus, toolbars, and command groups, from all available VSPackages.

 

If you are still unable to open the project:

You can download and install VS 2010 SDK (or VS 2010 SP1 SDK) which contains new project templates such as Item Template template and Project Template template

Visual Studio 2010 SP1 SDK: http://www.microsoft.com/download/en/details.aspx?id=21835

Visual Studio 2010 SDK: http://www.microsoft.com/download/en/details.aspx?id=2680

References:

April 2011 CU for SharePoint 2007 and 2010 has been released today

The product group released the April 2011 Cumulative Update for the SharePoint 2007 and 2010 product family.

The KB articles are not yet available (as usual it will take a couple more days to get these through the required release process) but the fixes can already be downloaded.

As soon as the KB articles are live they can be found at the following locations:

  • KB 2512783 – WSS 3.0
  • KB 2512782 – MOSS 2007
  • KB 2512804 – SharePoint Foundation 2010
  • KB 2512800 – SharePoint Server 2010
  • KB 2512801 – SharePoint Server 2010 with Project Server
    As you see there is a separate Full Server Package for SharePoint Server 2010 with Project Server which simplifies patching of this common installation.

The Full Server Packages for April 2011 CU are available through the following links:

For the 2010 Server Products it is sufficient to install the SharePoint Server 2010 package as it includes the SharePoint Foundation package.

Related Update Centers:

Team Foundation Server 2010–Analysis Database Corrupted, Rebuild It

image

Most large companies that are Microsoft centric rely on TFS for their source control, but it also does so much more (as long as you use it to track work items ad other tasks).  Part of TFS is a SharePoint component that utilizes the platform to create a project portal where various metrics can be displayed in a dashboard.  This works fairly well, but occasionally we’ve found that the TFS analysis database TFS_Analysis has issues and we have to go in and do a little fiddling.  Generally I get the call because I am “The SharePoint Guy” and it somehow relates to SharePoint…

Error Scenarios

Error 1: Message on the portal stating:

Project data is unavailable at this time. As a result, all reports on this dashboard have been hidden. After you have created data in your team project and the warehouse has been processed, reports will be available.

Error 1: Message in Excel Services

Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The PivotTable was not refreshed.

Error 2: Error message in the Event Viewer:

Detailed Message: TF221122: An error occurred running job Incremental Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.
Exception Message: Error encountered when creating connection to Analysis Services. Contact your Team Foundation Server administrator. (type AnalysisServiceConnectionException)

Error 3: Exception Message:

File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Dim Team Project.0.dim\330.ProjectPath.ksstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Team Project dimension, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Dim Team Project.330.dim.xml’.
Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.1191.cub.xml’.
(type OperationException)

Generally it’s not worth the time to try and figure out what went wrong.   It is much simpler in these cases to just rebuild your Cube and Warehouse.

To rebuild the cube and warehouse, following these steps:

1. Delete analysis database TFS_Analysis

  • Go to SQL Server and locate the folders contains TFS_Analysis database C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data
  • Delete following files and folder: Tfs_Analysis.0.db, CryptKey.bin, Tfs_Analysis.0.db
  • Restart SQL Server Analysis Database service

2. To recreate the Tfs_Analysis database, please refer to the following steps:

  • Launch TFS Admin Console | Application Tier | Reporting, in the right panel, click Edit to open the Reporting window.
  • Under the Analysis Services tab, input the Tfs_Analysis under Database textbox, and re-provide the required account under Account for accessing data source.
  • Click Ok to generate the Tfs_Analysis database in Analysis Services.
  • Click Start Jobs and Start Rebuild to rebuild warehouse and the Analysis Services database.  Similarly recreated Tfs_Warehouse database under Warehouse tab in Reporting window.
  • Monitor the progress using http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx
    • Open GetProcessingStatus and hit Invoke. Refresh until JobProcessingStatus=”Idle”.

SharePoint 2010 has SQL error connecting to local database

Log entry for EventID 5586: Unknown SQL Exception 297 occurred.

Additional error information from SQL Server is included below.  

The user does not have permission to perform this action.

This is occurring because your SQL Server has not been configured to use named pipes

Fix: Open the SQL Server Configuration Manager and browse down to SQL Server Network Configuration – Protocols and Right-click “Named Pipes” in the right pane and choose Enable.

You may need to restart the server for changes to take effect.