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
SFDave_126SFDave_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__c
The 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 more
The 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.
 
RKSalesforceRKSalesforce
Hello SFDave,

Please check your Employee Object API Name once again. Try changing your query like below:
Select Id, OwnerId, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastViewedDate, LastReferencedDate FROM Employee__c 

Select Id, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp FROM Allocation__c
Please mark as best answer if helped.

Regards,
Ramakant

 
SFDave_126SFDave_126
Hi Ramakant,

I confirmed the Employee Object API Name is correct. Here's a screenshot of it in the Data Loader WebUI:

User-added image

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.
SFDave_126SFDave_126
It appears this issue centers around Salesforce's Custom Objects not being readable by my test account.