Browsing a cube: Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)

Question

When I try to reconnect using the cube browser (in both Visual Studio and SQL Management Studio) I get the following error:

===================================
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
------------------------------
Program Location:
   at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.TranslatePivotTable()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdatePivotTable(Boolean translate)
   at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
   at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

And when I try to drag stuff from the measure group (the left panel) I get:

===================================
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
------------------------------
Program Location:
   at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.get_FieldSetsEnumerator()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.GetFieldSet(String uniqueName)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject)
   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)

Does anyone have any idea what's going on here and how I could fix it?!?

I'm running SQL Server 2008 SP1 on Windows 7 RTM.

Answer 1

In case anyone comes across this post in the future, I have found a workaround for this in another thread:

1. Go to Control Panel -> Clock, Language, and Region -> Change location
2. Change your location in the format tab to English (United States) and in the location tab change to United States.

For some reason, it doesn't seem to work with non-US languages like English (Australia)

Answer 2

I tried this solution and It didn't work for me. Any other ideas?

---

Alberto

Answer 3

This work around resolved a similar issue for me perfectly.
I had been attempting to explore an SSAS cube using the Business Intelligence Design Studio for SQL Server 2008 with Windows 7 Home Premium (64 bit) as my O/S. I had been encountering a similar message when attempting to drag Measures etc. into Cube's Browser tab.

Thanks for your help!

Answer 4

Well I found the solution, When you are browsing the cube, you should choose the correct language and will not problems. (The correct language is the lenguaje that was configurated in your system). In my case, it was in "Default", and I choose Spanish(Peru) instead of Default, and NOT MORE PROBLEMS IN BROWSER.

I'am peruvian, so my answer in spanish is:

En la pestaña "Examinador" del cubo, abajo debemos elegir el idioma correcto. En mi computadora era Español(Peru), entonces, mi solucion fue escoger ese idioma (Español(Peru)) para que coincida y sea igual a lo configurado en mi computadora.

Hecho esto, ya no tengo problemas en el examinador (browser).

Answer 5

Worked for me - I had exactly the same issue on Windows 7. It was enough to change the laguage. Didn't have to change location.

Thanks again.

Answer 6

It worked for Me. ( windows 7, laguage only BIDS/VS 2008)

however as all the rest of my work needs to be in UK format, if anyone can solve this with the UK settings I would be please to know.

 

Thanks

 

Answer 7

Thanks Carbito

I have fix this on the SSAS server by setting to UK.

this looks a bit heavy ( at server level)

better if

1 we could set at DB level

2 we could set against account

3 it was fixed so it was only a display issue not a crash message.

 

 

Answer 8

It worked for me too. It looks like a bug in Visual Studio and is a potential candidate for KB. What you guys think ?

Answer 9

I am working with visual studio 2008, and i fixed it by changing the language setting to English UK on the Cube Structure tab, you don't have to to change any Control Panel settings.

Answer 10

This is right.

Select the language on Cube structure tab  to any language other than Default and it works .

Click the 'reconnect' toolbar icon if it still dosen't works.

Answer 11

Fine, this works!

Answer 12

In case anyone comes across this post in the future, I have found a workaround for this in another thread:

1. Go to Control Panel -> Clock, Language, and Region -> Change location
2. Change your location in the format tab to English (United States) and in the location tab change to United States.

For some reason, it doesn't seem to work with non-US languages like English (Australia)

Thanks, a lot!

Here is a picture where you should change settings. I changed from default to Swedish, and like everybody says here it solved the problem.

 

Answer 13

Thanks Alot!!!!!

It worked for me.

Answer 14

Funcionooooooo ya me estaba preocupando.Mil gracias

Answer 15

Thanks,

I have the same issue, fixed with your solution,

Its working, very helpful for me..

Answer 16

You can just change the language in the Browser tab from Default to match the one that you have in the system Control Panel and it works. 

Answer 17

The work around was very helpful...thanks!

Answer 18

Thanks Carbito.... I am facing this problem but upon your answer its works properly.. thank you very much.... :)

Answer 19

It worked for me.

Thanks

Answer 20

For a more permanent solution

In Visual Studio

Tools --> Options --> Environment --> International Settings

Set language to 'Same as Microsoft Windows'