/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.RecoverableError ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

Records in this table represent types of SQL 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 [[sprockit.Handler|process handler]] catches an error thrown from a [[sprockit.Process|stored procedure]], it updates the process's status to //Errored// and makes an entry in [[sprockit.Error]]. Conversely, if the message number of the SQL Server error appears in this table, no error is logged and the process's status is set to //Ready//, making it again available for [[sprockit.Process#selecting processes for execution|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. 
    

/* 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, when 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).  |  |

/* 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.5: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 */