Re: Sync Error - Lead Field updates are not flowing from Marketo to SFDC

Anonymous
Not applicable
we have setup sync between marketo and salesforce in sandbox, leads are flowing bi-directionally,
however updates are not flowing from marketo to salesforce, its showing error.
SFDC Error:
INSUFFICIENT_ACCESS_OR_READONLY: insufficient access rights on object id\n


How to resolve this, I have checked all the permissions, and there is no restriction for this particular profile in SFDC.
Any ideas?
Tags (1)
9 REPLIES 9
Casey_Hayes
Level 1
Thank you Kenny E! I'll give this a try.
Kenny_Elkington
Marketo Employee
Here is a more complete explanation that I posted in another thread:

It's likely that the Record Type ID is not a valid record type for the particular object which is being synched.  For example, if I assign a Lead record type to a Contact in MArketo, and then try to sync that, then the operation will fail because SFDC will not allow the Marketo to assign that record type to a contact.  The solution is to clear invalid record type IDs when a Lead is converted,  but still has a Lead Record Type ID.

Suppose I have a lead, and it has Record Type ID 'A'.  Then I convert this lead into a contact, but the Marketo-side record still has Record Type ID 'A'.  Since A is a record type for leads, the next time Marketo pushes an update to SFDC, it will also attempt to change the record type back to 'A' and this will cause SFDC to throw an error.  This is the typical case where an invalid record type will be assigned.  There are others but they are atypical and often unique.

There are many use cases for record types, so solutions are not universal, but one I recommend frequently is quite simple.  Set up a trigger campaign like so:

Smart List
Trigger - 'Lead is Converted'
(Filter - Record Type ID is not empty) not necessarily required

Flow
Change Data Value - Attribute is Record Type ID
New Value is 'Null' or 'Valid Record type for Contact'

This will clear invalid lead record types upon conversion and allow you contacts to sync normally.
Anonymous
Not applicable
I'm still trying to figure this out. Problem not solved.
Casey_Hayes
Level 1
Hi Alex G and Marie-Pier G,

I believe I am running into a similar situation. Same error, but the Marketo Sync user appears to have all the necessary permissions.  Could either of you elaborate on how you were able to resolve?

Thanks!
Anonymous
Not applicable
I have the same issue as well. Marketo has all the access rights to R/W/U in SFDC....
Anonymous
Not applicable
Hi Kenny, 
Could you explain a bit more on your reply.I think this is the issue I am facing.

------- "This is likely cause by Marketo attempting to write a Record Type ID to the record for which it does not have access, or attempting to write an invalid record type, for example, a Lead Record Type to a Contact."
Anonymous
Not applicable
Thanks all for your replies.

Error was raised because of the role hierarchy issue in SFDC. I was able to resolve this .

Thanks
Kenny_Elkington
Marketo Employee
Hey Soujanya,

This is likely cause by Marketo attempting to write a Record Type ID to the record for which it does not have access, or attempting to write an invalid record type, for example, a Lead Record Type to a Contact.
Josh_Hill13
Level 10 - Champion Alumni
Your Marketo User and/or Profile doesn't have access to create the record or to R/W/M a field that it needs to do this. Please check further.