getting an error when trying to browse a cube

getting an error when trying to browse a cube by Carbito

Closed

as Not Reproducible Help for as Not Reproducible

Type:	Bug
ID:	484146
Opened:	8/20/2009 8:18:31 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When I try to browse a cube in either Visual Studio 2008 or the SQL Management Studio, I get the following error: Error HRESULT E_FAIL has been returned from a call to a COM component.

Even before you do anything to get that error, the section which would normally say "Drop Totals or Detail Fields Here" instead has a message saying "The query could not be processed: o XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value."

The operating system that I'm running is Windows 7 RTM.

Details (expand)

English

SQL Server 2008 SP1

Analysis Services

Other

English

Load any analysis services project - the one used for the AdventureWorksDW2008 tutorial(s) will do. To reproduce the error you may need to change the system's langugage to English (Australia).

1. In the 'browser' tab of the cube designer, clicking on reconnect will give the error.
2. Within the browser tab, you can get a similar error by trying to drag items from the panel on the left side.

The versions that I'm running are:
Microsoft SQL Server Analysis Services Designer Version 10.0.2531.0
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
Windows Version 6.1.7600 Build 7600

When you click the 'reconnect' icon it gives the error of:

===================================
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 you attempt to drag elements from the panel on the left-hand of browser tab, you get the 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.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)

Ability to browse the cube.

X64

0 attachments

Posted by baruch.n on 4/20/2011 at 6:34 AM

The VS 2008 Browser fails on reconnect.

Not only this is reproducible but it does not go away...

Fiddling with the languages back and forth does not help (just messed up other things).

I can browse the cube on the same server using excel 2010.

System: win2003 64bit. Lang and location set to US but Hebrew is also enabled on the computer.

I can't understand why fix not published for a problem that is well known for over a year.
This is disrespect of Microsoft clients.

Posted by Microsoft on 3/15/2011 at 4:22 PM

We have been looking at the issue described. Since we will be changing the way you will be browsing the data in the next release this error should no longer exist.

Thanks again for your feedback
The Analysis Services team

Posted by EuroPhilC on 10/13/2010 at 10:42 AM

Same problem (on Win7), solved by the following MSDN post:

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/7cfe28e3-0724-4df6-81ef-643e18248096?prof=required

I take the liberty of including it here for those without MSDN access wasting hours trying to sort this ;-)

HTH, Phil

Hi,

I also had a same problem.
I solved it by changing the cube language to the one I'm using for windows.

Example:

Current Windows Language: English (United States)

From cube browser (VS) > Click "Cube" from menu bar > open "Language" then choose the exact same language (English (United States) in my case) as windows.

Posted by ppst2008 on 3/24/2010 at 9:01 AM

Hello,

I am running XP SP3 with Visual Studio 2008. I have all language settings set to "English" or "United States" in the Regional and Language Options tabs. I am still getting this exact error.

Are there any other solutions to try?

Thanks!

Posted by Vasant Shetty on 11/20/2009 at 2:46 AM

Thanks Carbito for the workaround. It helped.

VS

Posted by Microsoft on 8/26/2009 at 1:53 PM

Thank you for providing this feedback. We will investigate this issue for a future release of SQL Server. If this issue is blocking you now, please work with your Customer Support Specialist to file an RFC.

Posted by Carbito on 8/20/2009 at 8:27 PM

Found a workaround:

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. (previously mine was Australia)