SSAS表格问题。我无法打开表格。 [英] Problems with SSAS Tabular. I cannot open the tabular.
问题描述
大家好。
我尝试在Visual Studio 2010-2013中打开表格文件（.bim）时遇到问题。它包含周围 136张桌子和145个messeaures。 有时表格打开，有时不打开。 VS检测到的问题是ram内存不是
足够但是我试图打开带有8 GB，6GB和4GB的differentes cpus的文件，它也不起作用。
也许有人面临类似的问题，你可以帮助我！
错误：
操作已被取消，因为没有足够的可用内存供应用程序使用。如果使用32位版本的产品，请考虑升级到64位版本或增加计算机上可用的内存量。
----------------------------
打开模型时出错。单击详细信息以获取更多信息。
====================== ======
调用堆栈：
===================== =======
在Microsoft.AnalysisServices.BackEnd.DataModelingServer.ExcecuteXMLA（String bismContent，String databaseName，Boolean isAlter）
在Microsoft.AnalysisServices.BackEnd.DataModelingServer.ExecuteXMLAFromFile（String bismFileName，String databaseName）
在Microsoft.AnalysisServices.VSHost.VSHostManager.HandleExistingProject（Boolean isImported，Boolean& isRefreshNeeded）
在Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox（Boolean newProject，Boolean& isRefreshNeeded，Boolean& isImpersonationChanged，Boolean& saveRequired，List`1& truncatedTables，Boolean isRealTimeMode，
Int32 clientCompatibilityLevel）
----------------------------
在Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox（Boolean newProject，Boolean& isRefreshNeeded，Boolean& isImpersonationChanged，Boolean& saveRequired，List`1& truncatedTables，Boolean isRealTimeMode，
Int32 clientCompatibilityLevel）
  在Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance（UInt32 grfCreateDoc，String pszMkDocument，String pszPhysicalView，IVsHierarchy pvHier，UInt32 itemid，IntPtr punkDocDataExisting，IntPtr&
ppunkDocView，IntPtr& ppunkDocData，String& pbstrEditorCaption，Guid& pguidCmdUI ，Int32& pgrfCDW）
============================
< p style ="margin：0cm 0cm 0.0001pt; font-size：11pt; font-family：Calibri，sans-serif; color：＃333333">
谢谢。
嗨alemica，
将Visual Studio 2017与
Analysis Services项目一起使用时，是否会重现此问题VSIX ？由于visual studio是一个32位进程（对应用程序的内存限制约为3GB），这可能就是为什么移动到具有更多内存的不同机器并不会改变行为。
Hello everyone.
I have a problem when i tried to open a tabular file (.bim) in Visual Studio 2010-2013. It contains around 136 tables and 145 messeaures. Sometimes the tabular opens and sometimes not. The issue that VS detected is that the ram memory is not enough but i tried to open the file with differentes cpus with 8 GB, 6GB and 4GB and it not works either.
Maybe someone faces with a similar issue and you can help me!
Error:
The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.
----------------------------
An error occurred while opening the model. Click Details for more information.
============================
Call Stack:
============================
at Microsoft.AnalysisServices.BackEnd.DataModelingServer.ExcecuteXMLA(String bismContent, String databaseName, Boolean isAlter)
at Microsoft.AnalysisServices.BackEnd.DataModelingServer.ExecuteXMLAFromFile(String bismFileName, String databaseName)
at Microsoft.AnalysisServices.VSHost.VSHostManager.HandleExistingProject(Boolean isImported, Boolean& isRefreshNeeded)
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged, Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
----------------------------
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged, Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
at Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance(UInt32 grfCreateDoc, String pszMkDocument, String pszPhysicalView, IVsHierarchy pvHier, UInt32 itemid, IntPtr punkDocDataExisting, IntPtr& ppunkDocView, IntPtr& ppunkDocData, String& pbstrEditorCaption, Guid& pguidCmdUI, Int32& pgrfCDW)
============================
Thanks.
Hi alemica,
Does the issue get reproduced when you use Visual Studio 2017 with the Analysis Services Projects VSIX? Since visual studio is a 32 bit process (~3gb memory limit on an application), this might be why moving to a different machine with more memory isn't changing the behavior.
这篇关于SSAS表格问题。我无法打开表格。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
