[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
Records in this table represent errors that are recoverable (or “retryable”). This means an intermittent error 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 status to Errored and makes an entry in sprockit.Error. 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 available for selection by an available handler.
Care should be taken when deciding to configure a SQL error 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 out-of-the-box.
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK | ErrorNumber | INT | The number of an error that, whenever encountered, should result in the errored process being retried. | |
| Notes | NVARCHAR(1024) | Information about the recoverable error (for example, why it is considered recoverable). |
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| (None). | |||
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.