SQL Server 代理运行时 Analysis Services 处理任务失败
我有一个 SSIS 包，其中包含 Analysis Services 处理任务。 该包由 SQL Server 2008 R2 中的 SQL Server 作业启动。
如果我自己运行此作业或手动处理多维数据集，一切都很好。
但是，如果我计划该作业并让 SQL Server 代理运行它，则 Analysis Services 处理任务将失败，并指出 OLAP 存储引擎中出现错误，并且在处理度量值组之一时发生错误。
还有其他人见过这样的事情吗？
I have an SSIS package which contains an Analysis Services Processing Task.
This package is kicked off by a SQL Server Job in SQL Server 2008 R2.
If I run this job myself or process the cube manually everything is fine.
However if I schedule the job and let the SQL server agent run it then the Analysis Services Processing task fails stating Errors in the OLAP storage engine and that an error occurred while processing the one of the measure groups.
Has anyone else every seen anything like this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
SQL Server 代理服务帐户可能没有足够的权限。您可以通过执行以下任一操作来验证此问题：
如果在进行上述任何更改后作业成功完成，则您有需要解决的权限问题。
The SQL Server Agent service account may not have sufficient permissions. You can validate this by doing any of the following:
If the job completes successfully after making any of the above changes, then you have a permission issue that you need to resolve.
经过几个月的研究，我终于找到了答案；当然这是一个简单的。
我创建的 SSIS 作业仅处理多维数据集，而每次我在 Management Studio 中手动处理时，我都在处理整个 SSAS 数据库。
我现在已经更改了 SSIS 包来处理整个数据库，并且一切似乎都工作正常。
So after months of looking at this I finally realised the answer; of course it's a simple one.
The SSIS job I had created was processing the Cube only, while every time I processed manually in management studio I was processing the whole SSAS database.
I've now changed the SSIS package to process the whole database and everything seems to be working correctly.
当此错误生成时：
报告服务目录数据库文件存在失败 sql server 2008 r2
========================================= =============================================
出现此问题的原因是 SQL 数据库您要安装的 Server 2008 Reporting Services 实例已存在于具有以下路径的计算机上。
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
从上述路径中手动删除报表的 .MDF 和 .LDF 文件，然后重新运行安装程序。
when This Error Generate :
reporting services catalog database file existence failed sql server 2008 r2
================================================================================
This issue occurs because the databases for the SQL Server 2008 Reporting Services instance that you want to install already exist on the computer with following path.
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
Manually Remove .MDF and .LDF files of Report from above path and Re-run Setup.
就我而言，我以其他方式找到了解决方案。首先，我使用 SQL Management Studio 登录 Analysus 服务。其次，我在数据库文件夹中搜索了我的项目名称，打开该文件夹后，在 Roles 文件夹中双击，在新角色中单击，在此窗口中我选择了 Membership在左侧窗格中，单击“添加”按钮并搜索 NT AUTHORITY\Service，单击“确定”按钮，最后重新启动 Sql 分析服务。我尝试运行我的工作并且它有效。
In my case I found the solution in other way. First of all I login into analysus services using SQL management studio.Second of all I searched into databases folder the name of my project, after I open that and double clic in Roles folder, clic in new role, in this window I selected Membership in the left pane, clic in add button and search the NT AUTHORITY\Service, clic in Ok button and finally restart Sql analysis services. I tried to run my job and It works.
