Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Salesforce upsert- lookup field is empty

  1. #1
    Join Date
    Dec 2015
    Posts
    9

    Unhappy Salesforce upsert- lookup field is empty

    I'm using the salesforce upsert component, but the field lookup field is getting empty. The field in the related object is an external ID, since I am using a product code and not the salesforce id.
    The csv is apparently correct.
    Who do you have any idea?

    Salesforce upsert
    Name:  b.PNG
Views: 140
Size:  6.6 KB

    CSV
    Name:  c.jpg
Views: 141
Size:  21.7 KB

    Related object
    Name:  d.jpg
Views: 115
Size:  3.0 KB

    Account
    Name:  e.jpg
Views: 115
Size:  4.7 KB
    Attached Images Attached Images  

  2. #2
    Join Date
    Dec 2015
    Posts
    9

    Default

    Code:
    2016/12/22 16:28:19 - Salesforce Upsert.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Unexpected error2016/12/22 16:28:19 - Salesforce Upsert.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2016/12/22 16:28:19 - Salesforce Upsert.0 - :Errors were found on item 0 Error code is: REQUIRED_FIELD_MISSING Error message: Campos obrigatórios ausentes: [Conta__c]
    2016/12/22 16:28:19 - Salesforce Upsert.0 - 
    2016/12/22 16:28:19 - Salesforce Upsert.0 - 	at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers(SalesforceUpsert.java:237)
    2016/12/22 16:28:19 - Salesforce Upsert.0 - 	at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:71)
    2016/12/22 16:28:19 - Salesforce Upsert.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2016/12/22 16:28:19 - Salesforce Upsert.0 - 	at java.lang.Thread.run(Unknown Source)
    2016/12/22 16:28:19 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=13, W=0, U=0, E=1)

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default

    FYI, bug report is here: http://jira.pentaho.com/browse/PDI-15903

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.