I was playing around with a Business Activity Monitoring (BAM) demo for the Sydney BizTalk users group last week. There's some nice new features of BAM in BTS 2006.
After a few hours of try to get BAM to work on a BTS2006 image with a SQL Server 2005 CTP version, I gave up and tried on another image that had SQL Server 2000.
This is what showed up in BizTalk configuration:
Later on, I found this in the Microsoft BizTalk Server 2006 Beta 1 Known Issues documentation:
BM.exe does not deploy OLAP cubes on pre-release versions of SQL Server 2005
Problem: Business Activity Monitoring (BAM) does not support Analysis Services (OLAP) in pre-released versions of SQL Server 2005.
If you try to deploy a BAM definition using BM.exe, and the definition has references to a cube that uses the SQL Server 2005 platform, it will fail to deploy.
BM.exe does not work in the following situations:
- You are using a pre-release version of SQL Server 2005.
- You are using a combination of SQL Server 2000 and a pre-release version of SQL Server 2005
- You have installed BizTalk Server Beta 1 on SQL Server 2000 and then upgraded to a pre-release version of SQL Server 2005.
Solution: Use SQL Server 2000.
Ouch!
UPDATE: This still doesn't work with BTS2006 Beta 2 and SQL Server 2005 RTM!
posted on Saturday, October 29, 2005 12:42 PM