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

Data Loader 20.0 - Exception when BulkAPI enabled
I am trying to use DataLoader to upload records using UPSERT operation and my CSV file has 400,000 records .uploading into Custom object . What is the typical configration I should have in config.properties ?
Currently I have
sfdc.useBulkApi=true
sfdc.loadBatchSize=2000
sfdc.bulkApiSerialMode=true
and I have changed the heap size in process.bat as
..\_jvm\bin\java.exe -Xms1024M -Xmx1024M
But after 20,000 records I get below exception . Any help will be appreciated .
Thanks,
-John
at com.sforce.async.RestConnection.createBatchFromStreamImpl(RestConnect
ion.java:153)
at com.sforce.async.RestConnection.createBatchFromStream(RestConnection.
java:125)
at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.createBatch(
BulkLoadVisitor.java:267)
at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.doOneBatch(B
ulkLoadVisitor.java:147)
at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.createBatche
s(BulkLoadVisitor.java:129)
at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.loadBatch(Bu
lkLoadVisitor.java:90)
... 7 more
Caused by: com.sforce.ws.ConnectionException: unable to find end tag at: START_
TAG seen ..."http://www.force.com/2009/06/asyncapi/dataload">\n <exceptionCode>.
.. @3:17
at com.sforce.ws.bind.TypeMapper.consumeEndTag(TypeMapper.java:399)
at com.sforce.async.BatchInfo.load(BatchInfo.java:284)
at com.sforce.async.BatchRequest.loadBatchInfo(BatchRequest.java:77)
at com.sforce.async.RestConnection.createBatchFromStreamImpl(RestConnect
ion.java:147)
... 12 more
2010-12-21 16:06:06,930 ERROR [main] progress.NihilistProgressAdapter doneError
(NihilistProgressAdapter.java:56) - Failed to create batch
I believe the max per batch is capped at 10,000. Have you tried splitting it up?