function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jyovasjyovas 

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

clifgriffinclifgriffin

I believe the max per batch is capped at 10,000.  Have you tried splitting it up?