XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Discussion on developing CloverETL engine, transformation components etc.

kreddy
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

Hi,
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)
java.lang.ArrayIndexOutOfBoundsException
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)
java.lang.ArrayIndexOutOfBoundsException
----------------------------------------------------------------------------------------
22:33:46,426 ERROR - 1594 - Execution of graph failed !

bartonv
Posts: 24
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?
Regards,
---
Vladimir Barton
CloverCARE Support
CloverETL | Rapid Data Integration

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

bartonv
Posts: 24
Joined: Wed May 03, 2017 12:10 pm

Re: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Postby bartonv » Tue Sep 26, 2017 2:18 pm

Hello kreddy,
there might be another reason for the issue to occur non-deterministicly. The error message that you reported has been seen in situations where a JXL library version newer than 2.6.9 is used when writing to Excel. The JXL is a library of JExcelAPI, which is an open source Java API that enables reading, writing, and modifying Excel spreadsheets dynamically. To confirm that the issue you have been encountering is actually caused by the newer version of the JXL library, please run the attached graph and provide us with the run log from that graph. We will then take it from here.
Regards,
Attachments
JXL.zip
(4.31 KiB) Downloaded 1 time
---
Vladimir Barton
CloverCARE Support
CloverETL | Rapid Data Integration

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