Home
  •  

MSSQL Integration Services on Windows: The package restarted from checkpoint file. Package was configured to restart from checkpoint and it did

Microsoft.SQLServer.IS.Windows.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule (Rule)

A package configured to use checkpoints failed and then restarted from the point of failure using the checkpoint file.

Knowledge Base article:

Summary

A package configured to use checkpoints failed and then restarted from the point of failure using the checkpoint file.

Causes

Failure may have occurred for a variety of reasons. However, because the package implements checkpoints, the package restarted from the point of failure in the package control flow, instead of the beginning of the package.

Resolutions

Investigate package failure to confirm whether restarting the package was desirable. Investigate logs to identify the cause of the failure that caused package to be restarted from the checkpoint file.

External

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

Overridable Parameters

Name

Description

Default Value

Allow Proxying

Specifies whether the module should collect events that do not originate from the computer that is specified in the ComputerName parameter.

No

Enabled

Enables or disables the workflow.

Yes

Priority

Defines Alert Priority.

1

Severity

Defines Alert Severity.

2

Element properties:

TargetMicrosoft.SQLServer.IS.Windows.LocalInstance
CategoryEventCollection
EnabledFalse
Alert GenerateTrue
Alert SeverityInformation
Alert PriorityNormal
RemotableTrue
Alert Message
MSSQL Integration Services on Windows: The package restarted from checkpoint file. Package was configured to restart from checkpoint and it did
Event ID: {0}. Event Name: {1}
Message:{9}
Operator: {2}
Source Name: {3}
Source ID: {4}
Execution ID: {5}
Start Time: {6}
End Time: {7}
Data Code: {8}
CommentMom2017ID='{6D7F5AEB-1674-4A78-95E2-DF5476C2E747}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

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

Source Code:

<Rule ID="Microsoft.SQLServer.IS.Windows.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Enabled="false" ConfirmDelivery="true" Remotable="true" Comment="Mom2017ID='{6D7F5AEB-1674-4A78-95E2-DF5476C2E747}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

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

      <ComputerName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/NetBiosComputerName$</ComputerName>

      <LogName>Application</LogName>

      <AllowProxying>false</AllowProxying>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>12558</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>SQLISPackage$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$0</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDescription</XPathQuery>

              </ValueExpression>

              <Operator>ContainsSubstring</Operator>

              <Pattern>1073832006</Pattern>

            </RegExExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>1</Priority>

      <Severity>0</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.IS.Windows.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDisplayNumber$</AlertParameter1>

        <AlertParameter2>$Data/Params/Param[1]$</AlertParameter2>

        <AlertParameter3>$Data/Params/Param[2]$</AlertParameter3>

        <AlertParameter4>$Data/Params/Param[3]$</AlertParameter4>

        <AlertParameter5>$Data/Params/Param[4]$</AlertParameter5>

        <AlertParameter6>$Data/Params/Param[5]$</AlertParameter6>

        <AlertParameter7>$Data/Params/Param[6]$</AlertParameter7>

        <AlertParameter8>$Data/Params/Param[7]$</AlertParameter8>

        <AlertParameter9>$Data/Params/Param[8]$</AlertParameter9>

        <AlertParameter10>$Data/Params/Param[9]$</AlertParameter10>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>