Time out happens connecting to Login.Salesforce.com while integrating SCCM with remedy force CMDB

Hi Guys ,

This blog post is about configuration manager integration with remedy force cmdb . Usually we get this error message when we have configured proxy on IE . To resolve the connection timeout we need to edit SPOON.BAT file located in data integration folder . There are 2 workarounds for this error depending upon the scenario . You can follow the following steps to resolve the issue :

Issue 1 :How to Configure Pentaho to Run Behind a Proxy.

Environment :

Product: Remedy force Winter 2013 Release

Patch:20.12.02.017.018

Solution :

When Pentaho is run behind a Proxy, the Java VM environment must be configured to use the proxy server.

This can be done by adding HTTP proxy properties to your JVM launcher:

-Dhttp.proxyHost=<proxy server>

-Dhttp.proxyPort=<proxy port>

-Dhttp.proxyUser=<user>

-Dhttp.proxyPassword=<pwd>

Ex: In Spoon.bat file add the following:

set OPT=-Xmx256m -cp %CLASSPATH% -Djava.library.path=libswt\win32\ -DKETTLE_HOME=”%KETTLE_HOME%” -DKETTLE_REPOSITORY=”%KETTLE_REPOSITORY%” -DKETTLE_USER=”%KETTLE_USER%” -DKETTLE_PASSWORD=”%KETTLE_PASSWORD%” -DKETTLE_PLUGIN_PACKAGES=”%KETTLE_PLUGIN_PACKAGES%” -DKETTLE_LOG_SIZE_LIMIT=”%KETTLE_LOG_SIZE_LIMIT%” -Dhttp.proxyHost=<proxy server> -Dhttp.proxyPort=<proxy port> -Dhttp.proxyUser=<user> -Dhttp.proxyPassword=<pwd>

Issue 2: How to make Pentaho Utility to Connect to Salesforce in Proxy Environment.

Environment : Remedy force winter 2011 release

Patch:20.11.03.007

Solution :

1. Browse to folder where Pentaho Utility Installed (..\Pentaho\data-integration\).

2. Edit the “Spoon.bat” through Notepad.

3. Go to Line No 92.

4. Append “-Dhttp.proxyHost=PROXYSERVERIP” “-Dhttp.proxyPort=PROXYSERVERPORT”.

Replace PROXYSERVERIP with Proxy Server IP, PROXYSERVERPORT with Proxy Server Port. For example, if Proxy Server IP is 192.168.11.8 and Proxy Server Port is 808

After that appending, the line looks like which is mentioned below

if “%PENTAHO_DI_JAVA_OPTIONS%”==”” set PENTAHO_DI_JAVA_OPTIONS=”-Xmx512m” “-XX:MaxPermSize=256m” “-Dhttp.proxyHost=192.168.11.8” “-Dhttp.proxyPort=808”

5. Save Spoon.bat File.

6. Open the Pentaho Utility.

7. Ensure Pentaho is able to connect to Salesforce without any issue.

Please find the screenshot of the error message we get when we try to integrate SCCM with remedy force CMDB :

cmdb