XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

CloverDX Platform
1

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.(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 !

2

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,

3

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,