Salesforce Sync Error - SystemModstamp | Community
Skip to main content
Sean_Hardaker
Sean_Hardaker
Level 3
January 29, 2016
Solved

Salesforce Sync Error - SystemModstamp

  • January 29, 2016
  • 2 replies
  • 5453 views

Salesforce Sync Error

Could not complete your Salesforce sync!

Why: The following required fields are hidden from the Salesforce sync account

Contact.AccountId

Opportunity.AccountId

When I first received this error in Marketo I created Contact.AccountId and Opportunity.AccountId custom text fields in SFDC, made them visible to MKTO sync user and assigned them the following formula: AccountId (Text) = AccountId

But this morning I received the same error again.

Turns out I need to update System Mod Stamp (SystemModstamp) as AccountId are formula fields. The link in the docs is out of date help.salesforce.com/apex/HTViewSolution?id=000181490&language=en_US

Can you help me perform this update? Is this a SOQL command or can it be done on the front end of SFDC?

Thanks

Sean

Best answer by Sean_Hardaker

The account ID is a red herring.

The solution: resolved by making 'Contact.Account Name' and 'Opportunity.Account Name' visible to my MKTO sync user.

2 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
January 29, 2016

Hi Sean

Creating custom fields in not the solution at all.

The missing fields are SFDC Standard fields that are hidden from the Marheto user profile. You need to grant right on these fields.

-Greg

Sean_Hardaker
Sean_HardakerAuthor
Level 3
January 29, 2016

Hi Greg

Thanks for your comments. When I got to "Contact Field-Level Security for profile" there is no AccountId field. If I also look in the "Contacts->fields" there is no field called AccountId there either. I am logged in as Admin.

Can you tell me where I would find the Contact.AccountId field so I can make it visible to my MKTO sync user?

thanks

Sean

Grégoire_Miche2
Grégoire_Miche2
Level 10
January 29, 2016

It's the standard "Account" field. Accountid is the API name of that field.

With regards to the Object field, I think it's on the activity object.

-Greg

Sean_Hardaker
Sean_HardakerAuthorAccepted solution
Level 3
February 5, 2016

The account ID is a red herring.

The solution: resolved by making 'Contact.Account Name' and 'Opportunity.Account Name' visible to my MKTO sync user.

Grégoire_Miche2
Grégoire_Miche2
Level 10
February 5, 2016

Which what I told you to do BTW...

-Greg

Terms & ConditionsAccessibility statement

Loading footer...