basquang™ on clouds

October 26, 2015

TFS 2015: Fail to create Team Project

Filed under: TFS — basquang @ 2:03 PM
Tags:

You may receive following error when try to create TFS Team Project from Visual Studio

Problem: Fail to create team project

Error
The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services on http://win-i20evd01dob/ReportServer/ReportService2005.asmx.
Explanation
The Project Creation Wizard encountered a problem while creating reports on the SQL Server Reporting Services on http://win-i20evd01dob/ReportServer/ReportService2005.asmx. The reason for the failure cannot be determined at this time. Because the operation failed, the wizard was not able to finish creating the SQL Server Reporting Services site.
User Action
Contact the administrator for the SQL Server Reporting Services on http://win-i20evd01dob/ReportServer/ReportService2005.asmx to confirm that the SQL Server Reporting Services server is running and you have sufficient privileges to create a project. Your user account on SQL Server Reporting Services must have Content Manager permission to create a new project. Also, you might find additional helpful information in the project creation log. The log shows each action taken by the wizard at the time of the failure and may include additional details about the error.
Open the log file you may see:
Event Description: TF30162: Task “Populate Reports” from Group “Reporting” failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services
Exception Message: TF30225: Error uploading report ‘Backlog Overview’: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. —> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (type ReportingUploaderException)
Assumption:
1. The SQL Server Reporting Services is running
2. You are logged in as [DOMAIN]\AccountName to Team Foundation Server to create Team Project
Solution:
You have following items to check:
1. Open Team Foundation Administration Console
a. In Application Tier | Reporting Services Summary has valid Reader Account for example [DOMAIN]\AccountName. If not enter that account
b. In Reporting tab, Edit the Reporting configuration and in Reports tab enter valid account for “Account for accessing datasource” for example [DOMAIN]\AccountName
2. Open Reporting Services Configuration Manager
a. In Encryption Keys tab, try to delete Encrypted Content
b. In Execution Account tab, enter valid account for example [DOMAIN]\AccountName
c. In Database tab, enter try to enter valid account for “Current Report Server Database Credential” for example [DOMAIN]\AccountName
3. Open Report Manager URL at http:/……/Reports
Open security setting for your TFS Reports Database and make sure that your account [DOMAIN]\AccountName. has Content Manager and Team Foundation Content Manager Role Assigment
Hop this help!
Advertisements

June 27, 2012

TFS 2010: Analysis Database corrupted

Filed under: Microsoft Technology,TFS,Tips — basquang @ 10:56 AM

Sometime TFS analysis database TFS_Analysis may get problems. For examples:

Error 1: 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: 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)

In these cases you may have to rebuild the Cube and Warehouse of your TFS.

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.
The similar way to recreated Tfs_Warehouse database under Warehouse tab in Reporting window.

Hope this help!

April 17, 2012

TFS 2010 “TF30063: You are not authorized to access…” resolved.

Filed under: TFS — basquang @ 4:17 PM

You may get this message on JDeveloper when integrated with TFS 2010: “TF30063: You are not authorized to access…”. To resolve the issues, try following step.

1. Join your computer to the domain that TFS belong to.

2. In your computer, for me Windows 7, open Control Panel | User Accounts | Manage Your Credentials and Add a Windows credential to the Team Foundation Server.

image

After Add a Windows credential the result look like

image

3. Now reconnect your JDeveloper with the TFS Workspace.

Hope this help!

July 8, 2011

TFS2010: Project data is unavailable at this time

Filed under: SharePoint,TFS — basquang @ 3:19 PM

Error:

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.

Solution:

Using the TFS console
1. Verify connectivity to Analysis service (Edit->Analysis->Test connection).
2. Check what account TFS uses to connect to Analysis Services..
3. Rebuild the Analysis and Warehouse data.

Using SQL Management Studio.
4. Verify connectivity to the Analysis service
5. Verify Impersination account setting on Tfs_AnalysisDataSource (I re-entered the password here)

Using http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx
6. Open ProcessAnalysisDatabase, enter “Full” as processingType and hit “Invoke”
7. Open GetProcessingStatus and hit Invoke. Refresh until JobProcessingStatus=”Idle”.

July 4, 2011

[Error] TFS255329: Connect TFS 2010 to SharePoint 2010

Filed under: SharePoint,TFS — basquang @ 5:44 PM

Solution:

1. Make sure Team Foundation Server Extension for SharePoint has already installed on SharePoint Server

2. Make sure your SharePoint Web Application does not allow anonymous access.

Create a free website or blog at WordPress.com.