Cant figure out Salesforce upsert error: "CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY ... unexpected token"

[Anonymous]

Hi Folks,

I've been working on this all day and I'm at a loss.

I go to upsert a totaly uniform .csv file into salesforce and get errors on 400 out of 9300 records, thrown back into my run window.

Error says:

-----------------

Row 7000: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:hed.TDTM_Affiliation: execution of BeforeInsert

caused by: System.QueryException: unexpected token: ','

(hed)

------------------

Here is a picture:

Can you tell me what might be going on?  There are no extra commas I can find in the file.

Thank you everyone.

[TRF · Accepted solution]

It seems to be a problem in a before insert trigger (on Salesforce side).
You should have a look in that direction.

[vatsal_ras]

It looks like an error on Salesforce trigger.

Which object are you trying to upload ?

[Anonymous]

TRF, you were correct.

What was happening was that a managed package (HEDA) in Salesforce had two triggers on the Contact object for which we could not see the code, and something in those triggers was causing a reaction that fed failure data back up into Talend.

It wasn't a Talend issue.

So what I did was used a bypass on those triggers so that they would not trigger based on the user whom was inserting records being the "integration user", and everything is working.

Thanks.