Home
  •  

Package execution failed because the checkpoint file cannot be loaded

Microsoft.SQLServer.2012.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule (Rule)

Knowledge Base article:

概要

A package that is configured to use checkpoints and to always use the checkpoint file failed to restart.

原因

The checkpoint file could not be loaded because it could not be found or the specified file does not have the expected format.

解決方法

The checkpoint file must be available locally.Locate the checkpoint file and move it to the expected location.

If the checkpoint file is not available, run the package using the Set option to override the configured value of the CheckpointUsage property to use either the value IfExists or Never.

外部資料

For more information, see the Books Online topics: "dtexec Utility", "Setting Package Properties", and "Using Checkpoints in Packages".

Element properties:

TargetMicrosoft.SQLServer.2012.IntegrationServices
CategoryEventCollection
EnabledTrue
Event_ID12550
Event SourceSQLISPackage110
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
Package execution failed because the checkpoint file cannot be loaded
{0}
Event LogApplication
CommentMom2012ID='{58C93261-222E-4E37-86F8-FC6E144751A5}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Microsoft.SQLServer.SQLDefaultAccount
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2012.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.IntegrationServices" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2012ID='{58C93261-222E-4E37-86F8-FC6E144751A5}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">

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

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>12550</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>SQLISPackage110</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDescription</XPathQuery>

              </ValueExpression>

              <Operator>ContainsSubstring</Operator>

              <Pattern>1073614717</Pattern>

            </RegExExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>1</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2012.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

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

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>