自定义报告 rsProcessingaborted 错误
我已经部署了 CRM 并使用 rollup2 在 SSRS 服务器上成功安装了报告扩展组件（服务器和路由器与此匹配） - 我有单独的 CRM、SQL 和 SSRS 服务器。开箱即用的报告工作正常，但自定义报告显示错误“rsProcessingAborted”，对我来说这听起来像是权限。我读过许多与有同样问题的人相关的文章，并尝试了所有可能的修复方法，但仍然没有喜悦。 SSRS在svc_sqlserver帐户下运行，并且该帐户具有数据库权限 数据源均已成功创建，并且自定义报告正在使用 MSCRM_FetchDataSource，该数据源使用 Dynamics CRM Fetch 类型和运行报告的用户提供的凭据进行配置。连接字符串显示 CustomerServicesCE，这是正确的 OrgsanizationID（在开发人员资源中找到） - 我尝试清除此连接字符串，添加服务器 url，所有可能的组合都没有乐趣。
在 SSRS 中，我无法查看该报告，它说“无法访问 CRM 数据源” - 我在某处读到，您需要输入 GUID systemuserid 和organizationid 作为用户名和密码，但仍然不高兴。
我尝试修改一份报告以使用与开箱即用的报告相同的数据源，但仍然没有任何乐趣，即 MSCRM_DataSource......我错过了什么吗？
这些报告来自另一家供应商 - 我不介意它们如何显示（获取或其他方式），我只需要它们工作！ 有趣的是，我确实让他们在我的开发环境中工作（在出现相同的错误之后），并且在我看来，设置看起来是相同的！
感谢您的帮助 理查德
I have deployed CRM and installed the reporting extensions component successfully on the SSRS server with rollup2 (server and router match this) - I have separate servers for CRM , SQL and SSRS. The out the box reports work ok but the custom reports present an error "rsProcessingAborted" which to me sounds like permissions. I have read a number of articles relating to pepople with the same issue and have tried all possible fixes but still no joy.
SSRS runs under a svc_sqlserver acccount and this account has permissions in the DB
the datasources have all been created successfully and the custom reports are using the MSCRM_FetchDataSource which is configured with type Dynamics CRM Fetch and credentials supplied by the user running the report. The connection string says CustomerServicesCE which is the correct OrgsanisationID (as found within developer resources) - i have tried clearing this connection string, adding the server url, all possible combinations with no joy.
Within SSRS i cannot view the report, it says "cannot access the CRM datasource" - i read somewhere you need to enter the GUIDs systemuserid and organisationid as username and pwd but still no joy.
I tried amending one report to use the samedatasource as the out the box reports that work but still no joy which is the MSCRM_DataSource...................am i missing something?
These reports have come from another supplier - i don't mind how they are displayed (Fetch or otherwise) i just need them working!
interestingly i do get them working on my Development environment (after getting the same error) and to my eyes the setup looks identical!
thanks for any help
richard
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
答案是创建一个 spn 作为
setspn -a http/crmservername 域\accountCRMrunsunderrIIS
the answer was to create an spn as
setspn -a http/crmservername domain\accountCRMrunsunderrIIS