Sync Errors

Forum|Forum|3 years ago
January 6, 2023
9 답변들
3801 조회

Wondering if anyone can shed a little more light please on a sync error we are receiving. We are currently implementing Marketo and although I have administered the platform at previous companies, I've not seen this error which doesn't seem to be very clear so hoping someone can help:

Error Type is Job_Level and Error Details soqlBatchQuery failed - INVALID_FIELD: ActivityDateTime, CreatedDate, Description, Id, IsAllDayEvent, ^ERROR at Row:1:Column:53 No such column 'Description' on entity 'Event'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."

We don't have a 'Job_Level' field on the Event object and, not sure why is says the fields are invalid

Any help would be appreciated, thank you.

Marketo

이 주제는 답변이 닫혔습니다.

Darshil_Shah1

Adobe Champion, Community Advisor, UG Leader

Check out this marketo nation knowledgebase article that discusses this exact same error. It might be due to missing permissions on the sync user's profile to access the "Description" field. Could you confirm if the Marketo sync user has got apt access rights for the Description field? Check out this SFDC help article as well that discusses this error.

N

NikWest작성자

Level 2

Thanks Darshill, unfortunately I had already checked the FLS on the Marketo profile and it has Read and Edit access on the Description field and the All Day Event field, i refreshed the schema and started the sync again but the Event object still keeps failing.

Darshil_Shah1

Adobe Champion, Community Advisor, UG Leader

Are you able to r/w the Description and All Day Event fields when you log into SFDC using the sync user's credentials?

JaceBr

Level 3

We'd probably need to see the full query you're sending, but from what I can tell in the error, it's not failing because of a "Job_Level" field, but the field it's missing is "description"

Do you have a "Description" field on the event object, and if so, can you confirm that the API field name is accurate?

N

NikWest작성자

Level 2

Thanks Brace, yes the profile has read and edit on the Descripton field and it is a standard field not a custom so the API name is correct. I refreshed the schema and restarted the sync but stillt he Event object is failing. Any other ideas, maybe I am missing something

SanfordWhiteman

Level 10

“Job Level” refers to the process within Marketo that encountered the error, it’s not a field name.

N

NikWest작성자

Level 2

Thanks Sandford

가입하기

소셜 로그인

커뮤니티에 로그인

소셜 로그인