1

Closed

BIDS Helper Corrupting BIM File

description

When creating display folders using the BIDS Helper, after saving and re-opening the project, the project fails to open with the error shown at the end of this post.

As per some comments on http://connect.microsoft.com/SQLServer/feedback/details/771871/tabular-model-opening-exception-after-sp1-installation I have found that if I view code on the bim file and then find and delete the following section, I can open the file and all is OK until I try to amend the display folders when the problem re-occurs.

This is a serious bug as it completely stops the use of what is otherwise an excellent tool.

Is there a fix?

<Annotation>
<Name>BIDS_Helper_Tabular_Display_Folder_Backups</Name>
<Value>
</Value>
</Annotation>

:

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)

Closed Jun 4, 2013 at 11:11 PM by dgosbell
The latest version of BIDSHelper has a fix for this see https://bidshelper.codeplex.com/wikipage?title=Tabular%20Annotation%20Workaround&referringTitle=Documentation.

Technically this is an SSDT bug. We are using supported APIs to create the annotations, but we've been able to alter the way we serialize them to be compatible with the bug in SSDT.

comments

dgosbell wrote Jun 4, 2013 at 11:16 PM

andrewsimmans wrote Jun 5, 2013 at 7:18 AM

Thanks for the fast response - I did search for the issue but could not find the solution. I had missed the extra menu item to apply the fix. Thanks and well done on a really useful utility!