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
DuffAlthausDuffAlthaus 

Data Loader CLI - Invalid Fetch Size

I'm getting an error when trying to query SQL Server and insert into SFDC using Data Loader.    Invalid Fetch Size.
I'm connecting using ODBC so not sure where I can set Featch size.
2014-06-19 11:03:24,097 ERROR [CountInsertDB] action.AbstractAction handleExcept
ion (AbstractAction.java:200) - Exception occured during loading
com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Dat
abase error encountered during setup of the database configuration: queryEmploye
rCounts.  Sql error: Invalid Fetch Size.
        at com.salesforce.dataloader.dao.database.DatabaseReader.setupQuery(Data
baseReader.java:149)
        at com.salesforce.dataloader.dao.database.DatabaseReader.open(DatabaseRe
ader.java:110)
        at com.salesforce.dataloader.dao.database.DatabaseReader.open(DatabaseRe
ader.java:98)
        at com.salesforce.dataloader.action.AbstractAction.execute(AbstractActio
n.java:116)
        at com.salesforce.dataloader.controller.Controller.executeAction(Control
ler.java:124)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:149)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: java.sql.SQLException: Invalid Fetch Size
        at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingSt
atement.java:279)
        at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingSt
atement.java:279)
        at com.salesforce.dataloader.dao.database.DatabaseReader.setupQuery(Data
baseReader.java:141)
        ... 7 more
22227 [CountInsertDB] ERROR com.salesforce.dataloader.action.InsertAction  - Exc
eption occured during loading
com.salesforce.dataloader.exception.DataAccessObjectInitializationException: Dat
abase error encountered during setup of the database configuration: queryEmploye
rCounts.  Sql error: Invalid Fetch Size.
        at com.salesforce.dataloader.dao.database.DatabaseReader.setupQuery(Data
baseReader.java:149)
        at com.salesforce.dataloader.dao.database.DatabaseReader.open(DatabaseRe
ader.java:110)
        at com.salesforce.dataloader.dao.database.DatabaseReader.open(DatabaseRe
ader.java:98)
        at com.salesforce.dataloader.action.AbstractAction.execute(AbstractActio
n.java:116)
        at com.salesforce.dataloader.controller.Controller.executeAction(Control
ler.java:124)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:149)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: java.sql.SQLException: Invalid Fetch Size
        at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingSt
atement.java:279)
        at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingSt
atement.java:279)
        at com.salesforce.dataloader.dao.database.DatabaseReader.setupQuery(Data
baseReader.java:141)
        ... 7 more
2014-06-19 11:03:24,122 ERROR [CountInsertDB] progress.NihilistProgressAdapter d
oneError (NihilistProgressAdapter.java:58) - Database error encountered during s
etup of the database configuration: queryEmployerCounts.  Sql error: Invalid Fet
ch Size.
22252 [CountInsertDB] ERROR com.salesforce.dataloader.action.progress.NihilistPr
ogressAdapter  - Database error encountered during setup of the database configu
ration: queryEmployerCounts.  Sql error: Invalid Fetch Size.
Chris BettiniChris Bettini

I'm having the same issue pulling data from MS Access and Upserting into Salesforce....help!!

thanks,

Chris