+ Start a Discussion
RadDude89RadDude89 

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.

Best Answer chosen by RadDude89
RadDude89RadDude89

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

njo103njo103
Hello,

Am having the same issue.  Did you find a solution?

Thanks.
RadDude89RadDude89

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

This was selected as the best answer