Query :

I have created a new code list and have to make a large number of entries into the new code list ( close to 200 ). Does anyone know of a smart way to accomplish this ? I am looking for a way to load the entries from an excel spreadsheet.

Solution :

Exporting and importing code lists is a pain. Edit the database table CODELIST_XREF_ITEM directly.

Select * from CODELIST_XREF_ITEM where LIST_NAME = 'your_code_list' and LIST_VERSION = max_version_for_this_list

To create a new entry, copy these keys from an existing entry: LIST_NAME, SENDER_ID, RECEIVER_ID, LIST_VERSION. Then Enter the rest of the fields. Remember that SENDER_ITEM/RECEIVER_ITEM combo must be unique.

You can do this manually, or through a SQL statement.

The original code list is still cached. You must go into the Dashboard and EDIT the code list. Click on SAVE and the updated code list will now be cached and the version number will have incremented.

Sterling Integrator Graphic Process Modeler is not working

Issue : 
I am working with Sterling Integrator Version 5.2.2 build 5020200.  When I try to run the GPM, I get an "Unable to launch the application" error message. 
The details of the Launch file are (I have hidden part of the IP address for this post):


<jnlp spec="1.0+" codebase="http://10.xxx.9.104:xxx00/gbm/pmodeler" href="ProcessModeler.jnlp" version="1.0">
  <information>
    <title>Modeler-gissrv1-xxx00</title>
    <vendor>Sterling Commerce</vendor>
    <homepage href="http://www.sterlingcommerce.com"/>
    <description kind="">Modeler-gissrv1-10400</description>
    <offline-allowed/>
  </information>
  <resources>
    <j2se version="1.5" href="http://java.sun.com/products/autodl/j2se" java-vm-args="-Xss1024k"/>
    <jar href="FlowBuilder.jar"/>
    <jar href="JGo.jar"/>
    <jar href="JGoLayout.jar"/>
    <jar href="SCM.jar"/>
    <jar href="xercesImpl.jar"/>
    <jar href="xmlParserAPIs.jar"/>
  </resources>
  <security>
    <all-permissions/>
  </security>
  <application-desc main-class="com.sterlingcommerce.woodstock.gbm.editor.jgo.FlowBuilderMain">
    <argument>10.xxx.9.104</argument>
    <argument>xxx00</argument>
    <argument>ws</argument>
    <argument>http</argument>
  </application-desc>
</jnlp>


The exception file contains:
java.lang.SecurityException: com.sun.deploy.net.JARSigningException: Found unsigned entry in resource:http://10.xxx.9.104:xxx00/gbm/pmodeler/xercesImpl.jar
   at com.sun.deploy.cache.CacheEntry.getJarFile(Unknown Source)
   at com.sun.javaws.security.SigningInfo.check(Unknown Source)
   at com.sun.javaws.security.JNLPSignedResourcesHelper.checkSignedResourcesHelper(Unknown Source)
   at com.sun.javaws.security.JNLPSignedResourcesHelper.checkSignedResources(Unknown Source)
   at com.sun.javaws.Launcher.prepareResources(Unknown Source)
   at com.sun.javaws.Launcher.prepareAllResources(Unknown Source)
   at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
   at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
   at com.sun.javaws.Launcher.launch(Unknown Source)
   at com.sun.javaws.Main.launchApp(Unknown Source)
   at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
   at com.sun.javaws.Main.access$000(Unknown Source)
   at com.sun.javaws.Main$1.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
Caused by: com.sun.deploy.net.JARSigningException: Found unsigned entry in resource: http://10.xxx.9.104:10400/gbm/pmodeler/xercesImpl.jar
   ... 14 more

 Cause :

 It is because of Java version mismatch between the server and GPM. For ex. installed SI on Java 6 and if you are running GPM with java 7 version then it will throw above version.


 Solution :  based on SI installed using Java 6 not Java 7

 Need to run the download the ProcessModeler.jnlp file from dashboard and run the file using Java 6 JavaWebStart.exe file.

 If you have any existing Java 7 in our system then we need to uninstall the Java 7 from our system.

 Conclusion :

 Both SI and GPM should run on same Java version then you won't get issue to download and install GPM.

Sterling Integrator Graphical Process Modeler not opening

Most of the times we get the below exception while opening Graphical Process modeler because the IP address in the below URL is not correct. Sterling Integrator host address and GPM host address different then we need to fix the host name and make it common.

com.sun.deploy.net.FailedDownloadException: Unable to load resource:http://***.***.***.***:24000/gbm/pmodeler/ProcessModeler.jnlp
    at com.sun.deploy.net.DownloadEngine.actionDownload(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
    at com.sun.javaws.Launcher.updateFinalLaunchDesc(Unknown Source)
    at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
    at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
    at com.sun.javaws.Launcher.launch(Unknown Source)
    at com.sun.javaws.Main.launchApp(Unknown Source)
    at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
    at com.sun.javaws.Main$1.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

How to Fix:

       1. Stop Sterling Integrator.
       2. <SI_Install>/bin folder and execute the below commnad.
       3. <SI_Install>/bin> patchJNLP.cmd <put your hostname here>
       4. Start the Sterling Integrator and go to Business Process Manager and Run Graphical Process Modeler. (Don't use old jnlp file and download fresh copy) 

Appreciations from Client CEVA Logistics while working with HCL Technologies

Client Appreciation 1 :

 https://drive.google.com/file/d/0B3nX0RX3bAe1d05FQ2VFaS1kbWc/view?usp=sharing


Client Appreciation 2 :

https://drive.google.com/file/d/0B3nX0RX3bAe1ZkxfcjFhdldZSDg/view?usp=sharing


Internal HCL Technologies Appreciation  :

https://drive.google.com/file/d/0B3nX0RX3bAe1OGdlVlRia0RyM3c/view?usp=sharing

Client Appreciation 6 :

https://drive.google.com/file/d/0B3nX0RX3bAe1bmN0T3IzYW94S2c/view?usp=sharing


Still 5 more appreciations need to update  ...... (Continued ..)

Sterling File Gateway Concepts

Sterling file gateway ■ 

An MFT solution designed on top of Sterling B2B foundation for transferring files between partners using different protocols, file naming conventions, and file formats. ■ Has following features –Scheduled high volume - high frequency file transfers –File and File name Transformations –File Transfer Visibility (file route and events reports) –Replay / Re-delivery –Notifications (partners and operators) –Broad Communications Protocol Support (FTP, FTP/S, SSH/SFTP, SSH/SCP, and Sterling Connect:Direct) –Dynamic Routing –Easy-to-use Partner Onboarding UI –Flexible Mailbox Structures (to support pattern matching) ■ Works on the basis of predefined business processes ■ Has a web browser based Partner interface named myFileGateway –The partner can upload files using this UI which can then be routed using protocol adapters like FTP/SFTP –Partner can subscribe to notifications

Important Sterling Integrator Concepts

SFTP concept in Sterling Integrator


The following keys are used to allow an SFTP Client adapter to connect with a
remote SFTP server.

*** User Identity Key – Private/Public key pair used to identify Sterling Integrator
as a user on a remote server. Generate this key within Sterling Integrator and
provide the public part of the key to your trading partner.

*** Known Host Key – Public key used to authenticate remote SFTP servers to
Sterling Integrator’s SFTP Client adapter. Request this key from your trading
partner.

The following keys are used by the SFTP Server adapter to allow connections from
remote clients:

*** Authorized User Key – A public key used to authenticate remote users to
Sterling Integrator SFTP Server adapters. One one or more Authorized User keys
can be associated with a user account. Request the key(s) from your trading
partner and include the key(s) in their Sterling Integrator user account.
*** Host Identity Key – Private/Public key pair used to identify the Sterling
Integrator SFTP Server adapter to remote clients. Generate this key within
Sterling Integrator.

Perimeter Server ■ Perimeter server is a software for communications management that –manages the communications flow between outer layers of your network and the TCP-based transport adapters –can be installed in a DMZ (De-Militarized Zone – the zone between a trusted internal network and an untrusted external network Eg: internet) –Provides security and scalability

HTTP Server Adapter ■ The HTTP Server Adapter is based on jetty http engine and provides support for HTTP protocol in the following way –You can run a full fledged web application from a WAR file –You can run a Business Process with the incoming data as primary document ■ It provides a URI based configuration for routing data –The adapter listens on a configured port and can accept simple TCP or secure SSL/TLS connection based on how it is configured –The incoming HTTP request is routed to configured BPs or WAR applications based on URI

HTTP Client Adapter ■ HTTP Client Adapter provides client capabilities in the following way –Scriptable using Business process (BPML) in SI and available in the GPM –Connects to the configured host and sends/receives business data using the HTTP protocol –Supports GET and POST Http methods and secure SSL connections (https) –Supports connecting through a HTTP proxy ■ The client adapter supports big payloads (tested up to 2 GB) and supports more than 150 concurrent transfers

SFTP Server Adapter ■ SFTP Server adapter provides secure file transfer support with SFTP protocol –Works on top of Secure SHell (SSH) protocol for transport security –Uses SSH Host Identity keystore (private keys) and Authorized User key store (public keys) in SI for SSH keys –Capable of exposing a Mailbox or an actual (native) file system directory as the SFTP file system to the connected user –Supports restrictions via Virtual Roots and adapter policies (more on policies later)

SFTP Client Adapter ■ SFTP Client Adapter provides client capabilities in the following way –Scriptable using Business process (BPML) in SI and is available in the GPM –Connects to the configured host and executes specified SFTP commands –Supports SFTP commands like cd, list, get, put, delete, pwd, mkdir, rmdir, move that help in sending/retrieving/organizing business data in the partner's SFTP server –Supports connecting through a HTTP proxy

FTP Server Adapter ■ FTP Server adapter provides support for sending/receiving files using the the FTP protocol –Exposes a Mailbox or an actual (native) file system directory as the FTP file system to the connected user –Supports a large set of FTP commands (rfc 959) –Supports secure SSL/TLS connections (FTPS) –Supports restrictions via Virtual Roots and adapter policies (more on this later) –Supports User Exits (custom code execution on FTP events)

FTP Client Adapter ■ FTP Client Adapter provides client capabilities for the FTP protocol in the following way –Scriptable using Business process (BPML) in SI and is available in the GPM –Connects to the configured host and executes specified FTP commands –Supports FTP commands like cd, list, get, put, delete, pwd, site, quote, move that help in sending/retrieving/organizing business data in the partner's FTP server –Supports FTPS (FTP over SSL) for transport security ■ Tested with large files up to 15 GB

Sterling Inegrator Map Editor Issues

Issue 1 : 

Map Test is not working

Error Message
 

Error: Failed opening socket; No connection could be made because the target machine actively refused it.

Reason : 

Map Test Http Server Adapter is disabled in Services Configuration in SI dashboard

Resolution :

Need enable the "Map Test Http Server Adapter" service