Sterling Integrator Map editor issue --- Runtime Error!

Issue :

I got below error while opening the map using map editor

Cause :

I have changed backup file of the map from .BAK to .MXL format and I have tried to open the map but I got error as above.

Resolution :

After changing the format of map , then need to open that map in notepad or notepad++ or any text editing tool. It will be look like as below

Once it is opened then need to save as that map as .MAP format. Then you can able to continue with mapping or testing as per your requirement. You won't loose any existing mapping or coding in the map

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)