Four Stars

tSalesforceOutputBulk link Custom object to User (via OwnerId)

Hi guys,

I work on a custom object called Dossier__c. 
And I'm trying to fill in the Owner Id with the External Id of the user (IdentifiantUnique__c). I'm going to the advanced setting of the tSalesforceOutputBulk component : 
outpubulk1.JPG


And when I try to run my Job I have the issue "Invalid Job"

For information I try this manip on the Account Object with the same configuration and it worked perfectly.

Someone has an Idea ?

Thanks !

Elliot

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Eleven Stars TRF
Eleven Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Hi,

 

Tick the option "Polymorphic", like in my case:

Capture.PNG


TRF
5 REPLIES
Eleven Stars TRF
Eleven Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Hi,

 

Everything looks fine with the relationship configuration.

Are you sure the problem is with this field? What if you remove this operation?

You can also get some more details from Salesforce (if the flow has been pushed to Salesforce).

Connect to Salesforce, Setup, Bulk Data Load Jobs, click on the desired JobID (7509E00000xxxxx), scroll down to the Batches list then look at the State Message for the Failed batch.

You should find something like "InvalidBatch : Field name not found : xxxxxxx_c".

Let us know.

 


TRF
Four Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Hi TRF,

 

Thanks for your quick answer, yes I'm sure the problem is with this field because when I remove it, records are processed successfully ! On the bulk data Load page I have this error message : 
invlidbatch.jpg

 

Thank you very much
Have a nice day,

Elliot

Eleven Stars TRF
Eleven Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Hi,

 

Tick the option "Polymorphic", like in my case:

Capture.PNG


TRF
Four Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

TRF,

It works perfectly ! 

Thanks for your help Smiley Happy 

I am sending you my best wishes for the future,
Bye,
Elliot

Eleven Stars TRF
Eleven Stars

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Great!

@ElliotCathy, can you mark the case as solved, for people searching an answer to the same case.

Kudos are also welcome as incentive - we can't eat them, but never mind, we like it anyway!


TRF