AnsweredAssumed Answered sync errors - hundreds of duplicate leads created in SFDC by Marketo user

Question asked by 45099 on Nov 21, 2013
Latest reply on Dec 9, 2013 by 41574
We've been using SFDC for nearly 10 years, and Marketo for just a month or so.

Sometime last night or early this AM, our Marketo sync user started creating hundreds of duplicate leads in SFDC. Looking at some of the lead records in Marketo says the creation originated in

Marketo support pointed me to this error I'm getting with sync failure: 

Could not execute update [Native Error: 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 'and li.sfdc_lead_id is null and and p.sfdc_type is null' at line 3] [User Info: update mkt_person p,mkt_lead_interest li set li.sfdc_lead_id = '00Q4000000roOEYEA2', li.updated_at = '2013-11-21 08:51:49', li.sfdc_synch_timestamp = '2013-11-21 08:51:49', p.sfdc_type = 'Lead' WHERE = and li.sfdc_lead_id is null and and p.sfdc_type is null]

Waiting to hear from SFDC support. 

Possibly related to permissions / role / user change in SFDC? I don't see any evidence of that in SFDC.

Dupe reocrds (25+ each) continuing to be created in SFDC by Marketo user. No lead source.