INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call | Community
Skip to main content
Amith_Nayanar
Amith_Nayanar
New Participant
September 7, 2018
Solved

INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

  • September 7, 2018
  • 1 reply
  • 4857 views

Hi fellow marketers,

Iam facing this issue and unable to sync a particular lead from Marketo to SFDC. Have you guys faced this issue before? Any idea why this is happening?

Thanks

Amith

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

It seems to me that Marketo is not aware of the fact that the lead was converted and did not automatically resync with the contact instead. This might be because the sync broke just before the conversion or because Marketo cannot access the contact that should be replacing the lead. Can be linked to specific sharing rules set in SFDC for the Marketo user or because of a sync filter that is deactivated for this record.

-Greg

1 reply

SanfordWhiteman
SanfordWhiteman
New Participant
September 7, 2018

Have you read the notes at SFDC Read Only Fields Deep Dive ?

Amith_Nayanar
Amith_NayanarAuthor
New Participant
September 7, 2018

Hi Sanford,

Thanks for sharing this. But this is what i found out.

The lead is existing in Marketo since 2014, it had synced to SFDC earlier. I verified the synch which happened in 2014 and found the SFDC ID to which the lead had synched. When i try to search the lead in SFDC, based on that ID, i get the message, saying that the lead was converted. When i open the converted contact, the email ID and name is totally different. Any idea, why this happened?

I suspect the email ID/name was changed in SFDC, but it didnt reflect in Marketo. Right now, Marketo is trying to sync the lead to SFDC, but since the email ID, is different, it is trying to create a new recoprd in SFDC. But the SFDC ID already exists in SFDC. So, the error is coming up.

Did i confuse you?

Grégoire_Miche2
Grégoire_Miche2Accepted solution
New Participant
September 7, 2018

It seems to me that Marketo is not aware of the fact that the lead was converted and did not automatically resync with the contact instead. This might be because the sync broke just before the conversion or because Marketo cannot access the contact that should be replacing the lead. Can be linked to specific sharing rules set in SFDC for the Marketo user or because of a sync filter that is deactivated for this record.

-Greg

    Terms & ConditionsAccessibility statement

    Loading footer...