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
Click Start, point to Programs, point to Microsoft Office, and then click Microsoft Office Excel 2007.
In Excel 2007, click the Microsoft Office Button, and then click Excel Options.
In the Excel Options dialog box, click Add-Ins.
In the Add-Ins pane, click Go.
In the Add-Ins dialog box, select the Business Activity Monitoring check box, and then click OK.
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
Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.
In the User Account Control dialog box, click Continue.
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
Click Start, click All Programs, click Microsoft SQL Server 2005, and then click Notification Service Command Prompt.
Type the following command at the command prompt: