You need to sign in to do that
Don't have an account?
DuffAlthaus
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.
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.
I'm having the same issue pulling data from MS Access and Upserting into Salesforce....help!!
thanks,
Chris