Official |[Processing] Get Data Check Error Details

Operation name

Get Data Check Error Details

Function overview

Gets detailed information about the input data that caused an error in the Data Check executed before.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Data processing method

Item name	Required/Optional	Use of variables	Description	Remarks
Data processing method	Required	Not available	Select a data processing method. Apply script settings (Default) The setting for mass data processing in the script properties is applied to the connector. Do not perform mass data processing Mass data processing isn't performed. Perform mass data processing Mass data processing is performed.

Item name

Required/Optional

Use of variables

Description

Remarks

Data processing method

Required

Not available

Select a data processing method.

Apply script settings

(Default)

The setting for mass data processing in the script properties is applied to the connector.

Do not perform mass data processing

Mass data processing isn't performed.

Perform mass data processing

Mass data processing is performed.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

None.

Output schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>row number</column>
    <column>column number</column>
    <column>value of input data</column>
    <column>cause of mismatch</column>
  </row>
  <row>
    :
  </row>
</table>

= Remarks =

When the input data of a single row number and column number causes multiple errors, a record of error information will be output.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Mass data processing

Mass data processing is supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
count	The total number of records of detailed error information obtained is stored.	The default value is 0.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Exception messages

Exception name	Cause	Solution
ErrorInfoNotFoundException	Can't get the detailed error information.	Execute the Data Check operation before this operation.

Specification limits

The detailed error information you can get with this operation is the result of the Data Check operation that was executed right before this operation.

When multiple Data Check operations are placed in the script, the detailed error information you get with this operation will be the result of the Data Check operation that was executed lastly.
The detailed error information will be taken over in the script. However, it won't be taken over to threads created in the Thread operations or to different transactions.