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


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>



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


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 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=” “-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 :


Note : To run the Pentaho package again delete the time stamps and then run the job again to make sure all the information is entered again . 

Hope this help 🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by WordPress.com.

Up ↑

%d bloggers like this: