Get Data Check Error Details

Operation Name

Function Overview

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

Properties

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 the name to show on the script canvas.

Data processing method

Item name	Required/Optional	Use of variables	Description	Remarks
Data processing method	Required	Not available	Select data processing method. [Apply script settings]: (default) Apply the mass data processing settings of the script property to the adapter. [Do not perform mass data processing]: Mass data processing will not be performed. [Perform mass data processing]: Mass data processing will be performed.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Schema

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>

When a certain row and column of the input data causes multiple errors, each error information will be output.

Loading schema in Mapper

Schema is loaded automatically.

Refer to “Edit Schema” for more details.

Mass Data Processing

Mass Data Processing is supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name	Description	Remarks
count	The number of all the detailed error information got is stored.	Default value is 0.
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_code	When an error occurs, the corresponding message code is stored.	Default value is null.
message_level	When an error occurs, the corresponding message code's severity is stored.	Default value is null.
error_type	When an error occurs, the error type is stored.	Default value is null. The error type will be in the following format. Example: “java.io.FileNotFoundException” The contents that will be stored may vary depending on DataSpider Servista versions.
error_message	When an error occurs, the error message is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace	When an error occurs, the error's trace information is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Major Exceptions

Exception name	Cause	Solution
ErrorInfoNotFoundException	Cannot get the detailed error information.	Execute 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.
When multiple Data Check operations are placed in the script, the detailed error information you get 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 will not be taken over to threads created in Thread operations or to a different Transaction.