In this section: |
The error instruction describes how to process certain errors with regards to data records and processing. An error instruction consists of an error type to handle and an action to take if such error occurs. For each error type some error-handling action must be defined.
Name |
Type |
Required |
Description |
---|---|---|---|
Data Strategy |
Error Fix Type |
Yes |
Specifies what action to take when this instruction is invoked. |
Error Type |
Error Type |
Yes |
The error type to handle. Error types vary from step to step, each step may define its own error types that must be handled. For each error type there must be an error strategy defined which describes how to process it. For possible error types to handle see the step's description. |
Put To Log |
Boolean |
Yes |
Defines whether to put logging information about the error in the log. |
Put To Reject |
Boolean |
Yes |
Defines whether to put the data causing the error in the 'reject file'. |
The following table shows the meaning of instructions that may be created as combinations of error types and error actions to be taken:
Error State |
Action |
Description |
---|---|---|
any |
SKIP_LINE |
will cause skipping of the line that causes the error from processing |
any |
STOP |
causes data loading interrupt |
SHORT_LINE |
NULL_VALUE |
null entry is written to the output |
READ_POSSIBLE |
values possible to parse will be written to the output, the rest will have null values | |
UNPARSABLE_FIELD |
NULL_VALUE |
null will be written to the output field |
READ_POSSIBLE |
null will be written to the output field | |
INVALID_DATE |
NULL_VALUE |
null will be written to the output field |
READ_POSSIBLE |
the result of processing with lenient=on is written to the result | |
PROCESSING_ERROR |
NULL_VALUE |
null values are written to the output field |
READ_POSSIBLE |
values that have been parsed before the error occurred are written to the output, for the rest of values nulls are written to the output |
Any entries that cause an error can be written to a log file and/or excluded from further processing. By default the errorHandlingStrategy is set up as follows:
Error |
Log |
Reject |
Fix Type |
---|---|---|---|
PROCESSING_ERROR |
X |
STOP | |
INVALID_DATE |
X |
READ_POSSIBLE | |
UNPARSABLE_FIELD |
X |
NULL_VALUE | |
SHORT_LINE |
X |
X |
READ_POSSIBLE |
EXTRA_DATA |
X |
READ_POSSIBLE | |
LONG_LINE |
X |
X |
STOP |
iWay Software |