You need to sign in to do that
Don't have an account?

IndexOutOfBoundsException
Hi,
We updated data loader yesterday from version 20 to 34 and now one of our command line batch jobs has stopped working. I'm unsure of the error message as I've never seen it before.
Error:
action.AbstractAction execute (AbstractAction.java:120) - Loading: upsert
2015-08-14 12:40:59,920 ERROR [upsertSiteElectricity] action.AbstractAction handleException (AbstractAction.java:204) - Exception occured during loading
java.lang.IndexOutOfBoundsException: Index: 5, Size: 5
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.salesforce.dataloader.dao.csv.CSVFileReader.readRow(CSVFileReader.java:191)
at com.salesforce.dataloader.util.DAORowUtil.calculateTotalRows(DAORowUtil.java:67)
at com.salesforce.dataloader.dao.csv.CSVFileReader.getTotalRows(CSVFileReader.java:218)
at com.salesforce.dataloader.action.AbstractLoadAction.initOperation(AbstractLoadAction.java:100)
at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:122)
at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:121)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:149)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
2015-08-14 12:40:59,920 ERROR [upsertSiteElectricity] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - Index: 5, Size: 5
Does anyone know how to resolve this?
Any help is much appreciated.
Hi njo103,
Yeah it turned out there was whitespace somewhere in one of the fields so we used trim on all columns and rows to clear any whitespace and then loaded in the file.
It worked ok then
All Answers
Am having the same issue. Did you find a solution?
Thanks.
Hi njo103,
Yeah it turned out there was whitespace somewhere in one of the fields so we used trim on all columns and rows to clear any whitespace and then loaded in the file.
It worked ok then