BizTalk BAM activity Deploy problem – The BAM Star Schema database has not been configured. Run bm.exe setup-databases to configure the database.

Posted: October 25, 2010  |  Categories: Administration BAM BizTalk

When trying to deploy BAM activity into a new BizTalk Environment:

  • “C:\Program Files (x86)\Microsoft BizTalk Server …\Tracking>bm.exe deploy-all -DefinitionFile:BAM.SMSExpress.xls”

It happened to me the following error:

“Microsoft (R) Business Activity Monitoring Utility Version 3.9.469.0
Copyright (C) Microsoft Corporation. All rights reserved.
Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘BTS2010LAB01’…
Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
The BAM Star Schema database has not been configured. Run bm.exe setup-databases to configure the database.

Cause

  • One of the possible causes of the problem is that Analysis Services form BAM aggregations were not configured.

Solution

  • Open BizTalk Server Configuration Console. (All Programs ➤ Microsoft BizTalk Server … ➤ BizTalk Server Configuration)
  • Select the option “BAM Tools” in the left menu and check the option “Enable Analysis Services for BAM Aggregations
  • Configure “BAM Analysis Database” and “BAM Star Schema Database
    BAM Tools Configuration
  • Click “Apply Configuration
  • On the Summary screen, click “Next
    BAM Tools Configuration summary
  • On the completed screen, click “Finish
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

2 thoughts on “BizTalk BAM activity Deploy problem – The BAM Star Schema database has not been configured. Run bm.exe setup-databases to configure the database.”

Leave a Reply

Your email address will not be published.

BizTalk360
BizTalk Server

Over 650+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Operate efficiently with enterprise-grade Azure monitoring,
tracing, remediation & governance in one platform

Learn More

Back to Top