• Kol Briskovic
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I am trying to use a Salesforce upsert output in Pentaho Data Interation(8.1) but I keep getting below error. I have tried PDI 7 and 6 too.

I am tryin to connect to test and I have changed the URL, I am using my token for test after my password. Now I have tried adding proxy settings to the spoon.bat as recommened in https://communities.bmc.com/docs/DOC-72085 but it is not working.

java.lang.Exception:
Error connecting to Salesforce!
Failed to send request to https://test.salesforce.com/services/Soap/u/37.0
 at org.pentaho.di.ui.trans.steps.salesforce.SalesforceStepDialog.test(SalesforceStepDialog.java:97)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog.access$1700(SalesforceUpsertDialog.java:88)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog$10.handleEvent(SalesforceUpsertDialog.java:682)
 at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog.open(SalesforceUpsertDialog.java:726)
 at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:120)
 at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8949)
 at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3291)
 at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:785)
 at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
 at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
 at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1375)
 at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:8104)
 at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9466)
 at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:701)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
 
I am trying to use a Salesforce upsert output in Pentaho Data Interation(8.1) but I keep getting below error. I have tried PDI 7 and 6 too.

I am tryin to connect to test and I have changed the URL, I am using my token for test after my password. Now I have tried adding proxy settings to the spoon.bat as recommened in https://communities.bmc.com/docs/DOC-72085 but it is not working.

java.lang.Exception:
Error connecting to Salesforce!
Failed to send request to https://test.salesforce.com/services/Soap/u/37.0
 at org.pentaho.di.ui.trans.steps.salesforce.SalesforceStepDialog.test(SalesforceStepDialog.java:97)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog.access$1700(SalesforceUpsertDialog.java:88)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog$10.handleEvent(SalesforceUpsertDialog.java:682)
 at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
 at org.pentaho.di.ui.trans.steps.salesforceupsert.SalesforceUpsertDialog.open(SalesforceUpsertDialog.java:726)
 at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:120)
 at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8949)
 at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3291)
 at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:785)
 at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
 at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
 at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1375)
 at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:8104)
 at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9466)
 at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:701)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)