locked
Error HRESULT E_FAIL has been returned from a call to a COM component RRS feed

  • Question

  • I am writing programming with Asp.Net and use the TransactionScope Class for doing transaction purpose. I have faced problem using this .Net Framework Class (TransactionScope Class).  Since TransactionScope Class uses MSDTC, I believe that the problem is related to the Network Configuration. If I use the Database and Application in one computer, I will not face any problems but if I use the Database on a Server and I run the application from another computer to access the Database, I will face problems regarding the transaction.

    The Error Message is:

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

     

    I hope you can help me in this problem.

     

    Configuration on Windows 2003 Server where Database is on this computer and Winows Vista where the application is on this computer:

    Firewall is Off in Both Computer

    The MSDTC services are ON in both the computers (Server and Vista)

    The check boxes checked in MSDTC "Use local Co-ordinator" in both Computers (Server and Vista).

    All check boxes are ON in Security Configuration in both Computers:

    1. Network DTC access

    2. Allow remote clients

    3. Allow remote administration

    4. Allow inbound

    5. Allow outbound

    6. Mutual authentication require (with No Authentication or Incoming caller Authentication also is not working)

    7.  Enable XA transactions.

    8. Enable TIP transaction (This Feature is not Available in Vista and it is only in Server)

    The result of DTCPing from the Vista Computer (PC-OMID) to the Server (RISKKDEV) is as following:

    IP Configure Information

                    Host Name . . . . . . . . . : Omid-PC

                    DNS Servers . . . . . . . . : 192.168.0.2

                    Node Type . . . . . . . . . : Mixed

                    NetBIOS Scope ID. . . . . . :

                    IP Routing Enabled. . . . . : no

                    WINS Proxy Enabled. . . . . : no

                    NetBIOS Resolution Uses DNS : no

     

    Ethernet adapter {828C93A4-9B21-4FC3-8D78-9D2338D8018F}:

     

                    Description . . . . . . . . : Realtek RTL8168D/8111D Family PCI-E GBE NIC

                    Physical Address. . . . . . : 00-24-E8-AE-DD-86

                    DHCP Enabled. . . . . . . . : yes

                    IP Address. . . . . . . . . : 192.168.0.30

                    Subnet Mask . . . . . . . . : 255.255.255.0

                    Default Gateway . . . . . . : 192.168.0.2

                    DHCP Server . . . . . . . . : 192.168.0.1

                    Primary WINS Server . . . . :

                    Secondary WINS Server . . . :

                    Lease Obtained. . . . . . . : Mon Jul 13 04:47:22 2009

                    Lease Expires . . . . . . . : Thu Jul 23 07:47:22 2009

     

    Ethernet adapter {DA49D38D-7E7D-41C0-A05F-3E1124871228}:

     

                    Description . . . . . . . . : Bluetooth Device (Personal Area Network)

                    Physical Address. . . . . . : 00-24-2C-AE-B9-8C

                    DHCP Enabled. . . . . . . . : yes

                    IP Address. . . . . . . . . : 0.0.0.0

                    Subnet Mask . . . . . . . . : 0.0.0.0

                    Default Gateway . . . . . . : 0.0.0.0

                    DHCP Server . . . . . . . . :

                    Primary WINS Server . . . . :

                    Secondary WINS Server . . . :

                    Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970

                    Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970

     

    ++++++++++++lmhosts.sam++++++++++++

     

    ++++++++++++hosts      ++++++++++++

    127.0.0.1       localhost

    ::1             localhost

     

    07-13, 17:02:51.284-->Error(0x424) at clutil.cpp @256

    07-13, 17:02:51.287-->-->OpenCluster

    07-13, 17:02:51.289-->-->1060(The specified service does not exist as an installed service.)

    ++++++++++++++++++++++++++++++++++++++++++++++

         DTCping 1.9 Report for OMID-PC 

    ++++++++++++++++++++++++++++++++++++++++++++++

    Incorrect Entry: Software\Microsoft\Rpc\Internet

    RPC server is ready

    remote host name can only be NetBIOS name

    ++++++++++++Validating Remote Computer Name++++++++++++

    07-13, 17:03:26.607-->Start DTC connection test

    Name Resolution:

                    RiskkDev-->192.168.0.3-->RISKKDEV

    07-13, 17:03:28.762-->Start RPC test (OMID-PC-->RiskkDev)

    Problem:fail to invoke remote RPC method

    Error(0x6D9) at dtcping.cpp @303

    -->RPC pinging exception

    -->1753(There are no more endpoints available from the endpoint mapper.)

    RPC test failed

    Sunday, July 19, 2009 10:39 AM

Answers

  • Dear Srini

    This approach also did not work..... I think the problem must be at Server side rather than client side....

    Anyway Thanks.
    Wednesday, September 23, 2009 3:14 AM

All replies

  • What architecture is your Vista machine? I believe there are known issues running DTC Ping 1.9 on 64 bit Vista/Win2k8 boxes.

    Also, what are you specifying for the remote host name? The "Remote host name can only be NetBIOS name" error would indicate that you might be specifying the fully qualified domain name or something else. Please retry with just the NetBIOS name of RISKKDEV.

    Thanks,
    -Clark


    SDET (Transactions Team)
    Tuesday, July 28, 2009 2:24 AM
    Moderator
  • Dear Clark

    Thank you for replying.

    my vista is 32 bit. but I was wondering how it cab be possible that one of computer in network which has vista operating system, do the transaction with the server without any problem. I have checked the configuration of both computer for transaction and the configurations are the same. Consequently I can conclude that maybe some setting in my computer is missing, but really I can not find it since this problem (Failing in Transaction) has happend almost for other three computers which I have tested except one.

    Thanks  
    Wednesday, July 29, 2009 2:58 AM
  • Dear Clark

    Thank you for replying.

    my vista is 32 bit. but I was wondering how it cab be possible that one of computer in network which has vista operating system, do the transaction with the server without any problem. I have checked the configuration of both computer for transaction and the configurations are the same. Consequently I can conclude that maybe some setting in my computer is missing, but really I can not find it since this problem (Failing in Transaction) has happend almost for other three computers which I have tested except one.

    Thanks  
    Wednesday, July 29, 2009 3:00 AM
  • Do you have any keys/values under this registry node HKEY_LOCAL_MACHINE\Software\Microsoft\Rpc\Internet\ on the server machine?

    -Clark
    SDET (Transactions Team)
    Thursday, July 30, 2009 11:47 PM
    Moderator
  • Dear Clark

    There is not any Internet Folder Under RPC.

    Thank You for your response.

    Waiting for your advice.
    Tuesday, August 4, 2009 4:56 AM
  • DTC authentication might fail if clocks are out of sync. Could you please verify if the clocks are in sync?

    Thanks.
    Wednesday, September 9, 2009 12:22 AM
    Moderator
  • Dear UmeshMR

    Can you tell me more about Clocks? is it Windows Clocks?

    Thanks
    Wednesday, September 9, 2009 3:16 AM
  • If you are in a domain, sync the time of the machines involved with that of the Domain controller by executing command

    'net time' on a command prompt.

    Let me know if this helps.

    Thanks.

    • Proposed as answer by UmeshMRModerator Wednesday, September 9, 2009 5:25 PM
    • Marked as answer by UmeshMRModerator Friday, September 11, 2009 5:35 PM
    • Unmarked as answer by Learner.Net4 Monday, September 14, 2009 10:30 AM
    • Unproposed as answer by Learner.Net4 Monday, September 14, 2009 10:40 AM
    Wednesday, September 9, 2009 5:25 PM
    Moderator
  • Dear UmeshMR

    sorry for delay, There are two servers; one is domain controller and another is holding Database. Both of then have been synchronized by NET TIME \\Servername /SET /YES, as you mentioned, but still the problem exist. 

    I tried to Install Windows server 2008(workgroup) with Sql Server 2008, and transaction works very well..

    Thank you.
    Monday, September 14, 2009 10:39 AM
  • Do you still have the issue? If yes can you try the below things. I think, the registry/security settings are changed(on PC-OMID) as it works fine on other machines. Can you also, confirm if both machines are under same domain.

    Go to the command line and run: MSDTC -uninstall
    Go to the registry and delete the MSDTC keys in HKLM/Software/Microsoft/Software/MSDTC, HKLM/System/CurrentControlSet/Services/MSDTC, and HKEY_CLASSES_ROOT\CID (if they're still there).
    Reboot
    Go to the command line and run: MSDTC -install
    Go to the command line and run: net start msdtc

    Also, as you don't have internet folder for RPC it could be related to a firewall issue. Below link has some information.
    http://support.microsoft.com/default.aspx/kb/306843

    Thanks,
    Srini

    Wednesday, September 16, 2009 12:22 AM
    Moderator
  • Dear Srini

    This approach also did not work..... I think the problem must be at Server side rather than client side....

    Anyway Thanks.
    Wednesday, September 23, 2009 3:14 AM
  • Hi,

    yesterday I had the same problem with MS DTC on SQL Server 2008 for distributed transaction:

    -->1753(There are no more endpoints available from the endpoint mapper.)

    After many tests, I fixed it to set to True the RemoteProcTransEnabled property in SQL Server 2008 Configuration Facet on both server.

    Example (T-SQL):

    exec sp_configure 'remote proc trans','1';
    go

    reconfigure with override;
    go

    Bye


    Sergio Govoni
    SQL Server MVP
    MVP Profile: https://mvp.support.microsoft.com/profile/Sergio.Govoni
    Blog: http://community.ugiss.org/blogs/sgovoni
    Friday, January 7, 2011 1:42 AM