TFS 2012报告和分析服务的问题 [英] TFS 2012 Problems with Reporting and Analysis Services
问题描述
我已经在一组新的服务器上安装了两次TFS 2012
我似乎无法使报告服务报告正常工作。重建仓库和分析服务多维数据集。首先，我的数据源似乎无法使用，当我测试它时，我收到一条消息说登录失败。
----------------- -------------------------------------------------- -----------------------------------------------
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException：登录尝试为用户 'xxxxxxxxxxxs' 失败，Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException：登录失败。确保用户名和密码正确无误。 --->
System.ComponentModel.Win32Exception：登录失败：未在此计算机上授予用户请求的登录类型
在Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login（String userName，String userPwd，String domain）
---内部异常堆栈跟踪结束---;
处理！ReportServer_0-1！f90！07/20 / 2012-13：28：26 :: e错误：抛出Microsoft.ReportingServices.ReportProcessing.ReportProcessingException：，Microsoft.ReportingServices.ReportProcessing.ReportProcessingException：无法模拟用户的数据源
''。 ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException：登录失败。确保用户名和密码正确无误。 ---> System.ComponentModel.Win32Exception：登录失败：未在此计算机上授予用户所请求的登录
类型
---内部异常堆栈跟踪结束---;
库！ReportServer_0-1！5c8！07/20 / 2012-13：28：26 :: Call到GetSystemPropertiesAction（）。
---------------------------------- -------------------------------------------------- ----------------------------------------
我授予了用于数据源服务器admin的帐户。这至少使它们可用。
然后当我运行报告时，我一直看到这条消息：
错误状态，剩余工作：
报告处理期间发生错误。 （rsProcessingAborted）
数据集"dsArea"的查询执行失败。 （rsErrorExecutingCommand）
错误趋势
报告处理过程中出错。 （rsProcessingAborted）
数据集"dsIteration"的查询执行失败。 （rsErrorExecutingCommand）<跨度>&NBSP;&NBSP;&NBSP;
我使用TFS管理控制台以及Web服务和SQL Server管理工作室重建了仓库和分析服务多维数据集。
报告服务日志显示以下内容：
------------------------ -------------------------------------------------- --------------------------------------
处理！ReportServer_0-1！918！07/20 / 2012-13：19：41 :: w警告：数据源'TfsOlapReportDS'：报告处理已中止。
处理！ReportServer_0- 1 918 7月20日/ 2012-13：！19：41 :: e错误：引发Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException：，Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException：报告
处理过程中发生错误。 ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException：数据集'dsArea'的查询执行失败。 ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException：Team System多维数据集不存在
或尚未处理。
：Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular（CommandBehavior behavior，ICommandContentProvider contentProvider，AdomdPropertyCollection
commandProperties，IDataParameterCollection parameters）
<跨度>&NBSP;&NBSP; 在Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader（CommandBehavior behavior）
在Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader（CommandBehavior behavior）
在Microsoft.ReportingServices.DataExtensions.AdoMdCommand.ExecuteReader（CommandBehavior behavior）
的Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery（布尔&安培; readerExtensionsSupported，布尔&安培; readerFieldProperties，List`1 queryParams，对象[] paramValues）
<跨度>&NBSP;&NBSP ; ---内部异常堆栈跟踪结束---
的Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery（布尔&安培; readerExtensionsSupported，布尔&安培; readerFieldProperties，List`1 queryParams，对象[] paramValues）
<跨度>&NBSP;&NBSP ; 的Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQueryAndProcessAsIRowConsumer（布尔processAsIRowConsumer）
<跨度>&NBSP;&NBSP; 在Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process（）
在Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent（Object threadSet）
---内部异常堆栈跟踪结束---;
是否有人能够获得任何TFS 2012报告？
Martin Huige
嗨马丁，
;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;我在安装TFS时遇到了一些问题，但计算机重新启动修复了我的安装和配置问题。
我概述了TFS 2012的步骤和我的经验@
http://kishore1021.wordpress.com/2012/07/20/team -foundation-server-2012-rc-install-configure /
问候，
I've installed TFS 2012 twice on a fresh set of servers
I cannot seem to get the reporting services reports working. Rebuilt the warehouse and analysis services cube. First I the data sources seemed to be unusable, when I tested them I got a message saying logon failed.
------------------------------------------------------------------------------------------------------------------
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon attempt for user 'xxxxxxxxxxxs' failed., Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: Logon failure: the user has not been granted the requested logon type at this computer
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(String userName, String userPwd, String domain)
--- End of inner exception stack trace ---;
processing!ReportServer_0-1!f90!07/20/2012-13:28:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot impersonate user for data source ''. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: Logon failure: the user has not been granted the requested logon type at this computer
--- End of inner exception stack trace ---;
library!ReportServer_0-1!5c8!07/20/2012-13:28:26:: Call to GetSystemPropertiesAction().
----------------------------------------------------------------------------------------------------------------------------
I granted the account used for the data sources server admin. That at least made them usable.
Then when I ran reports I keep seeing this message:
Bug status, remaining work:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand)
Bug trends
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'dsIteration'. (rsErrorExecutingCommand)
I rebuilt the warehouse and the analysis services cube using the TFS Admin console, as well as the web service and SQL Server management studio.
The reporting services log shows the following:
----------------------------------------------------------------------------------------------------------------
processing!ReportServer_0-1!918!07/20/2012-13:19:41:: w WARN: Data source 'TfsOlapReportDS': Report processing has been aborted.
processing!ReportServer_0-1!918!07/20/2012-13:19:41:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dsArea'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The Team System cube either does not exist or has not been processed.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.AdoMdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQueryAndProcessAsIRowConsumer(Boolean processAsIRowConsumer)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---;
Has anyone been able to get any of the TFS 2012 reports working?
Martin Huige
Hi Martin,
I faced some issues while installing TFS but the computer reboot fixed my installation and configuration issue.
I outlined the steps and my experience with TFS 2012 @ http://kishore1021.wordpress.com/2012/07/20/team-foundation-server-2012-rc-install-configure/
Regards,
这篇关于TFS 2012报告和分析服务的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
