Fields overwritten with [null] by SFDC Sync | Community
Skip to main content
Bishoy_Riad
Bishoy_Riad
Level 2
August 20, 2019
Question

Fields overwritten with [null] by SFDC Sync

  • August 20, 2019
  • 2 replies
  • 7091 views

Hi Marketo Nation,

We found that sometimes, certain fields are being overwritten with "[null]" at the exact same time. There are no Salesforce automations that would clear them. There is also no consistent timing for this to occur.

I created a Smart List and found a few patterns:

1. All affected records are overwritten via Sync by SFDC, either referencing a Lead ID or Contact ID depending on the record type.

2. All affected records have a "Company" value ("Account Name" value in SFDC).

3. Among the Lead type records that are affected, they are only bookings imported from a legacy system. While they obviously do not have an Account associated, they do have a "Company" value populated.

Here's an example of how the Activity Log looks (this record includes all 5 fields that are affected):

The individual Activity Details for one of the logged events looks like this:

The Marketo Integration User has full edit level permissions for 4 of the 5 fields on the Lead and Opp objects, and read permissions for the same 4 fields on the Contact object.

Thanks for assisting!

Bishoy

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 21, 2019

    You seem to be leaving out something important: are those fields blank in SFDC? And when were they cleared?

    Bishoy_Riad
    Bishoy_RiadAuthor
    Level 2
    August 21, 2019

    These fields are not blank in SFDC, and I don't believe they were cleared prior. We just turned on field history tracking for the fields in question to ensure they weren't cleared at any point in SFDC.

    The [null] issue has been happening to different records since early 2018. At least 1 of the same 5 fields are being overwritten in each case.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 21, 2019

    Well, watch the history tracking closely before deciding there's a bug on the Marketo side.

    Lauren_Hawes
    Lauren_Hawes
    Level 2
    August 21, 2019

    We are also having this issue. A campaign changes their 'Person Status' in Marketo, but a SFDC Sync messes with it. It looks like it's being changed from [null] to "None" but the field was clearly changed to "Purchased List" 2 minutes prior.

    Justin_Schmidt
    Justin_Schmidt
    Level 1
    February 27, 2020

    Same here. Did you ever figure out the problem?

      Terms & ConditionsAccessibility statement

      Loading footer...