Oracle to SFDC: Using command Line Data Loader

Iam trying to export data from Oracle to SFDC using Command Line .

Iam finding the below error.

ERROR [testProcess] database.DatabaseContext initConnection (DatabaseContext.java:94) - Database error encountered during connecting for database configuration: queryAccount. Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

PLease find the entire error log,process-conf,database-conf as below.

Your help is highly appreciated.

2007-08-29 09:56:40,722 INFO [main] controller.Controller initLog (Controller.java:382) - The log has been initialized
2007-08-29 09:56:40,722 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: c:\test\process-conf.xml
2007-08-29 09:56:40,784 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [c:\test_hms\process-conf.xml]
2007-08-29 09:56:40,816 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available
2007-08-29 09:56:40,816 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available
2007-08-29 09:56:40,878 INFO [testProcess] controller.Controller initConfig (Controller.java:343) - The controller config has been initialized
2007-08-29 09:56:40,894 INFO [testProcess] process.ProcessRunner run (ProcessRunner.java:102) - Initializing process engine
2007-08-29 09:56:40,894 INFO [testProcess] process.ProcessRunner run (ProcessRunner.java:105) - Loading parameters
2007-08-29 09:56:41,942 INFO [testProcess] process.ProcessRunner run (ProcessRunner.java:116) - Logging in to: https://www.salesforce.com
2007-08-29 09:56:42,741 INFO [testProcess] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: queryAccount of type: databaseRead
2007-08-29 09:56:42,741 INFO [testProcess] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [c:\test_hms\database-conf.xml]
2007-08-29 09:56:42,834 INFO [testProcess] process.ProcessRunner run (ProcessRunner.java:121) - Checking the data access object connection
2007-08-29 09:56:45,354 ERROR [testProcess] database.DatabaseContext initConnection (DatabaseContext.java:94) - Database error encountered during connecting for database configuration: queryAccount. Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:87)
    at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:79)
    at com.salesforce.lexiloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:231)
    at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.java:123)
    at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.java:230)
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
    ... 6 more
2007-08-29 09:56:45,354 FATAL [testProcess] process.ProcessRunner run (ProcessRunner.java:155) - Database error encountered during connecting for database configuration: queryAccount. Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).

process-conf.xml
==========
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="testProcess" class="com.salesforce.lexiloader.process.ProcessRunner" singleton="false">
        <description>test from database</description>
        <property name="name" value="testProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="a@gmail.com"/>
                <entry key="sfdc.password" value="xxxx"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="insert"/>
                <entry key="process.mappingFile" value="C:\testmap.sdl"/>
                <entry key="dataAccess.name" value="queryAccount"/>
                <entry key="dataAccess.type" value="databaseRead"/>
                </map>
        </property>
    </bean>

database-conf.xml
============
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>

<bean id="queryAccount"
      class="com.salesforce.lexiloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryAccountSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>

<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@my.server.com:1521:orcl"/>
    <property name="username" value="scott"/>
    <property name="password" value="tiger"/>
</bean>

<bean id="queryAccountSql"
      class="com.salesforce.lexiloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            SELECT c1,c2
            FROM test
            </value>
    </property>
    <property name="columnNames">
        <list>
            <value>c1</value>
            <value>c2</value>
            </list>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="process.lastRunDate" value="java.sql.Timestamp"/>
        </map>
    </property>
</bean>

</beans>

Thanks a lot in advance
Ajay

August 29, 2007
·
Answer
·
Like
0
·
Follow
1

Aju
Thanks everyone!

I messed up with hostname and iam good now.

Thanks again

August 29, 2007
·
Like
0
·
Dislike
0

My Own
Hi Dude,

Even I got the Same error message. while connecting to the dataloader. I have provided the database-conf.xml and Excepiton message. Please help me to fix the same. Thanks in advance.

Can you please explain me about these.
1.<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
2.<property name="url" value="jdbc:oracle:thin:@my.server.com:1521:dataBaseName"/>
3.<property name="username" value="user"/>what is the value need to be passed to this?
4.<property name="password" value="password"/> what is the value need to be passed to this?

database-conf.xml

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@my.server.com:1521:dataBaseName"/>
    <property name="username" value="user"/>
    <property name="password" value="password"/>
</bean>
<bean id="queryContactAll"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryContactAllSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="queryContact"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryContactSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="insertContact"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="insertContactSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="updateContact"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="updateContactSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="deleteContactAll"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="deleteContactAllSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="queryContactAllSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
   Select Id,Account_Id, Last_Name, First_Name, Name_
            FROM TableOwner.Contact
        </value>
    </property>
    <property name="columnNames">
        <list>
   <value>Id</value>
            <value>Account_Id</value>
            <value>Last_Name</value>
            <value>First_Name</value>
            <value>Name_</value>
        </list>
    </property>
</bean>
<bean id="queryContactSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            SELECT Id,Account_Id, Last_Name, First_Name, Name_
            FROM TableOwner.Contact
        </value>
    </property>
    <property name="columnNames">
        <list>
   <value>Id</value>
            <value>Account_Id</value>
            <value>Last_Name</value>
            <value>First_Name</value>
            <value>Name_</value>
        </list>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="process.lastRunDate" value="java.sql.Timestamp"/>
        </map>
    </property>
</bean>

<bean id="updateContactSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            update TableOwner.Contact contacts
               set contacts.Account_Id = @Account_Id@,
                   contacts.Last_Name = @Last_Name@,
                   contacts.First_Name = @First_Name@,
                   contacts.Name_ = @Name_@
            where
                   contacts.Id = @Id@
        </value>
    </property>
    <property name="sqlParams">
        <map>
   <entry key="Id"    value="java.lang.String"/>
            <entry key="Account_Id"    value="java.lang.String"/>
            <entry key="Last_Name" value="java.lang.String"/>
            <entry key="First_Name" value="java.lang.String"/>
            <entry key="Name_" value="java.lang.String"/>
        </map>
    </property>
</bean>
<bean id="insertContactSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            INSERT INTO TableOwner.Contact (
               Account_Id, Last_Name, First_Name, Name_)
            VALUES (@Account_Id@, @Last_Name@, @First_Name@, @Name_@)
        </value>
    </property>
    <property name="sqlParams">
        <map>
           <entry key="Id"    value="java.lang.String"/>
            <entry key="Account_Id"    value="java.lang.String"/>
            <entry key="Last_Name" value="java.lang.String"/>
            <entry key="First_Name" value="java.lang.String"/>
            <entry key="Name_" value="java.lang.String"/>
        </map>
    </property>
</bean>
<bean id="deleteContactAllSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            DELETE FROM TableOwner.Contact
        </value>
    </property>
</bean>
</beans>

Exception Message

C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin>process "C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config"   contactUpsertProcess
2010-08-10 09:57:17,710 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2010-08-10 09:57:17,710 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\process-conf.xml
2010-08-10 09:57:17,757 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\process-conf.xml]
2010-08-10 09:57:17,773 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available
2010-08-10 09:57:17,789 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available
2010-08-10 09:57:17,835 INFO [contactUpsertProcess] controller.Controller initConfig (Controller.java:352) - The controller config has been initialized
2010-08-10 09:57:17,851 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:93) - Initializing process engine
2010-08-10 09:57:17,851 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:96) - Loading parameters
2010-08-10 09:57:18,664 INFO [contactUpsertProcess] config.LastRun load (LastRun.java:101) - Last run info will be saved in file: C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\contactUpsertProcess_lastRun.properties
2010-08-10 09:57:18,679 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:104) - Logging in to: https://www.salesforce.com
2010-08-10 09:57:18,695 INFO [contactUpsertProcess] client.PartnerClient login (PartnerClient.java:989) - Beginning Partner Salesforce login ....
2010-08-10 09:57:18,710 INFO [contactUpsertProcess] client.PartnerClient login (PartnerClient.java:998) - Salesforce login to https://www.salesforce.com/services/Soap/u/19.0 as user prasad.pioneer@gmail.com
2010-08-10 09:57:23,804 INFO [contactUpsertProcess] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: insertContact of type: databaseWrite
2010-08-10 09:57:23,804 INFO [contactUpsertProcess] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\database-conf.xml]
2010-08-10 09:57:23,835 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:109) - Checking the data access object connection
2010-08-10 10:00:33,367 ERROR [contactUpsertProcess] database.DatabaseContext initConnection (DatabaseContext.java:96) - Database error encountered during connecting for database configuration: insertContact. Sql error: Cannot create PoolableConnectionFactory (Io exception: Connection reset).
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: Connection reset)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:89)
        at com.salesforce.dataloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:81)
        at com.salesforce.dataloader.dao.database.DatabaseWriter.checkConnection(DatabaseWriter.java:85)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:111)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:229)
Caused by: java.sql.SQLException: Io exception: Connection reset
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)

August 9, 2010
·
Like
0
·
Dislike
0

Jotmenow
Hi,

Guess issue is in Insert Query.
Mismatch of parameters.

Check below: We have 4 parameters on insert and 5 on property.

<bean id="insertContactSql"
      class="com.salesforce.dataloader.dao.database.SqlC
onfig" singleton="true">
    <property name="sqlString">
        <value>
            INSERT INTO TableOwner.Contact (
               Account_Id, Last_Name, First_Name, Name_)
            VALUES (@Account_Id@, @Last_Name@, @First_Name@, @Name_@)
        </value>
    </property>
    <property name="sqlParams">
        <map>
           <entry key="Id"    value="java.lang.String"/>
            <entry key="Account_Id"    value="java.lang.String"/>
            <entry key="Last_Name" value="java.lang.String"/>
            <entry key="First_Name" value="java.lang.String"/>
            <entry key="Name_" value="java.lang.String"/>
        </map>

August 9, 2010
·
Like
0
·
Dislike
0

My Own
Thanks Dude, you are right.

I have got another issue, can you please verify my process-conf.xml file.
Thanks in Advance.

<bean id="contactUpsertProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Contact Upsert job gets the Contact record updates from a CSV file and uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="contactUpsertProcess"/>
        <property name="configOverrideMap">
            <map>
    <entry key="process.mappingFile" value="C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\ContactsUpsertMap.sdl"/>
    <entry key="dataAccess.name" value="C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\Contact.csv"/>
    <entry key="sfdc.entity" value="Contact"/>
    <entry key="sfdc.loadBatchSize" value="200"/>
    <entry key="process.operation" value="upsert"/>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="prasad.test@gmail.com"/>
                <entry key="sfdc.password" value="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"/>
                <entry key="sfdc.timeoutSecs" value="900"/>
    <entry key="sfdc.connectionTimeoutSecs" value="60"/>
    <entry key="sfdc.enableRetries" value="TRUE"/>
    <entry key="sfdc.maxRetries" value="10"/>
    <entry key="sfdc.minRetrySleepSecs" value="5"/>
    <entry key="process.enableLastRunOutput" value="FALSE"/>
    <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.operation" value="upsert"/>
    <entry key="dataAccess.name" value="insertContact"/>
    <entry key="process.statusOutputDirectory" value="C:\Documents and Settings\pbadithala\Desktop\My Loader\Results" />
            </map>
        </property>
    </bean>

These Status output Directory is filling with sucess and errors empty csv files.

Exception Message:

C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin>process "C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config"   contactUpsertProcess
2010-08-10 13:31:37,689 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2010-08-10 13:31:37,705 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\process-conf.xml
2010-08-10 13:31:37,752 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Data Loader 19.0\samples\Config\pro
2010-08-10 13:31:37,767 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available
2010-08-10 13:31:37,783 INFO [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available
2010-08-10 13:31:37,830 INFO [contactUpsertProcess] controller.Controller initConfig (Controller.java:352) - The controller config has been initialized
2010-08-10 13:31:37,845 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:93) - Initializing process engine
2010-08-10 13:31:37,845 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:96) - Loading parameters
2010-08-10 13:31:38,674 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:104) - Logging in to: https://www.salesforce.com
2010-08-10 13:31:38,689 INFO [contactUpsertProcess] client.PartnerClient login (PartnerClient.java:989) - Beginning Partner Salesforce login ....
2010-08-10 13:31:38,705 INFO [contactUpsertProcess] client.PartnerClient login (PartnerClient.java:998) - Salesforce login to https://www.salesforce.com/services/Soap/u/19.0 as user prasad.pioneer@gmail.com
2010-08-10 13:31:40,564 INFO [contactUpsertProcess] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: insertContact of type: csvRead
2010-08-10 13:31:40,564 INFO [contactUpsertProcess] process.ProcessRunner run (ProcessRunner.java:109) - Checking the data access object connection
2010-08-10 13:31:40,564 ERROR [contactUpsertProcess] csv.CSVFileReader isUTF8File (CSVFileReader.java:239) - Error in file when testing CSV
2010-08-10 13:31:40,564 ERROR [contactUpsertProcess] csv.CSVFileReader open (CSVFileReader.java:160) - File: C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin\insertContact not found. Open failed.
java.io.FileNotFoundException: insertContact (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileReader.<init>(FileReader.java:55)
        at com.salesforce.dataloader.dao.csv.CSVFileReader.open(CSVFileReader.java:157)
        at com.salesforce.dataloader.dao.csv.CSVFileReader.checkConnection(CSVFileReader.java:134)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:111)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:229)
2010-08-10 13:31:40,564 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:214) - Unable to run process contactUpsertProcess
java.lang.RuntimeException: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: File: C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin\insertContact not found. Open failed.
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:139)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:229)
Caused by: com.salesforce.dataloader.exception.DataAccessObjectInitializationException: File: C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin\insertContact not found. Open failed.
        at com.salesforce.dataloader.dao.csv.CSVFileReader.open(CSVFileReader.java:161)
        at com.salesforce.dataloader.dao.csv.CSVFileReader.checkConnection(CSVFileReader.java:134)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:111)
        ... 1 more
Caused by: java.io.FileNotFoundException: insertContact (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileReader.<init>(FileReader.java:55)
        at com.salesforce.dataloader.dao.csv.CSVFileReader.open(CSVFileReader.java:157)
        ... 3 more

August 10, 2010
·
Like
0
·
Dislike
0

Jotmenow
Looks source file is missing/wrongly named.

C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin\insertContact

Guess you are missing .csv.

All the best.

Ajay

August 12, 2010
·
Like
0
·
Dislike
0

Dagny Fernandes
Hi All,

Iam configureing the same thing to Linux system can you please guid me on this I am new to this linux system.

March 9, 2016
·
Like
0
·
Dislike
0

Dagny Fernandes
I need to upsert the data from MYsql server to salesforce

March 9, 2016
·
Like
0
·
Dislike
0

Chandra Sfd
Hi all, I would like to schedule command line data loader every month to extract the EmailMessages that were created last year, this month. Could you please provide inputs on how to write the SOQL to do this? Thank you!

June 14, 2017
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Oracle to SFDC: Using command Line Data Loader

You need to sign in to do that.