org.jetel.exception.JetelRuntimeException: Component [XLSDataReader:XLSDATA_READER1] finished with status ERROR.

Oracle Community | 2831007 | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    In CloverETL how to read an xlsx file with a column of "long" datatype

    Oracle Community | 2 years ago | 2831007
    org.jetel.exception.JetelRuntimeException: Component [XLSDataReader:XLSDATA_READER1] finished with status ERROR.

    Root Cause Analysis

    1. java.lang.NumberFormatException

      Incomplete parsing

      at javolution.text.TypeFormat.parseLongString()
    2. Javolution
      TypeFormat.parseLong
      1. javolution.text.TypeFormat.parseLongString(Unknown Source)
      2. javolution.text.TypeFormat.parseLong(Unknown Source)
      3. javolution.text.TypeFormat.parseLong(Unknown Source)
      4. javolution.text.TypeFormat.parseLong(Unknown Source)
      4 frames
    3. org.jetel.util
      JavolutionNumericFormatter.parseLong
      1. org.jetel.util.formatter.JavolutionNumericFormatter.parseLong(JavolutionNumericFormatter.java:74)
      1 frame
    4. org.jetel.data
      XLSParser.getNext
      1. org.jetel.data.LongDataField.fromString(LongDataField.java:462)
      2. org.jetel.data.parser.XLSXDataParser.parseNext(XLSXDataParser.java:492)
      3. org.jetel.data.parser.XLSParser.getNext(XLSParser.java:136)
      3 frames
    5. org.jetel.util
      MultiFileReader.getNext
      1. org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:432)
      1 frame
    6. org.jetel.component
      XLSReader.execute
      1. org.jetel.component.XLSReader.execute(XLSReader.java:562)
      1 frame
    7. org.jetel.graph
      Node.run
      1. org.jetel.graph.Node.run(Node.java:485)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame