Messages and limitations of the CSV connector
Message code list of CSV category
The following message codes correspond to errors that occur in CSV Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
Exception messages of CSV category
|
Exception name |
Cause |
Solution |
|---|---|---|
|
FileAlreadyExistedException |
The file specified in File already exists. |
Change the file name of File, or select Overwrite of Write settings. |
|
FileIsDirectoryException |
The path entered in File is a directory. |
Enter a file path in File. |
|
FileIsLockedException |
The file specified in File is locked. |
Unlock it from Explorer or CLI. |
|
InputDataNotFoundException |
Input data isn't specified. |
Specify Input data or draw data flow. |
|
InvalidPropertyConfigurationException <Property name> is not specified. |
<Property name> isn't specified. |
Specify <property name>. |
|
InvalidPropertyConfigurationException Invalid delimiter is specified. |
Invalid character is entered in Delimiter. |
Enter the valid character in Delimiter. |
|
java.io.FileNotFoundException |
The file specified in File doesn't exist. |
Check File. |
|
java.io.FileNotFoundException Some other process is using the file. |
The file specified in File is being used by another process. |
Make sure that it's not being used by another process. |
|
java.io.UnsupportedEncodingException |
Unsupported encoding is specified in Encoding. |
Specify an encoding that is supported in Java SE Runtime Environment 8. = Remarks =
For details, refer to "Supported Encodings" (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html). |
Limitations of CSV category
Specification limits
-
CSV Connector operates based on the following rules:
-
Data are separated by the specified delimiter character.
-
When the data contains delimiter characters, " (double quotation marks), or newline characters, make sure to put " at the beginning and the end of data.
When " is included in data, put two consecutive marks, like this: ""
Example: When delimiter character is , (comma)
Data value
Notation
1,000 yen
"1,000 yen"
AB(newline)CD
"AB(newline)CD"
He says "I'm fine"
"He says ""I'm fine"""
-
-
When the data size of a single column in the file to be read is large, OutOfMemoryError may occur.
In that case, decrease the data size of a single column.
Specification limits
-
CSV Connector operates based on the following rules:
-
Data are separated by the specified delimiter character (comma or tab).
-
Due to the CSV specifications, when the data contains delimiter characters, " (double quotation marks), or newline characters, " must be present at the beginning and the end of data.
When " is included in data, there must be two consecutive marks, like this: "" This is called "quoting."
= Remarks =Quoting is done automatically in the Write CSV File operation.
Example: When delimiter character is , (comma)
Value for input data
Output data
1,000 yen
"1,000 yen"
AB(newline)CD
"AB(newline)CD"
He says "I'm fine"
"He says ""I'm fine"""
-
-
Null is written as empty string.
-
When components supporting Multi-Thread Processing is specified in Input data, Multi-Thread Processing is performed. In that case, the order of result data isn't ensured.