SFDC sync failure

[Revati_Bhavsar]

Hello There,

We encountered an SFDC sync failure on most of the synched contacts in marketo due to a new custom validation rule that was created on account object just 3-4 days ago. We are unable to get the exact volume of data affected, but looking into the marketo db, when I randomly checked few of the records, every other record seems to be affected.

The strange thing is that validation is not applicable on any of the marketo records as it's on account level and marketo cannot update any account data, and neither marketo is trying to update any of the fields on which the validation rule is applied, and it does not even contain any bad data. 

The weirdest thing what I found is the regular sync( or auto-sync) is failing when any contact in marketo is trying to initiate a sync cycle. However it works when we manually sync the records.

Has anyone come across any such issues? Any help appreciated!

Thanks and regards,

Revati

[Oz_Platero]

Hello Revati Bhavsar‌,

 We are unable to get the exact volume of data affected

• Support can help with getting this number, however it requires advanced knowledge of some tools to get so you may not get it unless you have Elite support.

The strange thing is that validation is not applicable on any of the marketo records as it's on account level and marketo cannot update any account data,

• Mostly true.  There are some edge cases where it can. Or you can turn this feature on as well to access Account object. Not recommended.

and neither marketo is trying to update any of the fields on which the validation rule is applied, and it does not even contain any bad data. 

• You have B2B distribution or System integrator in field in Classification Level 1
  • When the above is true Classification Level 2 cannot be empty.
• Check your validation rules in SFDC against Classification Level 1 and 2
  
• Check the SFDC object -> Validation rules
• Check Process builder