Archive for September, 2009
Deploy ESB BAM Exception Failed
One of the steps for installing Microsoft ESB Toolkit 2.0 is to deploy the BAM definition for exception management. Essentially you need to run the following command line.
Bm.exe deploy-all -DefinitionFile: “C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Bam\Microsoft.BizTalk.ESB.BAM.Exceptions.xml”
If you run into the following error (which I did), it is obvious that it is a permission issue.
|
… OLE DB error: OLE DB or ODBC error: Cannot open database “BAMStarSchema” requested by the login. The login failed.; 42000. 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. 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. … |
It turns out that the service account you run your SQL Server needs to have read/write access to your BAMStarSchema database. In my case, since I am on a DEV box, I simply slapped “db_owner” role onto “Network Service” (which is my SQL Service Account) to the BAMStarSchema database and the BAM deployment went through without problems.
1 comment