INVALID_FIELD_FOR_INSERT_UPDATE: cannot specify Id in an insert call

[Amith_Nayanar]

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

[SanfordWhiteman]

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

[Amith_Nayanar]

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 · Accepted solution]

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