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 in BizTalk
Tags: , , ,

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 was 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 in “Apply Configuration”
  • On the Summary screen, Click “Next”
    BAM-Tools-Configuration-summary
  • On the completed screen, click “Finish”

Tags: BizTalk | BAM | Deploy | Errors and Warnings, Causes and Solutions

About these ads
Comments
  1. Dharmendra Mishra says:

    Great it worked for me.

  2. Anonymous says:

    Thank you!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s