Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Basic Salesforce Insert Help

  1. #1
    Join Date
    Oct 2012
    Posts
    4

    Question Basic Salesforce Insert Help

    Hello, I am having a hard time getting Kettle to allow me to insert records into a custom SF object we have called "Benefit". I am testing in our Sandbox and I can get the field mappings to auto-match on the module so I know it's talking to SF but when I run the transform the job just fails with the error message below. Can anyone look over this error message and attached photo of my module config and maybe shed some light on what is going on?

    2013/06/05 15:04:21 - Spoon - Transformation opened.
    2013/06/05 15:04:21 - Spoon - Launching transformation [Compare]...
    2013/06/05 15:04:21 - Spoon - Started the transformation execution.
    2013/06/05 15:04:21 - Compare - Dispatching started for transformation [Compare]
    2013/06/05 15:04:21 - Transformation metadata - Natural sort of steps executed in 0 ms (11 time previous steps calculated)
    2013/06/05 15:04:23 - Build HBS ID.0 - Optimization level set to 9.
    2013/06/05 15:04:23 - Microsoft Excel Input.0 - Finished processing (I=1050, O=0, R=0, W=1050, U=0, E=0)
    2013/06/05 15:04:23 - Select values.0 - Finished processing (I=0, O=0, R=1050, W=1050, U=0, E=0)
    2013/06/05 15:04:23 - Build HBS ID.0 - Finished processing (I=0, O=0, R=1050, W=1050, U=0, E=0)
    2013/06/05 15:04:31 - Salesforce Lookup.0 - Finished processing (I=0, O=0, R=0, W=5695, U=0, E=0)
    2013/06/05 15:04:31 - Math.0 - Optimization level set to 9.
    2013/06/05 15:04:31 - Stream lookup.0 - Finished processing (I=0, O=0, R=6745, W=1050, U=0, E=0)
    2013/06/05 15:04:31 - Math.0 - Finished processing (I=0, O=0, R=1050, W=1050, U=0, E=0)
    2013/06/05 15:04:31 - Filter rows.0 - Finished processing (I=0, O=0, R=1050, W=1050, U=0, E=0)
    2013/06/05 15:04:31 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=912, W=912, U=0, E=0)
    2013/06/05 15:04:31 - Select values 2.0 - Finished processing (I=0, O=0, R=138, W=138, U=0, E=0)
    2013/06/05 15:04:31 - Add constants.0 - Finished processing (I=0, O=0, R=138, W=138, U=0, E=0)
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error while inserting data in Salesforce :
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.salesforceinsert.SalesforceInsert.processRow(SalesforceInsert.java:123)
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2013/06/05 15:04:32 - Salesforce Insert.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Thread.java:722)
    2013/06/05 15:04:32 - Salesforce Insert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1)
    2013/06/05 15:04:32 - Spoon - The transformation has finished!!
    2013/06/05 15:04:32 - Compare - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
    2013/06/05 15:04:32 - Compare - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
    2013/06/05 15:04:32 - Compare - Compare
    2013/06/05 15:04:32 - Compare - Compare
    Attached Images Attached Images  

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.