Data Access Layer will retry after connection to a SQL server is restored

Veritas.EnterpriseVault.12.Server.DALWillRetry (Rule)

Knowledge Base article:

Summary

Connection to the SQL server is temporarily broken. SQL commands will be retried after the connection is restored.

Causes

SQL server is temporarily inaccessible due to reasons like failover.

External

Veritas Event Database

Element properties:

Target	Veritas.EnterpriseVault.12.Server
Category	EventCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Veritas.EnterpriseVault.12.EventProvider.DataSourceModuleType	Veritas.EnterpriseVault.MonitoringProfile
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectEvent	Veritas.EnterpriseVault.MonitoringProfile
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Veritas.EnterpriseVault.MonitoringProfile

Source Code:

<Rule ID="Veritas.EnterpriseVault.12.Server.DALWillRetry" Target="Veritas.EnterpriseVault.12.Server" Enabled="true" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Veritas.EnterpriseVault.12.EventProvider.DataSourceModuleType" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile">

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

      <EventNumber>41619</EventNumber>

      <LogName>Application</LogName>

      <EventSourceName>Enterprise Vault</EventSourceName>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile"/>

    <WriteAction ID="WriteToDW" TypeID="MSDL!Microsoft.SystemCenter.DataWarehouse.PublishEventData" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile"/>

  </WriteActions>

</Rule>