XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Discussion on developing CloverETL engine, transformation components etc.

Posts: 3
Joined: Mon Feb 16, 2015 9:18 am

XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Postby kreddy » Mon Jul 10, 2017 9:19 pm

Can any one help me the root cause of below issues.We are seeing this issue more often.If we restart the server(Weblogic) or resubmit the graph it works.

ETL version : 4.3.0
Server : Weblogic

22:33:46,338 ERROR WatchDog_0 - 1594 - Component [Write Results:WRITE_RESULTS2] finished with status ERROR. (In0: 10313 recs)
22:33:46,339 ERROR WatchDog_0 - 1594 - Error details:
org.jetel.exception.JetelRuntimeException: Component [Write Results:WRITE_RESULTS2] finished with status ERROR. (In0: 10313 recs)
at org.jetel.graph.Node.createNodeException(Node.java:636)
at org.jetel.graph.Node.run(Node.java:603)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at jxl.biff.StringHelper.getBytes(StringHelper.java:127)
at jxl.write.biff.WriteAccessRecord.<init>(WriteAccessRecord.java:59)
at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:726)
at org.jetel.data.formatter.JExcelXLSDataFormatter.flush(JExcelXLSDataFormatter.java:168)
at org.jetel.data.formatter.XLSFormatter.finish(XLSFormatter.java:317)
at org.jetel.util.TargetFile.finish(TargetFile.java:385)
at org.jetel.util.MultiFileWriter.finish(MultiFileWriter.java:705)
at org.jetel.component.XLSWriter.execute(XLSWriter.java:590)
at org.jetel.graph.Node.run(Node.java:563)
... 1 more

22:33:46,385 ERROR WatchDog_0 - 1594 - !!! Phase finished with error - stopping graph run !!!
22:33:46,426 ERROR - 1594 -
------------------------------------ Error details -------------------------------------
Component [Write Results:WRITE_RESULTS2] finished with status ERROR. (In0: 10313 recs)
22:33:46,426 ERROR - 1594 - Execution of graph failed !

Posts: 20
Joined: Wed May 03, 2017 12:10 pm

Re: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Postby bartonv » Tue Jul 18, 2017 11:43 am

Hi kreddy,
the ArrayIndexOutOfBoundsException error message is typically thrown to indicate that an array has been accessed with an illegal index. The index could be either negative or greater than or equal to the size of the array. Given the fact that XLSWriter is a deprecated component in the 4.3 version I would suggest replacing it with its successor – the SpreadSheetWriter component.
If this does not help, the graph will require a closer inspection from our end. In such case, please, provide us with the graph in question including some sample data?
Vladimir Barton
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support