I posted recently a problem with BAM: “Error deploying definition to BAM”. With the ESB Guidance 2.0 (CTP version from January) I received the same message, but then for the database BAMStarSchema. After adding the SQL Service account to the right security group I received another error:
Microsoft (R) Business Activity Monitoring Utility Version 3.8.104.5
Copyright (C) 2006 Microsoft Corporation. All rights reserved.
Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘WIN2008′…
Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
Server: The operation has been cancelled.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘ExcByApplication_ExcDatetime’, Name of ‘ExcByApplication_ExcDatetime’ was being processed.
Errors in the OLAP storage engine: An error occurred while the ‘Year’ attribute of the ‘ExcByApplication_ExcDatetime’ dimension from the ‘BAMAnalysis’ database was being processed.
Internal error: The operation terminated unsuccessfully.
The following system error occurred: Unspecified error .
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘bam_ExcByApplication’, Name of ‘bam_ExcByApplication’.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘ExcByApplication_ExcDatetime’, Name of ‘ExcByApplication_ExcDatetime’ was being processed.
… etc …
After inspecting my machine I find out that I was missing BAMAnalysis. After reconfiguring BizTalk again, it worked fine. Note: to trigger to create the BAMAnalysis was to rename it to another name, and then back to BAMAnalysis.
