BAM Web Services Event Provider: ERROR - Error connecting to the BAM Primary Import database - Reference database not found

Microsoft.BizTalk.Server.2013R2.PrimaryImportDatabaseReferenceNotFound (Rule)

BAM portal ERROR: Error connecting to the BAM Primary Import database - Reference database not found.

Knowledge Base article:

Summary

In a scenario involving multiple BAM Primary Import databases, a referenced BAM Primary Import database could not be found.

Causes

This may be because of a bad configuration or due to loss of network connectivity to a SQL server.

Resolutions

Please investigate your BAM configuration with BAM Manager (bm.exe get-references), and verify if referenced databases and SQL Servers are correctly specified. Please investigate if all the involved referenced databases and SQL servers are available.

Configuration

Not Available

Additional

Not Available

External

Not Available

Element properties:

Target

Microsoft.BizTalk.Server.2013R2.BizTalkRuntimeRole

Category

EventCollection

Enabled

True

Event_ID

12033

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Remotable

True

Alert Message

ERROR: Error connecting to the BAM Primary Import database - Reference database not found

{0}

Event Log

Application

Member Modules:

ID	Module Type	TypeId	RunAs
Microsoft.BizTalk.Server.2013R2.PrimaryImportDatabaseReferenceNotFound.DataSource	DataSource	Microsoft.Windows.EventProvider	Default
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectEvent	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Default

Source Code:

<Rule ID="Microsoft.BizTalk.Server.2013R2.PrimaryImportDatabaseReferenceNotFound" Enabled="true" Target="BTSLib!Microsoft.BizTalk.Server.2013R2.BizTalkRuntimeRole" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="Microsoft.BizTalk.Server.2013R2.PrimaryImportDatabaseReferenceNotFound.DataSource" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2013R2.ServerRole"]/ComputerName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <Or>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery Type="String">PublisherName</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">BAM Web Service</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery Type="String">PublisherName</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">BAMWebServices</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

            </Or>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="UnsignedInteger">12033</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

    <WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>2</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.BizTalk.Server.2013R2.PrimaryImportDatabaseReferenceNotFound.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2013R2.ServerRole"]/ComputerName$</SuppressionValue>

        <SuppressionValue>$Data/EventDisplayNumber$</SuppressionValue>

        <SuppressionValue>$Data/PublisherName$</SuppressionValue>

      </Suppression>

      <Custom1>BAM Alerts</Custom1>

    </WriteAction>

  </WriteActions>

</Rule>