Sync Error - Lead Field updates are not flowing from Marketo to SFDC | Community
Skip to main content
February 25, 2014
Question

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

  • February 25, 2014
  • 9 replies
  • 3008 views
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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

9 replies

Josh_Hill13
Level 10
February 25, 2014
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.
Kenny_Elkington
Adobe Employee
Adobe Employee
February 25, 2014
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.
February 25, 2014
Thanks all for your replies.

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

Thanks
February 26, 2014
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."
March 10, 2014
I have the same issue as well. Marketo has all the access rights to R/W/U in SFDC....
Level 2
August 22, 2014
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!
August 22, 2014
I'm still trying to figure this out. Problem not solved.
Kenny_Elkington
Adobe Employee
Adobe Employee
August 22, 2014
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.
Level 2
August 22, 2014
Thank you Kenny E! I'll give this a try.