We have followign error showing up in BAM Portal "Views or activities may be missing because one or more databases could not be contracted".
When we analysed further, there is following error in event log :
Referenced database 'BAMPrimaryImport' on server ‘Machine Name' is not accessible. The error is:
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.BizTalk.Bam.WebServices.AsyncResult.End(AsyncResult asyncResult)
at Microsoft.BizTalk.Bam.WebServices.Management.GetViewSummaryAsyncResult.End(IAsyncResult result)
at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.GetViewSummaryForCurrentUser()
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.BizTalk.Bam.WebServices.AsyncResult.End(AsyncResult asyncResult)
at Microsoft.BizTalk.Bam.WebServices.Management.GetViewSummaryAsyncResult.End(IAsyncResult result)
at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.GetViewSummaryForCurrentUser()
Solution:
BizTalk BAM having some bug, if expired user account has some BAM activity view permission, then BAM view s won't not be loaded in BAM portal.
Gone through all accounts permissions those are given to all BAM views in bam prim db.
Finally, found one account which is no longer present in active directory or expired.
On removing permission for that user account to BAM view, issue got solved automatically
- Best of luck..
Hi everyone. I have installed Biztalk Server 2013 R2 in a Windows Server 2012 R2 machine, and done proper configuration, including BAM related. Everything worked fine except that I couldn’t see BAM Views in BAM Portal, the error was: "Views or Activites may be missing because one or more database(s) could not be contacted." After a lot of research and doing this or that (executing sp_changedbowner, drop user and create it again, reinstalling BAM, bm.exe add-account command in cmd, and so on), I came to realize that IIS wasn't using web.config authorization allowed user, even though it was there (). How I found that out? By exploring IIS, under BAM web site, Authentication settings. Seems that in Windows Server 2012 R2, "Windows Authentication" is not installed by default. Only Anonymous Authentication, ASP.NET Impersonation and Forms Authentication are installed by default. I had Anonymous Authentication Enabled, so that I could browse BAM Portal, but couldn't see BAM views. What I did was adding Windows Authentication provider using Windows Server Manager, in Add Roles and Features Wizard, under Web Server (IIS) -> Web Server -> Security -> Windows Authentication. After restarting my machine, I could finally see BAM Views! This took me almost three days, reason why I wanted to share. Hope it helps someone. Peace!
ReplyDelete