Error loading simple product master file

User: "saikat_nandi"
New Altair Community Member
Updated by Jocelyn
I will appreciate help on the following error trying to read a simple txt file using ReadCSV operator.

I am trying to load a simple product file with 75,0000 records. Each record has filelds like Product ID, Category, Sub-Category, Product Description etc. no more than 20 attributes.

I am getting an error saying the following:

Apr 30, 2010 12:38:46 AM SEVERE: Process failed: operator cannot be executed (18). Check the log messages...
Apr 30, 2010 12:38:46 AM SEVERE: Here:          Process[1] (Process)
          subprocess 'Main Process'
      ==>  +- Read CSV[1] (Read CSV)
Apr 30, 2010 12:38:46 AM SEVERE: java.lang.ArrayIndexOutOfBoundsException: 18

XML version of the process is given below.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.0">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" expanded="true" name="Process">
    <process expanded="true" height="100" width="145">
      <operator activated="true" class="read_csv" expanded="true" height="60" name="Read CSV" width="90" x="45" y="30">
        <parameter key="file_name" value="C:\My Documents\ITEM_MASTER.TXT"/>
        <parameter key="trim_lines" value="true"/>
        <parameter key="use_first_row_as_attribute_names" value="false"/>
        <parameter key="parse_numbers" value="false"/>
      </operator>
      <connect from_op="Read CSV" from_port="output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="18"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

Thanks for your help.
Saikat

Find more posts tagged with