January 17, 2008
Submitted by Matt Castors, Chief of Data Integration, Pentaho
Codes for the Step Error Handling.
Table Output
| Error code | meaning |
|---|---|
| TOP001 | General database error. See database error in the logging for more details |
| TOP0002 | General database error during batch update. See database error in the logging for more details. |
| TOP0003 | General database error during batch update. See database error in the logging for more details. All inserted rows in this batch are considered error rows. |
Validator
| Error code | Meaning |
|---|---|
| KVD001 | During validation of field '<field name>' we found that its value is null in row <<row values>> when this is not allowed. |
| KVD002 | During validation of field '<field name>' we found that value [<value>] has a longer (<value-length>) string length than allowed (<max-length>). |
| KVD003 | During validation of field '<field name>' we found that value [<value>] has a shorter (<value-length>) string length than allowed (<min-length>). |
| KVD004 | During validation of field '<field name>' we found that its data type [<value data type>] is different from the expected [<expected data type>]. |
| KVD005 | During validation of field '<field name>' we found that value [<value>] is lower than the specified minimum [<min-value>] |
| KVD006 | During validation of field '<field name>' we found that value [<value>] is higher than the specified maximum [<max-value>] |
| KVD007 | During validation of field '<field name>' we found that value [<value>] is not in the list of allowed values. |
| KVD008 |
During validation of field '<field name>' we found that value [<value>] is non numeric data. |
| KVD009 |
During validation of field '<field name>' we found that value [<value>] does not start with a string. |
| KVD010 |
During validation of field '<field name>' we found that value [<value>] does not end with a string. |
| KVD011 |
During validation of field '<field name>' we found that value [<value>] starts with a string. |
| KVD012 |
During validation of field '<field name>' we found that value [<value>] ends with a string. |
| KVD013 |
During validation of field '<field name>' we found that value [<value>] is not matching the expected regular expression. |
| KVD014 |
During validation of field '<field name>' we found that value [<value>] matches a regular expression that is not allowed. |
| KVD015 |
During validation of field '<field name>' we found that value [<value>] is not null when this is not allowed |