The setup of BAM Views with BizTalk Server 2013 can give you with some issues listed there in this article. For some of these issue I will provide some background information and provide you solution to the given issues.
The installation bits of BizTalk Server 2013 contains a file called BAM.xla. This file is an Excel add-in which is used to define the data you are interested in, by defining Business activities. You can read more about this part of building BAM solutions on MSDN (see http://msdn.microsoft.com/en-us/library/aa546725.aspx).
You start creating BAM solutions, by opening Excel, enable the Add-in to the ribbon and start defining the desired Business activities. However, when you try to enable the Add-in which comes with BizTalk Server 2013, you’ll get the following error:
“Could not load an object because it is not available on this machine”
Even after applying BizTalk Server 2013 Cumulative Update 2 the problem still exists. Other users have reported the same issue. Solution approach: It can be fixed by taking the BAM.xla from BizTalk Server 2010 (or BizTalk Server 2013 Beta).
When you try to add the BAM.xla to the ribbon of Excel (2010 or 2013), you get the following error:
This issue is not related to just BizTalk 2013, but as it also occurs with BizTalk 2013, it's worth mentioning it anyway. After you have installed and configured BAM and you have deployed a view, you open the BAM Portal. Even without having deployed a Tracking Profile you should be able to see the view. However in the left hand side pane the following error shows up:
“Views or Activities may be missing because one or more database(s) could not be contacted”
This behavior is described in more detail in this article (http://blogs.msdn.com/b/tihot/archive/2006/06/13/630313.aspx), but the general approach to find and fix the root cause is described here briefly as well. Solution approach: First you’ll have to check the Event Viewer for related entries. You’ll find an entry which describes that the BAMPrimaryImport database is not accessible due to a NullReferenceException. Next you’ll have to enable tracing for the BAM Web Services. Do this by opening the web.config file in folder: C:\Program Files\Microsoft BizTalk Server 2013\BAMPortal\BamManagementService and uncomment the <system.diagnostics> area. By refreshing the BAM Portal the trace file will contain more information about the root cause. By default the trace file can be found in: C:\Temp\BamManagementServiceTrace.log In the trace file you’ll find the root cause:
“ThrowHelperSoapException Error 11007 Cannot determine the SID for the user”
Behind the scenes the BAM Web Services will try to find the Windows identity for the dbo user in SQL Server, as this user has permissions to all BAM Views. However this will fail if that’s a SQL account. You can fix this problem by changing the dbo accounts for all BAM databases to Windows accounts. Therefore you should run the following script:
use BAMPrimaryImport go sp_changedbowner 'domain\user' go
Now you can refresh the BAM Portal again and find out if the BAM Views are now shown correctly.
When using Internet Explorer 10 for viewing the BAM Portal and you notice that, in the Column Chooser section, you can’t move columns to the 'Items to show' List Box, you should check if you are running Internet Explorer in Compatibility Mode.
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.