Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error reading Excel file

Jackie_CNov 27 2012 — edited Nov 28 2012

Hi,

I'm trying to read in an XSLX using the XLSDataReader and am having some issues.
I've narrowed down the issue to 3 adjacent columns in my file and if I map any of these three columns in the reader component, I get an error message:
>
ERROR [WatchDog] - Node XLS_GROUPS finished with status: ERROR caused by: Cannot get a text value from a error cell
ERROR [WatchDog] - Node XLS_GROUPS error details:
java.lang.IllegalStateException: Cannot get a text value from a error cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:294)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:246)
at org.jetel.data.parser.XLSXDataParser.parseNext(XLSXDataParser.java:487)
at org.jetel.data.parser.XLSParser.getNext(XLSParser.java:132)
at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:415)
at org.jetel.component.XLSReader.execute(XLSReader.java:606)
at org.jetel.graph.Node.run(Node.java:414)
at java.lang.Thread.run(Thread.java:619)
WARN [exNode_0_1306204897681_TRASH0] - TRASH0thread interrupted, it will interrupt child threads
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Thread.join(Thread.java:1151)
at org.jetel.component.Trash.executeWithoutWriter(Trash.java:278)
at org.jetel.component.Trash.execute(Trash.java:241)
at org.jetel.graph.Node.run(Node.java:414)
at java.lang.Thread.run(Thread.java:619)
ERROR [TRASH0_0.InputThread#0] - 34: thread forcibly aborted
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:485)
at org.jetel.graph.DirectEdge.fillReadBuffer(DirectEdge.java:216)
at org.jetel.graph.DirectEdge.readRecordDirect(DirectEdge.java:182)
at org.jetel.graph.Edge.readRecordDirect(Edge.java:363)
at org.jetel.component.Trash$InputReader.run(Trash.java:471)
>
I have no idea what an "error cell" is but it's a simple text column in the spreadsheet.

Any thoughts?

Thanks in advance!
Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2012

Added on Nov 27 2012

#business-intelligence-applications, #endeca-information-discovery, #information-discovery

2 comments

1,819 views