I was dragging and dropping Measures from the Metadata pane to the Data pane
when this broke with the following message in teh Data pane:

The query could not be processed:
o Errors in the OLE DB provider. Could not connect to the redirector. Ensure
that the SQLBrowser service is running on the 'a-genehdt2' server.
o Errors in the OLE DB provider. An error occurred while named instance
information was being retrieved from the SQLBrowser service on the
'a-genehdt2' server.

I found SQLBrowser to be running so I tried to restart it but it would not
restart.

I closed all programs and restarted my machine.

When I tried to browse the cube I found the same error message as above in
the Data pane.

I tried to drag and drop a measure from the Metadata pane and received 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.PivotAxis.get_Field Sets()
at
Microsoft.AnalysisServices.Controls.PivotTableCont rol.ClearAxisFromFieldSets(PivotAxis axis)
at
Microsoft.AnalysisServices.Controls.PivotTableCont rol.OnMenuClearEverything(MenuCommand menuCommandSender, CommandHandlingArgs args)
at
Microsoft.DataWarehouse.Design.CommandHandlingInfo Map.HandleCommand(MenuCommand menuCommand)
at
Microsoft.AnalysisServices.Controls.PivotTableCont rol.Microsoft.DataWarehouse.Interfaces.ICommandTar get.InvokeCommand(MenuCommand menuCommand)
at
Microsoft.AnalysisServices.Browse.CubeBrowser.Brow serStateSwitchManager.ConnectedAndActiveStateComma ndTarget.InvokeCommand(MenuCommand menuCommand)
at
Microsoft.AnalysisServices.Browse.CubeBrowser.Micr osoft.DataWarehouse.Interfaces.ICommandTarget.Invo keCommand(MenuCommand menuCommand)

Is there anyway of cleaning this up without dropping and re-creating the
cube???
--
Thanks in advance
GH

Hello,

This issue seems to be caused by OLEDB provider. I suggest that you
register msolap90.dll to test the situation. If the issue persists, please
reinstall ODEDB for AS 9.

http://www.microsoft.com/downloads/d...d60-a13c-4479-
9b91-9e8b9d835cdc&DisplayLang=en

You may want to check if the project works properly with BI dev studio
installed to isolate the problem. Does the issue only occur with this cube?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

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

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/tec...rview/40010469

Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...rnational.aspx.

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

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

I could not eaisly determine how register msolap90.dll so I re-installed.

Now everything works ..

Thanks
GH


"Peter Yang [MSFT]" wrote:

Welcome!

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

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



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------