BMC Helix Remedyforce - Salesforce Upsert Failure to Connect via Pentaho

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Helix Remedyforce Service Desk



    PROBLEM:

    Pentaho job uses the 'Salesforce Upsert' step to perform AD integration between Provident systems and the Remedyforce instance. When the connection is tested in Pentaho, within the 'Salesforce Upsert' task, the following message might be displayed:

    Error connecting to Salesforce!
    ; nested exception is:
    java.net.ConnectException: Connection refused: connect

    Although this message is displayed and the connection is refused, the login history for the user in Remedyforce shows as a success.


    CAUSE:

    Salesforce API Version used in the Connection URL


    SOLUTION:

    In Sandbox Org use the API URL - https://test.salesforce.com/services/Soap/u/27.0

    In Production Org use the API URL - https://login.salesforce.com/services/Soap/u/27.0

    Note: If issue persist make sure the User's Salesforce Password has not expired recently if so update it as well as the Security Token and try again


    Article Number:

    000127574


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles