SSAS Tabular Model error opening

When opening an SSAS Tabular Model Visual Studio SSDT (SQL Server Data Tools), if for example you loose your network connectivity to the repository for a few seconds, then the SSAS Tabular Model don’t open.

Error: Can’t open the SSAS Tabular Model from Visual Studio SSDT.

Tabular Model Designer error: This model is already open in another location by the same user, please close the other project before working on this one.

The full error message is the following:

============================
Error Message:
This model is already open in another location by the same user, please close the other project before working on this one.
An error occurred while opening the model on the workspace database. Reason: This model is already open in another location by the same user, please close the other project before working on this one.
============================
Call Stack:
at Microsoft.AnalysisServices.VSHost.VSHostManager.HandleDatabaseValidation()
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)
============================

Solution:

Go to the project folder and delete the .settings file.

For example if the SSAS Tabular Model still have the default name : Model.bim then the settings file looks like this: Model.bim_YourUserName.settings

Be the first to comment

Leave a Reply