Tabular Annotation Workaround

After upgrading to SQL Server 2012 SP1 SSDT, some users have complained about receiving an error that prevents them from opening the .bim file in a Tabular model:

Error Message:

An error occurred while opening the model on the workspace database. Reason: ReadElementContentAs() methods cannot be called on an element that has child elements.

Call Stack:

 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)


This problem is a bug in SSDT in that it does not properly parse annotations created by BIDS Helper, and it has been reported to Microsoft here. If you are experiencing this issue, please vote for it on Connect to raise its visibility. Until Microsoft fixes the problem, the BIDS Helper team has created a workaround utility which changes the storage format for BIDS Helper annotations. BIDS Helper release 1.6.2 includes this workaround feature.

If you are experiencing this ReadElementContentAs() error, then consider using this BIDS Helper workaround utility. With the .bim file closed, right click on the .bim file and select Tabular Annotation Workaround...


This feature will popup a confirmation dialog. Read it carefully, especially the note about every developer on your team upgrading to the latest version of BIDS Helper.


Last edited Feb 27, 2013 at 2:58 AM by furmangg, version 5