You need to sign in to do that
Don't have an account?
java.lang.NullPointerException using CLI Data loader (v21.0 and later)
Hi,
We have been facing an issue during CLI Data Load extract with Data Loader Version 21.0. The process that we are executing is to extract data from Salesforce and insert the data to a table in Oracle. The issue happens when a lookup field is being referenced in the SOQL query against which no data is returned.
After doing some research we saw that this issue does not happen if we use Data Loader v17.0 (also mentioned @ https://code.google.com/p/dataloadercliq/issues/detail?id=59). However would like to understand if this is a bug that has not been taken care in the recent versions of the data loader?
Any help/pointer on this is really appreciated.
SDL mapping:
MySubject__r.Name=MySubject
database-conf:
<entry key="MySubject__r.Name" value="java.lang.String"/>
Exception log:
2013-12-11 10:24:17,573 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:211) - Unable to run process accountReplicate
java.lang.RuntimeException: java.lang.NullPointerException
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:136)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:74)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:226)
Caused by: java.lang.NullPointerException
at com.salesforce.dataloader.mapping.SOQLMapper.getReferenceField(SOQLMapper.java:222)
at com.salesforce.dataloader.mapping.SOQLMapper.evalSfdcField(SOQLMapper.java:191)
at com.salesforce.dataloader.mapping.SOQLMapper.evalSfdcField(SOQLMapper.java:185)
at com.salesforce.dataloader.mapping.SOQLMapper.normalizeSoql(SOQLMapper.java:169)
at com.salesforce.dataloader.mapping.SOQLMapper.addSoqlFieldMapping(SOQLMapper.java:165)
at com.salesforce.dataloader.mapping.SOQLMapper.putPropertyEntry(SOQLMapper.java:98)
at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:120)
at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:115)
at com.salesforce.dataloader.mapping.Mapper.<init>(Mapper.java:76)
at com.salesforce.dataloader.mapping.SOQLMapper.<init>(SOQLMapper.java:57)
at com.salesforce.dataloader.controller.Controller.createMapper(Controller.java:179)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
... 2 more
-1
FAIL
Thanks,
Jayant
Hello Jayant,
I do not see anywhere if this has been reported. This App's provider is Salesforce labs, so please post this on : https://success.salesforce.com/answers
Here you will be clarified about this issue in this app.
Hi Vinita,
I did check https://success.salesforce.com/answers but did not find an option to directly post a question. Is it through submitting a case?
Hi Jayant,
There is no specific section for this, you can post it in "Additional Products" section.
URL: https://success.salesforce.com/answers#!/feedtype=POPULAR&dc=Additional_Products&criteria=BESTANSWERS
You can not post question deirectly, you need to login first. At top right you will see a login button, use salesforce login credentials.
This is similar to the issue mentioned here - http://boards.developerforce.com/t5/General-Development/Data-Loader-Error-getting-value-for-SQL-parameter/td-p/40717/page/2 where this fails if the value for the related sdl entry is not present in SFDC