Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Error connecting to Salesforce!

  1. #1
    Join Date
    Dec 2010
    Posts
    6

    Default Error connecting to Salesforce!

    Hi All,

    It would be great if you could advise me what I am doing wrong.
    I have a job which get data from Salesforce and loads into a stagin table. When I run the job from within Kettle is runs without any problems.
    But then now I have schedule it to run on a daily basis using kitchen and it fails with the following exception:-

    ERROR 24-01 14:32:11,976 - Salesforce Account Input - Error occured during initialization
    Error connecting to Salesforce!
    ; nested exception is:
    javax.net.ssl.SSLKeyException: RSA premaster secret error
    ERROR 24-01 14:32:12,069 - Salesforce Account Input - Unexpected error :
    ERROR 24-01 14:32:12,069 - Salesforce Account Input - org.pentaho.di.core.exception.KettleException:
    Unable to query Salesforce
    ; nested exception is:
    javax.net.ssl.SSLKeyException: RSA premaster secret error
    org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.query(SalesforceConnection.java:348)
    org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.processRow(SalesforceInput.java:72)
    org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    java.lang.Thread.run(Unknown Source)
    INFO 24-01 14:32:12,070 - Salesforce Account Input - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
    INFO 24-01 14:32:12,070 - START - M_STG_SALESFORCE_ACCOUNTS
    INFO 24-01 14:32:12,070 - START - M_STG_SALESFORCE_ACCOUNTS
    ERROR 24-01 14:32:12,076 - START - Errors detected!
    ERROR 24-01 14:32:12,076 - START - Errors detected!
    INFO 24-01 14:32:12,111 - J_LOAD_STAGING - Finished job entry [M_STG_SALESFORCE_ACCOUNTS] (result=[false])
    INFO 24-01 14:32:12,112 - J_LOAD_STAGING - Finished job entry [M_ASSIGN_VARIABLES] (result=[false])
    INFO 24-01 14:32:12,112 - J_LOAD_STAGING - Job execution finished
    INFO 24-01 14:32:12,144 - Kitchen - Finished!
    ERROR 24-01 14:32:12,144 - Kitchen - Finished with errors
    INFO 24-01 14:32:12,144 - Kitchen - Start=2011/01/24 14:32:05.633, Stop=2011/01/24 14:32:12.144
    INFO 24-01 14:32:12,144 - Kitchen - Processing ended after 6 seconds.

    I am using Build version 4.1.1.

    Unfortunately I have not been able to find a solution to this problem on the forum.

    Regards,
    Divam
    Last edited by divam; 01-24-2011 at 06:50 PM.

  2. #2
    Join Date
    Dec 2010
    Posts
    6

    Default

    Below is the command I am running on command prompt:-

    kitchen.bat /rep:"repository" /job:"J_LOAD_STAGING" /dir:/Development /user:admin /pass:xyz1234 /level:detail >> C:/Logs/log1.log

  3. #3
    Join Date
    Nov 2008
    Posts
    143

    Default

    Are you by any chance setting variables to connect to the Salesforce web service?

  4. #4
    Join Date
    Dec 2010
    Posts
    6

    Default

    Hi Renato,

    Yes I was setting variable for the username and password previously then I hardcoded values but it still would give me the same exception.
    I thought it has to do with the encription. So I queried the reposity and changed the password in R_STEP_ATTRIBUTE table also but nothing worked for me.

    Anything else I should be trying?

    Thanks,
    Divam

  5. #5
    Join Date
    Dec 2010
    Posts
    6

    Default

    Well finaly I was able to get things working for me. I had to set JAVA_EXT_DIRS as a new environmental variable and it worked for me. Fingers crossed...

  6. #6

    Default

    HI Divam,

    Can you hep me with setting Kettle (spoon) for running salesforce webservice behind a proxy?

    best regards

  7. #7

    Default

    Hi,

    If you still have the "Secret" exception have a look at this thread: http://forums.pentaho.com/showthread...r-secret-error
    Regards,

    Mark, Cloud2Land

    http://www.cloud2land.com

  8. #8
    Join Date
    Jan 2011
    Posts
    6

    Default

    Hello!
    to enable salesforce web service calls using the salesforce input widget when you're behind a proxy you must first set a java environment variable to configure java proxy settings.
    This is done in Linux by setting the following environment variable from the command line before launching spoon (in Windows, use whatever tool you usually use to set env variables then launch spoon):
    export _JAVA_OPTIONS='Dhttp.proxyHost={YOUR PROXY HOST} -Dhttp.proxyPort={YOUR PROXY PORT}'

    Example: export _JAVA_OPTIONS='Dhttp.proxyHost=10.1.1.5 -Dhttp.proxyPort=80'

    This must be done before launching spoon and spoon will pick these variables up and use the proxy settings for salesforce calls.

    Hope this helps!

  9. #9

    Default

    Hi I am also facing same issue .

    When connecting to Salesforce through pentaho version 7.1 I am getting following error :


    Error connecting to Salesforce!
    Failed to send request to https://login.salesforce.com/services/Soap/u/37.0



  10. #10

    Default

    This is a 7-year-old forum thread, please create a new one.

    The Salesforce steps have changed significantly between 7.1 and the earlier version that was discussed in this thread 7 years ago.

    When you create a new thread, please provide more details to help us help you, such as additional log messages.

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.