none
Configuration of Group failing RRS feed

  • Question

  • Hi,

    We are experiencing big problems trying to configure our BizTalk 2013 R2 application.  Everytime we go to create the Group section of the config it fails with error 'System.EnterpriseServices.TransactionProxyException' .

    I have tested the DTCPING from SQL server to Application server and it completes successfully.Our setup is a Windows 2008R2 server hosting an SQL2012 instance and a separate server of Windows 2012R2 hosting the BizTalk2013 R2 application.

    I have copied the part of the config log that is failing below....

    [2017-01-26 10:07:47:0489 Info Configuration Framework]Configuring feature: WMI
    [2017-01-26 10:07:47:0489  Info BtsCfg] Entering function: CBtsCfg::ConfigureFeature
    [2017-01-26 10:07:47:0489  Info BtsCfg]  Configuring feature: WMI
    [2017-01-26 10:07:47:0489  Info BtsCfg] Entering function: CBtsCfg::IsSelectedAnswer
    [2017-01-26 10:07:47:0505  Info BtsCfg] Leaving function: CBtsCfg::IsSelectedAnswer
    [2017-01-26 10:07:47:0505  Info BtsCfg] Entering function: CWMI::Connect
    [2017-01-26 10:07:47:0505  Info BtsCfg] WMI is already connected
    [2017-01-26 10:07:47:0505  Info BtsCfg] Leaving function: CWMI::Connect
    [2017-01-26 10:07:47:0505  Info BtsCfg] Entering function: CWMI::CreateGroup
    [2017-01-26 10:09:03:0161  Error BtsCfg] d:\bt\127854\private\source\setup\btscfg\btswmi.cpp(438): FAILED hr = c0c025b3

    [2017-01-26 10:09:03:0161  Error BtsCfg] Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown.
    [2017-01-26 10:09:03:0161  Error BtsCfg] d:\bt\127854\private\source\setup\btscfg\btscfg.cpp(1820): FAILED hr = c0c025b3

    [2017-01-26 10:09:03:0161  Info BtsCfg] Entering function: CBtsCfg::UnConfigureFeature
    [2017-01-26 10:09:03:0161  Info BtsCfg]  Unconfiguring feature: WMI
    [2017-01-26 10:09:03:0161  Warning BtsCfg] BTS management server or DB names are not found in the registry.
    [2017-01-26 10:09:03:0161  Info BtsCfg] Entering function: CWMI::StopHostInstance
    [2017-01-26 10:09:03:0177  Error BtsCfg] d:\bt\127854\private\source\setup\btscfg\btswmi.cpp(1553): FAILED hr = c0c024bf

    [2017-01-26 10:09:03:0177  Error BtsCfg] The server has not been configured.
    To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
    [2017-01-26 10:09:03:0177  Info BtsCfg] Entering function: CWMI::UnMapHost
    [2017-01-26 10:09:03:0193  Error BtsCfg] d:\bt\127854\private\source\setup\btscfg\btswmi.cpp(1698): FAILED hr = c0c024bf

    [2017-01-26 10:09:03:0193  Error BtsCfg] The server has not been configured.
    To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
    [2017-01-26 10:09:03:0193  Info BtsCfg] Instantiating IBTSMsgBoxPerformance object
    [2017-01-26 10:09:03:0193  Info BtsCfg] Calling IBTSMsgBoxPerformance::UninstallArtifacts
    Exception in CounterManager.UninstallArtifacts when uninstalling the perf counter instances. The exception details are:
    Source of exception: System
    Message: Cannot delete Performance Category because this category is not registered or is a system category.
    Stack trace:    at System.Diagnostics.PerformanceCounterCategory.Delete(String categoryName)
       at Microsoft.BizTalk.MsgBoxPerfCounters.MgmtDbAccessEntity.UninstallInstances(Boolean regularUninstall)
       at Microsoft.BizTalk.MsgBoxPerfCounters.CounterManager.UninstallArtifacts(Boolean regularUninstall, String logFileName)
    [2017-01-26 10:09:03:0193  Info BtsCfg] Stopping Tracing

    Thursday, January 26, 2017 10:35 AM

Answers

  • No, you do not need to cluster MSDTC as of Windows Server 2008 R2.

    If you do, that's fine, but it doesn't matter, meaning it's doesn't help you in any way.

    Thursday, January 26, 2017 2:08 PM
    Moderator

All replies

  • you need to check your MSDTC settings on both boxes, BizTalk as well as SQL .

      • Uninstall and Install MSDTC on both SQL and BizTall ( run command MSDTC -uninstall and then MSDTC -Install) in command prmopt. this will make sure MSDTC is running and installed with unique ID. sometimes if you make the VM's using clones , it creates a problem. 
      • Check the MSDTC settings on each box. 
       
    • Run DTC Ping check this MSDTC issues  and this post by Steff-Jan poston BizTalk and MSDT
    • It should be like be like

    Hope this helps


    Cheers,HTH

    Naushad Alam http://alamnaushad.wordpress.com/

    When you see answers and helpful posts, please click Vote As Helpful , Propose As Answer , and/or Mark As Answer


    Thursday, January 26, 2017 10:45 AM
    Moderator
  • Thank you for your reply.  It seems that if the SQL instance for biztalk is in a cluster, it not only requires network access to the Local DTC but also the Cluster Instance of MSDTC.

    Once we opened up the ports to the IP of the MSDTC cluster resource, it worked.

    Thursday, January 26, 2017 11:02 AM
  • Hi ,

    Have you gone through system requirement to install BizTalk 2013R2 ?

    I would have expected SQL Server 2012 on windows server 2012 instead of windows server 2008R2.

    It is always good option to have alignment with the operating system running BizTalk Application Server and Database server and in your case i can see Application server is running over Windows server 2012 and DB Server is on windows server 2008R2.

    Once another  consideration is to check  whether you are using SQL Server default 1433 or a different port  . This will require to create inbound and outbound firewall rule to listen traffic between BizTalk instances clustered together.


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply

    Thursday, January 26, 2017 12:56 PM
  • No, you do not need to cluster MSDTC as of Windows Server 2008 R2.

    If you do, that's fine, but it doesn't matter, meaning it's doesn't help you in any way.

    Thursday, January 26, 2017 2:08 PM
    Moderator