none
Configuration of BizTalk 2009 Group Failing - OLAP error RRS feed

  • Question

  • We have installed BizTalk 2009 Enterprise on Windows 2008 x64 using a remote SQL Server 2008 database instance.  The instance has both Analysis and Integration services installed successfully to it (I can connect to everything using SQL Management Studio client tools on the BizTalk server).  Everything appeared to install correctly.

    Using the configuration window, I was able to create a new Enterprise SSO for my environment on the SQL 2008 instance.  I was also able to successfully enable the "Business Rules Engine" section.  However when I try to enable and create a new BizTalk server group, the configuration fails to apply and I get this sort of message in the log:

    [8:55:02 AM Info BtsCfg] Entering function: CBtsCfg::GetFeatureConfig
    [8:55:02 AM Info BtsCfg]  Building feature XML for: WMI
    [8:55:02 AM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [8:55:03 AM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [8:55:03 AM Info ConfigHelper]  Feature: Engine is installed
    [8:55:03 AM Info BtsCfg] Leaving function: CBtsCfg::GetFeatureConfig
    [8:55:03 AM Info BtsCfg] Entering function: CBtsCfg::GetFeatureConfig
    [8:55:03 AM Info BtsCfg]  Building feature XML for: Engine,BTSCfg
    [8:55:03 AM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [8:55:03 AM Info ConfigHelper] SQL Analysis service is not running on this machine.


    Since Analysis services is configured on the remote SQL machine, I am not sure what to do.  The service account I am using has sysadmin rights to the SQL instance (and on a whim I made it a local admin on the SQL machine as well but it still didn't work).  I can't find any real solutions that are relevant to our situation, so I am not sure where to go next.  Any ideas?  Thanks!

     
    Tuesday, November 10, 2009 3:23 PM

Answers

All replies

  • Analysis Services are not required for the BizTalk group, only for some of the BAM features so this is weird. The BizTalk group often fails when the MSDTC and COM+ settings are not yet configured on both the BizTalk and SQL servers.

    Is this all of the log or are there further entries after what you posted?

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Tuesday, November 10, 2009 4:27 PM
    Moderator
  • DTC and Com+ are setup as per Microsoft BizTalk Installation guide (allow inbound and outbound with no authentication).  No firewall issues either.  Here is the complete log when trying to enable the "Group" section:


    [12:01:49 PM Info Configuration Framework]Entering function IsAdminRequiredForConfig.
    [12:01:49 PM Info Configuration Framework]Leaving function IsAdminRequiredForConfig.
    [12:01:49 PM Info Configuration Framework]Entering function UseSplashScreen.
    [12:01:49 PM Info Configuration Framework]Leaving function UseSplashScreen.
    [12:01:54 PM Info Configuration Framework]Created IConfig2 object for feature: SSOServer,Engine ProgID: MSEBiz.SSOServerCfg.
    [12:01:54 PM Info SSOServerCfg] (ssoconfigobj2.cpp:1867) CSSOServerCfg::AdviseCommon
    [12:01:54 PM Info SSOServerCfg] (ssoconfigobj2.cpp:103) CSSOServerCfg::InitializeOneTime
    [12:01:54 PM Info SSOServerCfg] (ssoconfigobj2.cpp:116) x64
    [12:01:54 PM Info SSOServerCfg] (ssoconfigobj2.cpp:134) GetVersionEx:6:0:3
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:179) Computer name: BTQA03
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:187) Current user name: RTMS_PDC\administrator
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5487) CSSOServerCfg::CheckDC
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5538) This computer is not a domain controller.
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5945) CSSOServerCfg::GetCluster
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5988) This computer is not clustered.
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:1820) CSSOServerCfg::LoadProductId
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:1938) SSOServer,Engine
    [12:01:55 PM Info SSOServerCfg] (ssoconfigobj2.cpp:1803) CSSOServerCfg::Advise: 0x00000000 (0)
    [12:01:55 PM Info Configuration Framework]Created IConfig2 object for feature: WMI ProgID: MSEBiz.BtsCfg.
    [12:01:55 PM Info BtsCfg] Entering function: CBtsCfg::Advise
    [12:01:55 PM Info BtsCfg] Leaving function: CBtsCfg::Advise
    [12:01:55 PM Info Configuration Framework]Created IConfig2 object for feature: Engine,BTSCfg ProgID: MSEBiz.BtsCfg.
    [12:01:55 PM Info BtsCfg] Entering function: CBtsCfg::Advise
    [12:01:55 PM Info BtsCfg] Leaving function: CBtsCfg::Advise
    [12:01:55 PM Info Configuration Framework]Created IConfig2 object for feature: RulesEngine ProgID: Microsoft.BizTalk.Configuration.Rules.RulesConfig.
    [12:01:56 PM Info RulesEngine] Entering function Advise
    [12:01:56 PM Info RulesEngine] Installing for product code '{F78D5EEB-2260-4729-AE54-48BAE74A9601}'
    [12:01:56 PM Info RulesEngine] Installation directory is C:\Program Files (x86)\Common Files\Microsoft BizTalk\
    [12:01:56 PM Info RulesEngine] Product installation directory is E:\Program Files (x86)\Microsoft BizTalk Server 2009\
    [12:01:56 PM Info RulesEngine] Leaving function Advise
    [12:01:56 PM Info Configuration Framework]Created IConfig2 object for feature: MOT ProgID: MSEBiz.BAMConfigWizExt.
    [12:01:56 PM Info BAMConfigWizExt] C:\Users\administrator.RTMS_PDC\AppData\Local\Temp\ConfigLog(11-10-2009 12h1m49s).log
    [12:01:56 PM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [12:01:56 PM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [12:01:56 PM Info Configuration Framework]Created IConfig2 object for feature: BAMTools ProgID: MSEBiz.BAMConfigWizExt.
    [12:01:56 PM Info BAMConfigWizExt] C:\Users\administrator.RTMS_PDC\AppData\Local\Temp\ConfigLog(11-10-2009 12h1m49s).log
    [12:01:56 PM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [12:01:56 PM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [12:01:56 PM Info Configuration Framework]Created IConfig2 object for feature: BAMPortal ProgID: MSEBiz.BAMConfigWizExt.
    [12:01:56 PM Info BAMConfigWizExt] C:\Users\administrator.RTMS_PDC\AppData\Local\Temp\ConfigLog(11-10-2009 12h1m49s).log
    [12:01:56 PM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [12:01:56 PM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [12:01:56 PM Info Configuration Framework]Created IConfig2 object for feature: MsEDIAS2 ProgID: Microsoft.BizTalk.Configuration.EDIAS2.EDIAS2Config.
    [12:01:57 PM Info EDIAS2Config] Entering function EDIAS2Config::Advise
    [12:01:57 PM Info EDIAS2Config] Leaving function EDIAS2Config::Advise
    [12:01:57 PM Info Configuration Framework]Entering function LoadXMLfromModules()
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:416) CSSOServerCfg::GetFeatureConfig(2)
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:227) CSSOServerCfg::InitializeComponents
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:278) CSSOServerCfg::ReleaseComponents
    [12:01:57 PM Info ConfigHelper] Checking if service exists.
    [12:01:57 PM Info ConfigHelper] Attempting to open service manager.
    [12:01:57 PM Info ConfigHelper] Attempting to lock service database.
    [12:01:57 PM Info ConfigHelper] NT Service: ENTSSO already exists
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:446) SSO is configured
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:453) SQL Server: SQLDEV08\BIZTALK
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:458) SSO database: SSODB
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:7286) CSSOServerCfg::IsSecretServer
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:7302) ISSOConfigOM::GetServerStatus
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:7338) This computer is the SSO master secret server.
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:470) IConfigHelper::GetServiceAccount
    [12:01:57 PM Info ConfigHelper] Attempting to open service manager.
    [12:01:57 PM Info ConfigHelper] Attempting to lock service database.
    [12:01:57 PM Info ConfigHelper]  Configured service: ENTSSO
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:481) SSO service account: rtms_pdc\biztalk2009serviceQA
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:514) ISSOAdmin::GetGlobalInfo
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:528) ISSOAdmin::GetGlobalInfo: 0x00000000 (0)
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:537) SSO Administrators account: RTMS_PDC\SSO Administrators
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:538) SSO Affiliate Administrators account: RTMS_PDC\SSO Affiliate Administrators
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:573) IConfigHelper::AddFeatureToConfigXML
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:591) IConfigHelper::SetAttributeOnConfigXML
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:631) IConfigHelper::AddQuestionToConfigXML
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:646) IConfigHelper::AddNTServiceToConfigXML
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:662) IConfigHelper::AddSQLToConfigXML
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:678) IConfigHelper::SetElementEditable
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:704) IConfigHelper::AddNTCredentialToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:723) IConfigHelper::AddNTCredentialToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:768) IConfigHelper::AddFileToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:789) IConfigHelper::AddNameToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:806) IConfigHelper::AddNameToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:823) IConfigHelper::AddNameToConfigXMLQuestion
    [12:01:57 PM Info SSOServerCfg] (ssoconfigobj2.cpp:863) CSSOServerCfg::GetFeatureConfig: 0x00000000 (0)
    [12:01:57 PM Info BtsCfg] Entering function: CBtsCfg::GetFeatureConfig
    [12:01:57 PM Info BtsCfg]  Building feature XML for: WMI
    [12:01:57 PM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [12:01:57 PM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [12:01:57 PM Info ConfigHelper]  Feature: Engine is installed
    [12:01:57 PM Info BtsCfg] Leaving function: CBtsCfg::GetFeatureConfig
    [12:01:57 PM Info BtsCfg] Entering function: CBtsCfg::GetFeatureConfig
    [12:01:57 PM Info BtsCfg]  Building feature XML for: Engine,BTSCfg
    [12:01:57 PM Warning ConfigHelper] The serivce: MSSQLServerOLAPService does not exist.
    [12:01:57 PM Info ConfigHelper] SQL Analysis service is not running on this machine.
    [12:01:57 PM Info BtsCfg] Leaving function: CBtsCfg::GetFeatureConfig
    [12:01:57 PM Info RulesEngine] Entering function GetFeatureConfig
    [12:01:57 PM Info RulesEngine] Previously configured database is server = 'SQLDEV08\BIZTALK', database = 'BizTalkRuleEngineDb'
    [12:01:57 PM Info RulesEngine] Service 'RuleEngineUpdateService'  is already installed, status = Running
    [12:01:57 PM Info RulesEngine] Leaving function GetFeatureConfig
    [12:01:57 PM Info BAMConfigWizExt] Entering function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:57 PM Info BAMConfigWizExt] Building feature XML for: MOT
    [12:01:57 PM Info BAMConfigWizExt] Leaving function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:57 PM Info BAMConfigWizExt] Entering function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:57 PM Info BAMConfigWizExt] Building feature XML for: BAMTools
    [12:01:57 PM Info ConfigHelper]  Feature: WMI is installed
    [12:01:58 PM Info CfgExtHelper] No BizTalk Management Database or BAM Primary Import Database given
    [12:01:58 PM Info CfgExtHelper] No BizTalk Management Database or BAM Primary Import Database given
    [12:01:58 PM Info ConfigHelper]  Feature: OLAPNS is installed
    [12:01:59 PM Info BAMTools] Determining whether Microsoft Sql Notification Services 2005 is installed on the local machine.
    [12:01:59 PM Info BAMTools] Product with product key {63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084} is not installed.
    [12:01:59 PM Info BAMTools] Product with product key {C0B81E26-F7D0-4E84-941A-21C438BC586D} is not installed.
    [12:01:59 PM Info BAMTools] Product with product key {EA145881-7452-4004-80B9-971FC3D1D8D8} is not installed.
    [12:01:59 PM Info BAMTools] Product with product key {63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084} is not installed.
    [12:01:59 PM Info BAMTools] Product with product key {C0B81E26-F7D0-4E84-941A-21C438BC586D} is not installed.
    [12:01:59 PM Info BAMTools] Product with product key {EA145881-7452-4004-80B9-971FC3D1D8D8} is not installed.

    [12:01:59 PM Info BAMConfigWizExt] Leaving function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:59 PM Info BAMConfigWizExt] Entering function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:59 PM Info BAMConfigWizExt] Building feature XML for: BAMPortal
    [12:01:59 PM Info ConfigHelper]  Feature: WMI is installed
    [12:01:59 PM Info CfgExtHelper] No BizTalk Management Database or BAM Primary Import Database given
    [12:01:59 PM Info CfgExtHelper] No BizTalk Management Database or BAM Primary Import Database given
    [12:01:59 PM Info BAMPortal] Determining default BAM Portal Users Group.
    [12:01:59 PM Info BAMPortal] Got BAM Portal Users Group Everyone
    [12:01:59 PM Info BAMPortal] Determining version of IIS.
    [12:01:59 PM Info BAMPortal] Opening local registry key: SOFTWARE\Microsoft\InetStp
    [12:01:59 PM Info BAMPortal] Getting registry value: MajorVersion
    [12:01:59 PM Info BAMPortal] IIS version is: 7
    [12:01:59 PM Info BAMPortal] Built feature XML: <Configuration><Feature Name="BAMPortal" DisplayName="BAM Portal" Version="1.0" Description="The Business Activity Monitoring (BAM) Portal is used to query individual instance data stored in the Tracking database. Each BAM Query Web Service corresponds to one SQL database."><NTService ID="{C08C5A6C-53FB-41bd-A1CE-FD7209FD16F4}" DisplayName="BAM Management Web Service user" Description="Windows account that will have permissions to access the data in the BAM Primary Import Database during Business Activity searches." ReadOnly="false"><UserName></UserName><Domain></Domain><Password>*Hidden*</Password></NTService><NTService ID="{FAAB0AD8-C414-4735-91E5-3DCEC8CB96A8}" DisplayName="BAM Application Pool Account" Description="Identity of the BAM Application Pool. " ReadOnly="false"><UserName></UserName><Domain></Domain><Password>*Hidden*</Password></NTService><NTCredential ID="{e8118b16-0585-41a4-99bb-6d8a30570fcc}" DisplayName="BAM Portal Users" Description="The user accounts under which the BAM portal services run." ReadOnly="false"><NTAccount ScopeType="103" UpLevelFlags="676" DownLevelFlags="2147483654">Everyone</NTAccount></NTCredential><WebSite ID="{DA1ABC72-465B-4953-ADD7-98CEA6F4E503}" DisplayName="BAM Portal Web &amp;Site:" Description="Specify the name of the web site under which the BAM Portal virtual directory will be created." ReadOnly="false"><WebSiteName>Default Web Site</WebSiteName></WebSite></Feature></Configuration>

    [12:01:59 PM Info BAMConfigWizExt] Leaving function: CBAMConfigWizExt::GetFeatureConfig
    [12:01:59 PM Info EDIAS2Config] Entering function EDIAS2Config::GetFeatureConfig
    [12:01:59 PM Info EDIAS2Config] Leaving function EDIAS2Config::GetFeatureConfig

    Tuesday, November 10, 2009 6:08 PM
  • I would step through the config wizard and just configure one feature at a time. So do the BizTalk group but do not enable the BAM features. The full log shows it is trying to configure BAM and EDI in addition to the BizTalk group.

    It should pass on the Group and the BizTalk runtime and then you can configure BAM where the actual Analysis Service issue is occuring. Once you get to BAM could you mention if any of the icons for the databases show a Yellow triangle rather than the database icon?

    Thanks,
    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Tuesday, November 10, 2009 7:48 PM
    Moderator
  • I figured it out......   First of all, I was using Trace32.exe (from SCCM toolkit) to look at the log file (also what I used to copy and paste for you above).  Unfortunately, deeper reading of the file showed me that for some weird reason, the Trace32 was not displaying all of the lines of the log file.  So i copied the text file out to another program and back in and Voila!  I can see all of the lines now.... and I found the errors that weren't there before....

    When you use a remote SQL server, it actually is looking for the "Administrators" and "Operators" groups on the SQL server by default (even though the configuration window has the local groups from the BizTalk server).  Since those groups don't exist on the SQL server, the configuration fails and everything rolls back.  I went ahead and changed the values to use Domain groups and everything works okay for the "Group" section configuration.

    I ran into similar sorts of issues with each section.  I found that some of the sections don't give you the option of choosing a group to use, but still expect the local SQL one to be there.  So I actually created the Operators, Administrators, and Application Users groups locally on the SQL server (so the database permissions are set successfully) then populated those groups with my domain groups for actual membership.  This allowed all of the configurations to work, so I hope that it works okay for daily operation!

    Long story short - way too much undocumented configuration "gotchas" for doing a remote SQL database - but you do what you have to do.  Thanks for your help (I won't actually mark this question solved until my development team confirms that it works the way it is supposed to)!

    Tuesday, November 10, 2009 10:48 PM
  • The multi computer environment install doc (see http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=9c697e02-d1bc-4684-8748-28b3a292d5bf) mentions all of the domain groups to create when the SQL server is on a separate server and you specify the domain groups during the BizTalk config wizard rather than the local groups.

    Thanks,
    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Tuesday, November 10, 2009 11:25 PM
    Moderator
  • that document helped (and followed pretty much what we did anyway), but one of the configuration sections still looked for a local group on the SQL server, even though domain groups were specified.  Thanks for your help with this!
    Wednesday, November 11, 2009 2:43 PM