A package that is configured to use checkpoints and to always use the checkpoint file failed to restart.
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 Docs Online topics: "dtexec Utility", "Setting Package Properties", and "Using Checkpoints in Packages".
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 |
Target | Microsoft.SQLServer.IS.Windows.LocalInstance | ||
Category | EventCollection | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Remotable | True | ||
Alert Message |
| ||
Comment | Mom2017ID='{58C93261-222E-4E37-86F8-FC6E144751A5}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ | DataSource | Microsoft.SQLServer.IS.Windows.EventProvider | Default |
GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
<Rule ID="Microsoft.SQLServer.IS.Windows.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2017ID='{58C93261-222E-4E37-86F8-FC6E144751A5}';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>12550</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>1073614717</Pattern>
</RegExExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>2</Severity>
<AlertMessageId>$MPElement[Name="Microsoft.SQLServer.IS.Windows.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_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>