Technical: Microsoft – SQL Server – v2008/R2 – Business Intelligence Studio – Cube Browsing – Error dragging measures\attributes to view pane

Background

When Browsing Cube, one of the errors one might encounter as you add measures and attributes to the pane is one that reads:


Retrieving the COM class factory for component with CLSID 
{C966837E-970C-4F4F-A91D-D81E21ABBBDB} failed due to the following error: 80040154. 
(Microsoft Visual Studio)

Full Error Message

Error Text


===================================

Retrieving the COM class factory for component with CLSID {C966837E-970C-4F4F-A91D-D81E21ABBBDB} failed due to the following error: 80040154. (Microsoft Visual Studio)

------------------------------
Program Location:

   at Microsoft.AnalysisServices.Controls.MiscUtilities.GetMixedDataObjectForFilterAndPivotTable(DataObject dataObjectForFilter, PivotTableDataObject pivotTableDataObject)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetDataObject(TreeNode node)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.OnItemDrag(ItemDragEventArgs e)
   at System.Windows.Forms.TreeView.TvnBeginDrag(MouseButtons buttons, NMTREEVIEW* nmtv)
   at System.Windows.Forms.TreeView.WmNotify(Message& m)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.WndProc(Message& msg)
   at Microsoft.AnalysisServices.Browse.CubeBrowser.CubeBrowserMetadataTreeView.WndProc(Message& msg)



Error Image

 

RetrievingTheComClassFactory

 

 

Resolution

There are correlating errors on the .Net and prominent fixes includes:

Repair / Install Microsoft Office 2003 Web Components

 

The OWC track did not work for us.

Inspect MS Windows registry

Searched the Windows registry for C966837E-970C-4F4F-A91D-D81E21ABBBDB and found the stub, but could not find CLASS (CLS) branch.

VSIntegrationNativeHelpers

 

 

Tried fiddling with MS Windows Registry

Tried fiddling with MS Windows Registry, but could not find good starting data on the Internet; note that data has to match SQL Server Version, etc.

Install latest Product patch

Downloaded and Installed MS SQL Server v2008/R2 SP2.

BTW, patch is available @ http://www.microsoft.com/en-us/download/details.aspx?id=30437

 

Possible Workaround

Registry Tweaking

BTW, if you want to try to tweak your registry and see if that might work and you avoid installing\re-installing a Service Pack, here is a working version:



Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{C966837E-970C-4f4f-A91D-D81E21ABBBDB}]
@="MarshalledToIStreamDataObject Class"
"AppID"="{B2463DC8-B3FA-4BEC-945E-60219DCC6FD8}"

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{C966837E-970C-4f4f-A91D-D81E21ABBBDB}\InprocServer32]
@="c:\\Program Files (x86)\\Microsoft SQL Server\\100\\Tools\\Bin\\Microsoft.DataWarehouse.VsIntegration.Helpers.dll"
"ThreadingModel"="Apartment"

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{C966837E-970C-4f4f-A91D-D81E21ABBBDB}\ProgID]
@="VsIntergrationNativeHelpers.Marshalle.2"

[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{C966837E-970C-4f4f-A91D-D81E21ABBBDB}\TypeLib]
@="{84F2933D-1F4E-43D8-9006-372E64998B36}"



Please keep in mind that the registry entry pasted above is for MS Windows 2008/R2 SP2. Other versions of SQL Server will invariable have version specific entries.

 

Listening To

Listening to Brett Eldredge – Raymond (Video) [http://www.youtube.com/watch?v=txCUwSKo1kg]

 

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s