Retrieve Data Check Error Details

Operation Name

Receive Data Check Error Details

Function Overview

Retrieves the input data which did not match check conditions in the Data Check Operation performed before this operation.

Properties

For information about using 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 a data processing method.
  • [Use script settings]:(default)
    Apply mass data processing settings of script property to adapter.
  • [Does not perform mass data processing]:
    Mass data processing is not performed.
  • [Performs 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 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>Input data value</column>
    <column>Cause of mismatch</column>
  </row>
  <row>
    :
  </row>
</table>
If the input data of the same row number and column number did not match the data check conditions due to multiple causes, the record will be output repeatedly as many times as the count of the causes.

Loading Schema on Mapper

Schema is loaded automatically.
For details, refer to "Edit Schema".

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name Description Remarks
count Stores the number of received data.
  • The value defaults to 0.
message_category Stores the category of message code corresponding to the occurred error.
  • The value defaults to null.
message_code Stores the code of message code corresponding to the occurred error.
  • The value defaults to null.
message_level Stores the severity of message code corresponding to the occurred error.
  • The value defaults to null.
error_type Returns the error type when error occurred.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Ex: java.io.FileNotFoundException
  • The message may vary depending on the DataSpider Servista version.
error_message Returns the error message when error occurred.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version.
error_trace Returns the trace information when error occurred.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version or the client application used.

Main Exceptions

Exception name Cause Solution
ErrorInfoNotFoundException Detailed information of the error was not found. Execute data check operation before this operation.

Specification Limits