#SCCM Expert #Private Cloud Consultant#SQL Expert#Corporate Trainer #Automation Consultant

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

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 🙂

Advertisements

Categorised in: CMDB, SCCM

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Translate

%d bloggers like this: