错误 - Microsoft.AnalysisServices.ConnectionException：无法建立连接。确保服务器正在运行。 [英] ERROR - Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running.

问题描述

当我从前端通过桌面工具运行报告时，我收到错误消息。

此处我粘贴了错误消息。你能帮我解决一下这个问题。



2014-11-04 09：35：42,041错误 -

Microsoft.AnalysisServices .ConnectionException：无法建立连接。确保服务器正在运行。 ---> Microsoft.AnalysisServices.XmlaStreamException：无法打开'C：\ProgramData \EY Global Analytics \cubes\cubedefCNHI_SA_2014_09_30_8fc83c66_856f_4f41_a58f_09956383b8a9.cub'本地多维数据集文件。 ---> System.ComponentModel.Win32Exception：句柄无效

at Microsoft.AnalysisServices.LocalCubeStream..ctor（String cubeFile，OpenFlags settings，Int32 timeout，String password，String serverName）

---内部异常堆栈跟踪的结束---

在Microsoft.AnalysisServices.LocalCubeStream..ctor（String cubeFile，OpenFlags设置，Int32超时，字符串密码，字符串serverName）

at Microsoft.AnalysisServices.XmlaClient.Connect（ConnectionInfo connectionInfo，Boolean beginSession）

---内部异常堆栈跟踪结束---

在Microsoft。 AnalysisServices.XmlaClient.Connect（ConnectionInfo connectionInfo，Boolean beginSession）

at Microsoft.AnalysisServices.Server.Connect（String connectionString，String sessionId）

at EY.GlobalAnalytics.JEAnalysis。 BusinessObjects.LocalCubeController.GetOlapServer（）

在EY.GlobalAnalytics.JEAnalysis.Forms.Controllers.MdiChildren.ReportDa shboardPageController.InitMDAContext（String layoutId）

at System.Threading.ExecutionContext.runTryCode（Object userData）

at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup（TryCode code，CleanupCode） backoutCode，Object userData）

在System.Threading.ExecutionContext.Run（ExecutionContext executionContext，ContextCallback callback，Object state，Boolean ignoreSyncCtx）

at System.Threading.QueueUserWorkItemCallback.System .Threading.IThreadPoolWorkItem.ExecuteWorkItem（）

at System.Threading.ThreadPoolWorkQueue.Dispatch（）

at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback（）

I'm receive error message when I run the report from front-end through desktop tool.
Herewith I pasted the error message. Could you please help me how to fix this issue.

2014-11-04 09:35:42,041 ERROR -
Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> Microsoft.AnalysisServices.XmlaStreamException: The 'C:\ProgramData\EY Global Analytics\cubes\cubedefCNHI_SA_2014_09_30_8fc83c66_856f_4f41_a58f_09956383b8a9.cub' local cube file cannot be opened. ---> System.ComponentModel.Win32Exception: The handle is invalid
at Microsoft.AnalysisServices.LocalCubeStream..ctor(String cubeFile, OpenFlags settings, Int32 timeout, String password, String serverName)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.LocalCubeStream..ctor(String cubeFile, OpenFlags settings, Int32 timeout, String password, String serverName)
at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at EY.GlobalAnalytics.JEAnalysis.BusinessObjects.LocalCubeController.GetOlapServer()
at EY.GlobalAnalytics.JEAnalysis.Forms.Controllers.MdiChildren.ReportDashboardPageController.InitMDAContext(String layoutId)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

推荐答案

查看类似的主题： http：// www。 sqlservercentral.com/Forums/Topic736080-391-1.aspx [ ^ ]

Have a look at similar thread: http://www.sqlservercentral.com/Forums/Topic736080-391-1.aspx[^]

这篇关于错误 - Microsoft.AnalysisServices.ConnectionException：无法建立连接。确保服务器正在运行。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！