Home
  •  

Monitor for TFS Event 3009 - Unexpected Database Results

TeamFoundationServer2012.MonitorTFSEvent3009 (UnitMonitor)

The database returned unexpected results.

Knowledge Base article:

Summary

This is a major error. The database returned results that were unexpected.

Resolutions

There is no clear resolution. Look for any errors on the SQL Server that may be flagged by the SQL Server MP. Look into the event logs for other problems or other errors that may indicate the root cause.

External

http://msdn.microsoft.com/en-us/library/aa395280.aspx

Element properties:

TargetTeamFoundationServer2012.TFS2012AppComponentBase
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.SingleEventLogTimer2StateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
Monitor for TFS Event 3009 - Unexpected Database Results
Database unexpected results The database returned results that were unexpected. Action: contact dev team and/or file a work item.
RunAsDefault

Source Code:

<UnitMonitor ID="TeamFoundationServer2012.MonitorTFSEvent3009" Accessibility="Public" Enabled="true" Target="TeamFoundationServer2012.TFS2012AppComponentBase" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="TeamFoundationServer2012.MonitorTFSEvent3009_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="EventRaised" MonitorTypeStateID="EventRaised" HealthState="Error"/>

    <OperationalState ID="TimerEventRaised" MonitorTypeStateID="TimerEventRaised" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <LogName>Application</LogName>

    <Expression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">TFS Services</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

    <TimerWaitInSeconds>86400</TimerWaitInSeconds>

  </Configuration>

</UnitMonitor>