Troubleshooting BAM
Collapse the table of content
Expand the table of content

Troubleshooting BAM

This topic provides information to help you troubleshoot problems you might encounter when using Business Activity Monitoring (BAM).

BAM deployment failed

If you attempt to deploy a BAM definition that includes a real-time aggregation (RTA) when SQL Server Analysis Services is not available, the Bm.exe command will display the following message:

ERROR: BAM deployment failed. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it <IP address>.

This occurs because SQL Server Analysis Services must have been installed and configured, and must be running in order to deploy a BAM definition that includes an RTA.

Cannot refresh the live data workbook

When you try to refresh the data in a live data workbook, Microsoft Office Excel might display the following error:

XML for Analysis parser: The CurrentCatalog XML/A property was not specified.

This occurs because the BAM add-in has not been added to Excel.

To add the BAM add-in to Excel
  1. Click Start, point to Programs, point to Microsoft Office, and then click Microsoft Office Excel 2007.

  2. In Excel 2007, click the Microsoft Office Button, and then click Excel Options.

  3. In the Excel Options dialog box, click Add-Ins.

  4. In the Add-Ins pane, click Go.

  5. In the Add-Ins dialog box, select the Business Activity Monitoring check box, and then click OK.

    Add-Ins dialog box

BAM portal cannot connect

In Windows Server 2008 or Windows Vista, you must run the BAM portal as an administrator.

To run the BAM portal on Windows Server 2008 or Windows Vista
  1. Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.

  2. In the User Account Control dialog box, click Continue.

  3. In the Internet Explorer address bar, type http://<server>/BAM, where <server> is the name of the computer that is running the BAM portal.

Cannot export or import a BAM definition to localhost

When you export a BAM definition as XML, you will see the following error message if you try to export to localhost:

The system cannot find the path specified.

Exporting a BAM definition to localhost is not supported. Similarly, importing a BAM definition from localhost is not supported.

Alerts do not work after upgrading SQL Server editions

If you have upgraded from one edition of SQL Server to another edition (for example, from Standard Edition to Enterprise Edition), BAM alerts will not restart. To fix this problem, either delete the BAM alerts and re-create them, or upgrade the SQL Server Notification Service.

To upgrade the SQL Server Notification Service
  1. Click Start, click All Programs, click Microsoft SQL Server 2005, and then click Notification Service Command Prompt.

  2. Type the following command at the command prompt:

    nscontrol.exe –upgrade

See Also

  © 2009 Microsoft Corporation. All rights reserved.
© 2016 Microsoft