Table of Contents

sprockit.RecoverableError

[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]

Records in this table represent types of error that are recoverable (or “retryable”). A recoverable error is usally an intermittent fault that, if it occurs (causing process execution to fail), the only action you would take is to restart the failed process.

Normally, when a process handler catches an error thrown from a process, it updates the process's status to Errored and makes an entry in sprockit.Error. Conversely, if the number of the error appears in this table, no error is logged and the process's status is set to Ready, making it again available for selection by an available handler.

Care should be taken when designating error types as recoverable – errors that are likely to recur indefinitely will cause processing to enter an infinite loop. Transaction deadlocks (error number 1205) that cause the database engine arbitrarily to kill one process are a good example of recoverable errors and are configured in this table by default.

Columns

Column name1) Column type Description Notes
PK ErrorNumber INT The number of an error that, whenever encountered, should result in the failed process being retried.
Notes NVARCHAR(1024) Narrative information about the recoverable error (for example, why it is considered recoverable).

Relationships

Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

References to other tables

Attributes
(in this table)
Referenced table Referenced attributes
(in referenced table)
(None).

References to this table from others

Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)
(None).

Page generated from database metadata by DbScout.

1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.