Failed to upsert Contact to Salesforce [ Edited ]

[Gugu]

Hi,

I am first time user and was trying to upsert one single contact to Salesforce. This error showed up:

2012-11-09 15:27:25,554 ERROR [csvUpsertContacts] action.AbstractAction handleException (AbstractAction.java:199) - Exception occured during loading
java.lang.IllegalArgumentException: Invalid property name 'ISDELETED'
	at org.apache.commons.beanutils.BasicDynaBean.getDynaProperty(BasicDynaBean.java:400)
	at org.apache.commons.beanutils.BasicDynaBean.get(BasicDynaBean.java:151)
	at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.writeRow(BulkLoadVisitor.java:182)
	at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.doOneBatch(BulkLoadVisitor.java:161)
	at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.createBatches(BulkLoadVisitor.java:147)
	at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.loadBatch(BulkLoadVisitor.java:114)
	at com.salesforce.dataloader.action.visitor.DAOLoadVisitor.visit(DAOLoadVisitor.java:104)
	at com.salesforce.dataloader.action.AbstractLoadAction.visit(AbstractLoadAction.java:79)
	at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:124)
	at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:120)
	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)
2012-11-09 15:27:25,554 ERROR [csvUpsertContacts] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - Invalid property name 'ISDELET

This is my csvUpsert process:

 <bean id="csvInsertContacts"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>csv Upsert job gets the Contect record updates from a CSV file and uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="csvUpsertContacts"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/> 
                <entry key="sfdc.username" value="mabuza@bus.msu.edu"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="51826db7e9fde6db5146354b8f9f9d42"/>
                <entry key="process.encryptionKeyFile" value="C:\Users\vop\AppData\Roaming\salesforce.com\Data Loader 25.0.2\key.txt"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="1"/>
                <entry key="sfdc.entity" value="Contact"/>
                <entry key="process.operation" value="insert"/>
                <entry key="process.mappingFile" value="C:\Users\vop\AppData\Roaming\salesforce.com\Data Loader 25.0.2\contact.sdl"/>
                <entry key="sfdc.externalIdField" value="APPLICANT_CLIENT_ID__C" />
                <entry key="process.outputSuccess" value="C:\Users\vop\AppData\Roaming\salesforce.com\Data Loader 25.0.2\successContacts.csv"/>
                <entry key="process.outputError" value="C:\Users\vop\AppData\Roaming\salesforce.com\Data Loader 25.0.2\errorContacts.csv"/>
                <entry key="dataAccess.name" value="C:\Users\vop\AppData\Roaming\salesforce.com\Data Loader 25.0.2\onerecord.csv"/>
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2006-12-01T00:00:00.000-0800"/>
            </map>
        </property>
    </bean>

 This is my config.properties:

 sfdc.password=01a0ba150ecd493f6945044ec328bf83
sfdc.username=mabuza@bus.msu.edu
dataAccess.writeBatchSize=500
process.operation=insert
process.loadRowToStartAt=0
dataAccess.readBatchSize=200
sfdc.useBulkApi=true
sfdc.entity=Contact
process.statusOutputDirectory=C\:\\Users\\vop\\AppData\\Roaming\\salesforce.com\\status
sfdc.resetUrlOnLogin=true
process.useEuropeanDates=false
sfdc.minRetrySleepSecs=2
sfdc.loadBatchSize=2000
sfdc.bulkApiSerialMode=true
sfdc.connectionTimeoutSecs=60
sfdc.truncateFields=false
process.enableLastRunOutput=true
sfdc.insertNulls=false
dataAccess.type=csvRead
sfdc.timeoutSecs=540
process.mappingFile=C\:\\Users\\vop\\AppData\\Roaming\\salesforce.com\\Data Loader 25.0.2\\test.sdl
sfdc.timezone=America/New_York
sfdc.bulkApiZipContent=false
process.outputError=C\:\\Users\\vop\\AppData\\Roaming\\salesforce.com\\status\\error102212115513909.csv
sfdc.maxRetries=3
dataAccess.writeUTF8=false
sfdc.enableRetries=true
sfdc.extractionSOQL=
process.outputSuccess=C\:\\Users\\vop\\AppData\\Roaming\\salesforce.com\\status\\success102212115513909.csv
sfdc.endpoint=https\://login.salesforce.com
sfdc.bulkApiCheckStatusInterval=5000
dataAccess.name=C\:\\Users\\vop\\AppData\\Roaming\\salesforce.com\\Data Loader 25.0.2\\testrecord.csv
process.enableExtractStatusOutput=false
sfdcInternal.isSessionIdLogin=false
sfdc.wireOutput=false
dataAccess.readUTF8=false
sfdcInternal=false
sfdc.extractionRequestSize=500
sfdc.noCompression=false

 I have been struggling with this for weeks. Please let me know what could be the problem with my settings.

Thanks.

[SFF]

The ISDELETED field is not updateable by the end user ...

[Gugu]

Hi,

Thanks for the response. I removed the ISDELETED field in the .csv and mapping. Now the error is:

java.lang.IllegalArgumentException: Invalid property name 'ACCOUNTID'
    at org.apache.commons.beanutils.BasicDynaBean.getDynaProperty(BasicDynaBean.java:400)
    at org.apache.commons.beanutils.BasicDynaBean.get(BasicDynaBean.java:151)
    at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.writeRow(BulkLoadVisitor.java:182)
    at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.doOneBatch(BulkLoadVisitor.java:161)
    at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.createBatches(BulkLoadVisitor.java:147)
    at com.salesforce.dataloader.action.visitor.BulkLoadVisitor.loadBatch(BulkLoadVisitor.java:114)
    at com.salesforce.dataloader.action.visitor.DAOLoadVisitor.visit(DAOLoadVisitor.java:104)
    at com.salesforce.dataloader.action.AbstractLoadAction.visit(AbstractLoadAction.java:79)
    at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:124)
    at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:120)
    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)
2012-11-16 10:57:34,343 ERROR [csvUpsertContacts] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - Invalid property name 'ACCOUNTID'

Look like it will happen for the first field in the .csv file no matter what the field is. Please let me know what else could I try. Thanks a lot!