com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'id'.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. -Dhttp.proxyHost=10.1.1.1 -Dhttp.proxyPort=8080 -jar CopyForceSqlServer.jar 
-schema -include "custom_object__c" -salesforce Production,mail,pwd,token 
-sqlserver "SQLconfiguration"
2. on console error com.microsoft.sqlserver.jdbc.SQLServerException: Invalid 
column name 'id'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
    at com.aslan.sfdc.extract.ansi.JDBCDatabaseBuilder.getLastModifiedDate(JDBCDatabaseBuilder.java:638)
    at com.aslan.sfdc.extract.ansi.JDBCDatabaseBuilder.insertData(JDBCDatabaseBuilder.java:497)
    at com.aslan.sfdc.extract.ExtractionManager$1MyCallback.flush(ExtractionManager.java:364)
    at com.aslan.sfdc.extract.ExtractionManager$1MyCallback.finish(ExtractionManager.java:411)
    at com.aslan.sfdc.partner.SObjectQueryHelper$1MyCallback.finish(SObjectQueryHelper.java:489)
    at com.aslan.sfdc.partner.SObjectQueryHelper.findRows(SObjectQueryHelper.java:455)
    at com.aslan.sfdc.partner.SObjectQueryHelper.findRows(SObjectQueryHelper.java:515)
    at com.aslan.sfdc.extract.ExtractionManager.extractData(ExtractionManager.java:419)
    at com.aslan.sfdc.extract.ExtractionManager.extractData(ExtractionManager.java:439)
    at com.aslan.sfdc.copyforce.CopyForce$CopyThread.copy(CopyForce.java:315)
    at com.aslan.sfdc.copyforce.CopyForce$CopyThread.run(CopyForce.java:328)

3. the schema and datas are created anyway

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?

O.S. MS XP, CopyForceSqlServer.jar version 1.22.6, SQLServer 2005


Please provide any additional information below.

Original issue reported on code.google.com by michele....@sinesy.it on 27 Oct 2011 at 12:28

[GoogleCodeExporter]

Could not reproduce.

Original comment by gsmithfarmer on 23 Apr 2012 at 1:50

• Changed state: WontFix