2 posts / 0 new
Last post
Unable to perform full synchronization of Case object
5/9/17:10:08 AM SalesforceAdapter synchronizeTables-INFO: Creating table: create table IF NOT EXISTS Case ( sync_id bigint NOT NULL auto_increment, sf_update_timestamp datetime, do_sync_flag varchar(1), merge_id varchar(18), PRIMARY KEY (sync_id) ); 5/9/17:10:08 AM DBAdapter executeBatchTransactions-SEVERE: executeBatchTransactions :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Case ( sync_id bigint NOT NULL auto_increment, sf_update_timestamp datetime,' at line 1 5/9/17:10:08 AM DBAdapter executeBatchTransactions-INFO: executeBatchTransactions : Following set of queries caused the error (commit=true) 5/9/17:10:08 AM DBAdapter executeBatchTransactions-INFO: create table IF NOT EXISTS Case ( sync_id bigint NOT NULL auto_increment, sf_update_timestamp datetime, do_sync_flag varchar(1), merge_id varchar(18), PRIMARY KEY (sync_id) ) 5/9/17:10:08 AM Driver reportRunStatus-INFO: Closing file log handle: Please can you advise what I need to do to overcome this problem?
Total votes: 38

Looks like you are using My SQL as databse & CASE is a keyword so it is throwing the exception . Please use prefix on the system.properties file to avoid this

Total votes: 32