Hi, I have 1.5 million Account record to be pumped into SFDC. For this I am using BULK API option. BUt everytime I am executing the script although the loading is working properly there is no success and error file is being increased. Its being generated with the column headers and nothing is being written. But if i use sfdc.usebulkAPI = false in process-conf.xml everything is working fine.

PFA the process-conf.xml code below. Everything works perfectly if I remove the BULK option. I checked with a input csv file having 10 records with BULK API true, it worked successfully. But in  case of data base its not generating the success and error files.

Any Idea ??

<!-- This bean upserts data from End Customer Account staging table to SFDC Account object.-->

<bean id="upsertEndCustAcct" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false" lazy-init="default" autowire="default" dependency-check="default">

   <description>Upsert End Customer Account</description> 

   <property name="name" value="upsertEndCustAcct" /> 

   <property name="configOverrideMap">

   <map>

   <entry key="sfdc.debugMessages" value="false" /> 

   <entry key="sfdc.debugMessagesFile" value="D:\allAttachment\ACCOUNT_UPSERT\logs\debug.txt" /> 

<entry key="sfdc.endpoint" value="https://test.salesforce.com"/>

       <entry key="sfdc.timeoutSecs" value="600" /> 

   <entry key="sfdc.loadBatchSize" value="5000" /> 

   <entry key="sfdc.entity" value="Account" /> 

<entry key="process.operation" value="upsert" /> 

<entry key="process.mappingFile" value="D:\allAttachment\ACCOUNT_UPSERT\mapping\end_cust_acct_mapping.sdl" /> 

<entry key="sfdc.externalIdField" value="Account_CSN__c"/>

<entry key="dataAccess.writeBatchSize" value="500" />

        <entry key="sfdc.bulkApiCheckStatusInterval" value="5000"/>

<entry key="sfdc.useBulkApi" value="true"/> 

<entry key="sfdc.bulkApiSerialMode" value="true"/>

<entry key="dataAccess.type" value="databaseRead" />

<entry key="dataAccess.name" value="upsertEndCustAcct" />  

   <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800" />

<entry key="process.enableExtractStatusOutput" value="True" />  

   <entry key="process.lastRunOutputDirectory" value="D:\allAttachment\ACCOUNT_UPSERT\logs"/>

   <entry key="process.statusOutputDirectory" value="D:\allAttachment\ACCOUNT_UPSERT\logs"/>

   <entry key="process.outputSuccess" value="D:\allAttachment\ACCOUNT_UPSERT\logs\end_cust_account_success.csv"/> 

   <entry key="process.outputError" value="D:\allAttachment\ACCOUNT_UPSERT\logs\end_cust_account_error.csv"/> 

   </map>

   </property>

</bean>

Regards

Indranil