You need to sign in to do that
Don't have an account?
SFDave_126
DataLoader script issue with SOQL tables ending in '__c'
I'm continuing to receive errors in all of my SOQL tables that end with a '__c' suffix. here are a few examples of what I'm referring to:
Select Id, OwnerId, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastViewedDate, LastReferencedDate FROM Employees__c Select Id, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp FROM Allocation__cThe error messages I receive are the same for both tables:
2018-03-08 10:58:34,200 INFO [main] controller.Controller initLog (Controller.java:396) - Using built-in logging configuration, no log-conf.xml in C:\Program Files (x86)\salesforce.com\Data Loader\bin\log-conf.xml 2018-03-08 10:58:34,216 INFO [main] controller.Controller initLog (Controller.java:398) - The log has been initialized 2018-03-08 10:58:34,231 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:104) - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Data Loader\conf\process-conf.xml 2018-03-08 10:58:34,356 INFO [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@1a8dfcc: startup date [Thu Mar 08 10:58:34 EST 2018]; root of context hierarchy 2018-03-08 10:58:34,513 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Data Loader\conf\process-conf.xml] 2018-03-08 10:58:35,638 INFO [main] support.DefaultListableBeanFactory preInstantiateSingletons (DefaultListableBeanFactory.java:557) - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@15435c: defining beans [csvAccountExtractProcess,csvOpportunityExtractProcess,csvContactExtractProcess,csvLeadExtractProcess,csvRevenueExtractProcess,csvTaskExtractProcess,csvEventExtractProcess,csvProjectExtractProcess,csvGrantsProjectExtractProcess,csvResearcherExtractProcess,csvEmployeesExtractProcess,csvAllocationExtractProcess]; root of factory hierarchy 2018-03-08 10:58:35,716 INFO [csvEmployeesExtract] controller.Controller initConfig (Controller.java:334) - config dir created at C:\Program Files (x86)\salesforce.com\Data Loader\conf 2018-03-08 10:58:35,747 INFO [csvEmployeesExtract] controller.Controller initConfig (Controller.java:362) - The controller config has been initialized 2018-03-08 10:58:35,747 INFO [csvEmployeesExtract] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine 2018-03-08 10:58:35,747 INFO [csvEmployeesExtract] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters 2018-03-08 10:58:36,216 INFO [csvEmployeesExtract] config.LastRun load (LastRun.java:96) - Last run info will be saved in file: C:\Program Files (x86)\salesforce.com\Data Loader\conf\csvEmployeesExtract_lastRun.properties 2018-03-08 10:58:36,263 INFO [csvEmployeesExtract] process.ProcessRunner run (ProcessRunner.java:127) - Logging in to: https://na1.salesforce.com 2018-03-08 10:58:36,544 INFO [csvEmployeesExtract] client.PartnerClient login (PartnerClient.java:479) - Beginning Partner Salesforce login .... 2018-03-08 10:58:36,606 INFO [csvEmployeesExtract] client.PartnerClient loginInternal (PartnerClient.java:523) - Salesforce login to https://na1.salesforce.com/services/Soap/u/41.0 as user test_account@somecompany.com 2018-03-08 10:58:37,481 INFO [csvEmployeesExtract] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: C:\Users\test_user\Desktop\salesforce_backup\sf_employees.csv of type: csvWrite 2018-03-08 10:58:37,481 INFO [csvEmployeesExtract] process.ProcessRunner run (ProcessRunner.java:132) - Checking the data access object connection 2018-03-08 10:58:37,497 INFO [csvEmployeesExtract] process.ProcessRunner run (ProcessRunner.java:137) - Setting field types 2018-03-08 10:58:37,841 ERROR [csvEmployeesExtract] client.PartnerClient runOperation (PartnerClient.java:332) - Error while calling web service operation: describeSObject, error was: [InvalidSObjectFault [ApiQueryFault [ApiFault exceptionCode='INVALID_TYPE' exceptionMessage='sObject type 'Employees' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.' extendedErrorDetails='{[0]}' ] row='-1' column='-1' ] ] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:673) at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:556) at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:236) at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:210) at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:156) at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99) at com.sforce.soap.partner.PartnerConnection.describeSObject(PartnerConnection.java:1422) at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:185) at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:177) at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328) at com.salesforce.dataloader.client.PartnerClient.describeSObject(PartnerClient.java:726) at com.salesforce.dataloader.client.PartnerClient.setFieldTypes(PartnerClient.java:679) at com.salesforce.dataloader.controller.Controller.setFieldTypes(Controller.java:130) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:138) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253) 2018-03-08 10:58:37,856 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process csvEmployeesExtract java.lang.RuntimeException: sObject type 'Employees' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:160) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253) Caused by: [InvalidSObjectFault [ApiQueryFault [ApiFault exceptionCode='INVALID_TYPE' exceptionMessage='sObject type 'Employees' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.' extendedErrorDetails='{[0]}' ] row='-1' column='-1' ] ] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:673) at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:556) at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:236) at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:210) at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:156) at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99) at com.sforce.soap.partner.PartnerConnection.describeSObject(PartnerConnection.java:1422) at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:185) at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:177) at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328) at com.salesforce.dataloader.client.PartnerClient.describeSObject(PartnerClient.java:726) at com.salesforce.dataloader.client.PartnerClient.setFieldTypes(PartnerClient.java:679) at com.salesforce.dataloader.controller.Controller.setFieldTypes(Controller.java:130) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:138) ... 2 moreThe output doesn't provide a clear picture of where the error message is, however it does point to some invalid tables. Below is a redacted example of my process-conf.xml file for the Allocation bean:
<bean id="csvAllocationExtractProcess" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false"> <description>csvAllocationExtract job."</description> <property name="name" value="csvAllocationExtract"/> <property name="configOverrideMap"> <map> <entry key="sfdc.debugMessages" value="false"/> <entry key="sfdc.debugMessagesFile" value="C:\Users\test_user\Desktop\salesforce_backup\sfdcSoapTrace.log"/> <entry key="sfdc.endpoint" value="https://na1.salesforce.com"/> <entry key="sfdc.username" value=test_account@somecompany.com"/> <entry key="sfdc.password" value="somepassword"/> <entry key="process.encryptionKeyFile" value="C:\Program Files (x86)\salesforce.com\Data Loader\akeyfile.txt"/> <entry key="sfdc.timeoutSecs" value="600"/> <entry key="sfdc.loadBatchSize" value="200"/> <entry key="sfdc.entity" value="Allocation"/> <entry key="sfdc.extractionRequestSize" value="500"/> <entry key="sfdc.extractionSOQL" value="Select Id, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp FROM Allocation__c"/> <entry key="process.operation" value="extract"/> <entry key="dataAccess.type" value="csvWrite"/> <entry key="dataAccess.name" value="C:\Users\test_user\Desktop\salesforce_backup\sf_allocation.csv"/> </map> </property> </bean>Any ideas where the issue is here? All of my other SOQL tables without the '__c' suffix work fine without issue.
Please check your Employee Object API Name once again. Try changing your query like below: Please mark as best answer if helped.
Regards,
Ramakant
I confirmed the Employee Object API Name is correct. Here's a screenshot of it in the Data Loader WebUI:
I also wanted to mention I confirmed the SOQL table field names are correct and match what is present in my organization's Enterprise WSDL schema as referenced here (https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_quickstart_get_WSDLs.htm). I also can pull the same 'Employees__c' table from the WebUI with no issues either.