安装visual studio team system2008

vsts - visual studio team system 2008的安装最重要的影响是mssqlserver的支持。以下是与安装相关的一些要点。
★安装前在msdn下载好安装包和中文chm安装文档。此文档运行前要先在属性中点一下unlock否则打开后无法查看。此安装说明是非常重要的指南，请仔细阅读。
★需要先合成一个包含sp1的tfs - team foundation server安装包。这在sp1的安装说明中有介绍。
★需要完整安装mssqlserver。尤其是full search和report service。安装过程中，要使用native模式。除非装有sharepoint server可以尝试sps集成模式，否则报表网站将无法访问。
★其它组件如iis7，sharepoint service3.0或sharepoint server2007也要确认正常运行。
★在安装tfs前要确认report server访问正常。并使用报表配置工具将服务启动帐号改为tfs管理员要用的帐号。然后重启服务并再次确认report server能正常访问。

★装好tfs再安装build server，最后把team explorer装在客户端。这样就可以在vs2008中使用team explorer访问tfs了。想进一步了解时也可在msdn中找到tfs演练文档。这些文档内容详尽，不过只有在线版。

 三个关于报表的错误：

1、访问报表管理网站，运行某报表时出错：

An error has occurred during report processing. (rsProcessingAborted)



Query execution failed for dataset 'IterationParam'. (rsErrorExecutingCommand)



The Team System cube either does not exist or has not been processed.







解决:







http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/6d1d89c6-d167-4e2c-85d6-8a2e330a1041/?lc=1033







在SQLSERVER管理控制台中连接数据库引擎，在database>Tfswarehouse数据库上点右键，选new query,输入并运行下面的语句







USE [TfsWarehouse] 



GO



CREATE USER [NT AUTHORITY"NETWORK SERVICE] FOR LOGIN [NT AUTHORITY"NETWORK SERVICE]



GO



USE [TfsWarehouse]



GO



EXEC sp_addrolemember N'TfsWarehouseDataReader', N'NT AUTHORITY"NETWORK SERVICE'



GO







结果确认：







仍然用控制台连接到Analysis Service，在database>Tfswarehouse上点右键，选process，再点ok，看一下有没错误。















2、此时再访问报表管理网站，运行bug rate报表时出错：







An error has occurred during report processing. (rsProcessingAborted) Get Online Help



Query execution failed for dataset 'WorkItemTypeParam'. (rsErrorExecutingCommand) Get Online Help



Query (19, 3) The ALLMEMBERS function expects a hierarchy expression for the argument. A member expression was used. 















解决：







http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/6b8a66db-d9f3-4614-8d2c-93db28498ecb/



http://forums.microsoft.com/msdn/MigratedForum.aspx?siteid=1&PostID=366594







Log onto the application tier. Browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx



Click on GetWarehouseStatus, and then click the Invoke button. Wait for it to be idle. It should return ProcessingAdapters (pulling data), ProcessingOlap (processing the cube), or Idle.







Browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx



Click on Run, and then click the Invoke button. This will start the processing of the warehouse. it will return true or false as to whether is started processing (asynchronously). 







You can repeat GetWarehouseStatus to monitor the processing.　　注意一定要通过监控确认状态已经是Idle，否则表示运行未结束。







如果还是不行，







Back up the contents of C:"Program Files"Microsoft SQL Server"MSSQL.2"OLAP"Data and then delete content.    注意是内容，不是整个目录。



run



recreate cube：



cd "C:"Program Files"Microsoft Visual Studio 2008 Team Foundation Server"Tools"



Setupwarehouse -o -s win-ims1hdie39r -d TfsWarehouse -c warehouseSchema.xml -mturl "http://win-ims1hdie39r:8080" -a win-ims1hdie39r"administrator -ra win-ims1hdie39r"william



或



rebuild warehouse：



setupwarehouse -rebuild -mturl "http://win-ims1hdie39r:8080" -s win-ims1hdie39r -d TfsWarehouse -c wareHouseSchema.xml -a win-ims1hdie39r"administrator -ra win-ims1hdie39r"william -edt TfsBuild







确认报表中的bug rate运行正常。















3、在VS2008中无法连接Report.

[Posted with iBlogger from my iPhone]