/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.RecoverableError ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|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 [[sprockit.Handler|process handler]] catches an error thrown from a [[sprockit.Process|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 [[sprockit.Process#selecting processes for execution|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. 
    

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^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).  |  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.3:Sprockit tables:Sprockit tables|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).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */