.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

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

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

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.GetPiv

View Complete Post

More Related Resource Links

error HRESULT E_FAIL has been returned from a call to a COM component

hello every one i see this error some times when i designed the page and close the program and came back.but this error do not stop debugging the page and hide all controls is my page and i cant use smart tag and see the controls.what should i do?

Exception: Error HRESULT E_FAIL has been returned from a call to a COM component.


I have two small programs that I wrote in C# that are basically just executing calls to cuteFTP Pro 8 (a scriptable FTP client). 

Program #1: needs to connect to a remote server using standard FTP protocol.  This program works fine whether I run it or schedule it through the Windows Task Scheduler (Server 2003 Standard). 

Program #2:  needs to connect to a remote server using FTPS_IMPLICIT or FTPS, I've tried using either of these two protocols and the same result is produced.

If I run Program #2 on my user account while logged in to the server it works correctly, however if I schedule it through Windows Task Scheduler (in exactly the same fashion as Program #1) I get the COM error that I put in the thread title.  A stack trace shows that it happens


at ftpteLib.TEConnectionClass.Connect()

which is one of the cuteFTP methods.  For the sake of isolating the problem I removed most of the functional code in Program#1 and Program #2 so taht they are identical other than the fact that one connects to a remote server needing FTP and the other to one needing FTPS or FTPS_IMPLICIT.

Is there anything I can do to correct this?

Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET F

I downloaded the the .Net Framework 3.5 from Microsoft and I am trying to install the .Net Framework 3.5 in a clean Windows Vista Ultimate installation but it fails. The dd_dotnetfx35error file shows:   [03/08/08,19:05:35] Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET Framework 2.0SP1 (CBS). MSI returned error code 1[03/08/08,19:05:46] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0SP1 (CBS) is not installed. Thank you for your help.

Error HRESULT E_Fail



I created a simple page calling the DateTime.Now.ToString on a page ran the page it came up eventually but then when I went back to my .net page there is an error:

Error Creating Control - Label1

Error HRESULT E_FAIL has been returned from a call to a COM component.

If I try to run the page again I get there is no problem but the error on the default.aspx page in design view still exists.

Microsoft JScript Runtime Error-Cannot Call Response .Write


i am simply doing a searching of records on button click if record found it will be display in gridview pther wise  it will print me a message no value found

but everytime when it execute my Else Block it always throws me this script error how i can resolve it

Currently Using Ajax Update Panel Script Manager C#

my Html

                    <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                <asp:GridView ID="GridView1" runat="server" Width="385px">
                <asp:AsyncPostBackTrigger ControlID="Button1" EventName="Click" />
        </asp:UpdatePanel> </td>

My Code Behind

protected void Button1_Clic

Error: Cannot call methods on int (Microsoft SQL server, error: 258


I have written this SQL query in query designer in Report Builder

When I run it I appear to be getting the following message:

Cannot call methods on int (Microsoft SQL server, error: 258). Does anyone know why I am getting this. In theory this query should work.


AccountsContacts.ContactID AS [AccountsContacts ContactID]









,Enquiries.ContactID AS [Enquiries ContactID]




inner JOIN Enquiries ON Enquiries.ContactID = AccountsContacts.ContactID


Enquiries.EnquiryID = @Enquiries.EnquiryID

Generation of designer file failed: Error HRESULT E_FAIL


started getting error

Warning 1 Generation of designer file failed: Error HRESULT E_FAIL has been returned from a call to a COM component. 

i am not even able to see the designer file 

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Syntax error


Hi there.

I have been sitting hours and hours trying to solved this issue with absolutely no luck.

I have the following query:

Code Snippet

DECLARE @sqlScript1 VARCHAR(8000)

-- Import records fron source file (OPENROWSET)

SET @sqlScript1 = 'SELECT * INTO ##tmpOrders FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'' ,

''Excel 8.0;Database=' + @fileName + ''', ''SELECT [Sale Time] AS SaleTime, Ref, [Item Title] AS ItemTitle, [Item Type] AS ItemType, [Item Id] AS ItemId,


Training Question - Connection Refused Error in Browsing A Cube In SSAS


I am an instructor for a data warehouse design and implementation course at a local college, and I have run into a problem that I have not been able to fix.  Hopefully someone out there can help.  It is the first time this course is being taught in a new lab where we are running SQLExpress 2008 Developer Edition, with a local server instance installed on each workstation, using Windows authentication; this configuration was done by our local LAN/network manager.  We have created a Management Studio source database and a Management Studio warehouse database, using a star schema design.  We have successfully created SSIS packages to extract from the source tables and populate the warehouse tables.  We have been able to create a DSV in SSAS.  When we attempt to process and browse the cube, it fails with a connection refused error from the server.  Configuration Manager tells me the SSAS server process is running.  The data connection works when checked.  We get the same error regardless of which impersonation option is selected. What have I missed?  Can the configuration be adjusted to get around this?  I have spent several hours trying everything I could think of, with no success - it is getting frustrating.

Please advise.  Thanks in advance.

Error Registering COM+ Component

Hi All,

I am experimenting with using EnterpriseServices. I created a component, created the SNK file, compiled the DLL. In the assemblyinfo.vb file, I added '<Assembly: AssemblyKeyFile("c:\key.snk")> '.
I created a new package in COM+, When I attempt to add the .dll to the package i get:

An error occured while processeing the last operation.
Error Code 80020009 - Exception ocurred.

The eventlog may contain additional troubleshooting information.

Here is the Event log:

Installation of 'TransactionalComponentsCore.dll' into '{6367F5F1-56A7-4223-97AC-51F7DC1D53EB}' failed with an exception:

System.EnterpriseServices.RegistrationException: Could not install type library 'TransactionalComponentsCore.tlb' into application 'TransactionalComponentsCore'.

Server stack trace:
at System.EnterpriseServices.RegistrationDriver.InstallTypeLibrary_W2K(ApplicationSpec spec)
at System.EnterpriseServices.RegistrationDriver.InstallTypeLibrary(ApplicationSpec spec)
at System.EnterpriseServices.RegistrationDriver.InstallAssembly(RegistrationConfig regConfig, Object obSync)
at System.EnterpriseServices.RegistrationHelperTx.InstallAssemblyFromConfig(RegistrationConfig& regConfig, Object sync)
at Sys

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

Linq2Sql error: "Invalid attempt to call Read when reader is closed."


I've read up on this error from other posts and on other sites, but haven't found a solid resolution to the issue yet. My setup is as follows:

I have a RepositoryBase class that fields certain db calls that all repositories need to perform. In one such call, "GetSecurityGroup", it works most of the time, but will seemingly at random throw an exception with the error "Invalid attempt to call Read when reader is closed." All other Repository classes inherit from this one, and they all use the same DataContext object, which I understand isn't thread safe. Since there could be multiple calls to the DataContext object on the same page, perhaps one is using the DataContext when the next tries to do so. I'm not sure. What can I do to ensure this doesn't happen?

Microsoft JScript runtime error: 'Parent' is null or not an object


Hi friends,

        I got This Error : Microsoft JScript runtime error: 'Parent' is null or not an object

 In runtime,after  click on the check box, It Show "Microsoft JScript runtime error: 'Parent' is null or not an object"

<script language ="javascript" type ="text/javascript" >
        function SelectAllCheckboxesSpecific(spanChk)
           var IsChecked = spanChk.checked;
           var items=0;
           var Chk = spanChk;
              Parent = document.getElementById('gvUsers');          
              var items = Parent.getElementsByTagName('input');                         
              for(var i=0;i<items.length;i++)
                  if(items[i].id != Chk && items[i].type=="checkbox")
                      if(items[i].checked!= IsChecked)

please verify it. 

The remote server returned an error: (405) Method Not Allowed.



{System.Net.WebException: The remote server returned an error: (405) Method Not Allowed.
   at System.Net.WebClient.UploadFile(Uri address, String method, String fileName)
   at System.Net.WebClient.UploadFile(Uri address, String fileName)
   at System.Net.WebClient.UploadFile(String address, String fileName)
   at Test.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\WebSite1\Test.aspx.cs:line 35}

Windows application, automated process will run on local user system...
trying to upload a file to website folder. website address:

System.Net.WebClient wc = new WebClient();
wc.UploadFile(website address, "c:/1.pdf");

Getting error from above line.. Am doing something wrong??
I dont want to use ftp or share folder logic..
is there any other way to upload the files to server??

Microsoft .NET Framework Error

I just purchased a Compaq Presario CQ62 and already its says that Microsoft .NET Framework 2.0 is required to continue and this it gives a website to download the framework. Yet, I go to the website, download it, and once installation starts, it says that its alrdy installed. I cant find where to uninstall the software. I dont want to delete the incorrect thing and mess up my new computer! I have downloaded the x64 version.

Microsoft.ApplicationBlocks.Updater.Downloaders 64 bit error

Hello, I have a application that uses applicationblocks updater.  It works great on 32-bit machines, but when a 64-bit machines uses it I get the following error: Exception Source:      Microsoft.ApplicationBlocks.Updater.Downloaders Exception Type:        System.TypeLoadException Exception Message:     Could not load type 'Microsoft.ApplicationBlocks.Updater.Downloaders.BG_BASIC_CREDENTIALS' from assembly 'Microsoft.ApplicationBlocks.Updater.Downloaders, Version=, Culture=neutral, PublicKeyToken=null' because it contains an object field at offset 4 that is incorrectly aligned or overlapped by a non-object field. Exception Target Site: SetBackgroundJobCredentials ---- Stack Trace ----    Microsoft.ApplicationBlocks.Updater.Downloader.DownloadManager.SubmitTask(task As UpdaterTask, maxWaitTime As TimeSpan)    Microsoft.ApplicationBlocks.Updater.ApplicationUpdaterManager.Download(selectedManifests As Manifest[], maxWaitTime As TimeSpan) I used reflection to check out the BG_BASIC_CREDENTIALS class and it looks like this: <StructLayout (LayoutKind .Explicit , Size :=&H10 , Pack :=4 )> _ Friend Structure BG_AUTH_CREDENTIALS ' Fields <FieldOffset (8 )> _ Public Credentials As BG_AUTH_CREDENTIALS_UNION <FieldOffset (4 )> _ Pu

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend