Home
  •  

BAM Star Schema Database Availability Monitor

Microsoft.BizTalk.Server.2010.BAMStarSchemaDatabase.AvailabilityMonitor (UnitMonitor)

Availability monitor for the BAM Star Schema database

Knowledge Base article:

Summary

Availability monitor for the BAM Star Schema database

Causes

This commonly happens in the following situations: database is not running.

Resolutions

Ensure the database is running and online.

Element properties:

TargetMicrosoft.BizTalk.Server.2010.BAMAnalysis
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.BizTalk.Server.2010.Database.AvailabilityMonitor
RemotableTrue
AccessibilityPublic
Alert Message
BizTalk Server: Availability Monitor raised an Error on BAM Star Schema Database
BAM Star Schema database - {0} : reported an error: {1}
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.BizTalk.Server.2010.BAMStarSchemaDatabase.AvailabilityMonitor" Accessibility="Public" Enabled="true" Target="BTSLib!Microsoft.BizTalk.Server.2010.BAMAnalysis" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="BTSLib!Microsoft.BizTalk.Server.2010.Database.AvailabilityMonitor" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.BizTalk.Server.2010.BAMStarSchemaDatabase.AvailabilityMonitor.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2010.BAMAnalysis"]/BAMStarSchemaDbName$</AlertParameter1>

      <AlertParameter2>$Data/Context/Property[@Name='ErrorDetail']$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Database_Success" MonitorTypeStateID="SuccessState" HealthState="Success"/>

    <OperationalState ID="Database_Error" MonitorTypeStateID="ErrorState" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>990</IntervalSeconds>

    <TargetDBServer>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2010.BAMAnalysis"]/BAMStarSchemaDbServerName$</TargetDBServer>

    <TargetDBName>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2010.BAMAnalysis"]/BAMStarSchemaDbName$</TargetDBName>

    <LogSuccessEvent>false</LogSuccessEvent>

    <TimeoutSeconds>300</TimeoutSeconds>

  </Configuration>

</UnitMonitor>