IBM SI/SFG EDI TO XML Mapping

IBM SI/SFG EDI TO XML Mapping

You need to have schema to load the target side XML. Select the schema (XSD) if you have. If not use any of the tool like stylusstudio to create XSD
Load the complete XSD
On the target side X12 root element properties,
1. select prolong specified
2. Select One element per line
3. Select the check box Use character entity references
4 Make sure TS_850 or GS or ISA do not repeat multiple times
On the source side
1. Select the Root segment properties
2. Specify the delimiters

Windows NonCluster SQL Server with SI 5.2.6 Steps

1. Check the Collation.
    A. From the SQL Server Management Studio, Right click on the selected database.
   B. On Options menu, set the Collation to SQL_Latin1_General_CP850_Bin
2. Install the required JDBC driver. In this case for this version, the JDBC version is 4.0. Just unzip the downloaded driver package which will have sqljdbc4.jar
3. Follow the Installation check list prepared on IBM Sterling Integration documentation website.
4. Install the IBM JDK
5. Install the Installation Manager
6. Make sure to show the path of the JDK upto bin without including bin
like -- C:\Program Files\IBM\Java70
7. Make sure you do not have spaces in the binraries path or in installation paths.

Axway Decision Insight - How to change/correct the ClusterID

DON'T DO -
If your installation is done with a wrong cluster ID and later when you changed it in platform.properties the application will not come back up during the next restart.

To fix this, I changed the correct cluster ID in metadata.txt in all the below directories but did not work.

C:\ADI\DecisionInsight-20160905-01\var\data\titanium-temporal\partition-0\checkpoint\tt.....

C:\ADI\DecisionInsight-20160905-01\var\data\titanium-temporal\configuration\checkpoint\tt0..

C:\ADI\DecisionInsight-20160905-01\var\data\calcium\checkpoint\tt..

I deleted all the checkpoints and also bunldes directories from C:\ADI\DecisionInsight-20160905-01\var\tmp\felix directory.

Generated new admin hash by running tnd-generate-admin-hash.bat

Started the application. It worked but all my configuration data is lost.

****************************************************************

Map Editor unable to test

Error: Unable to load Java Virtual Machine. Error code 126.

Resolution: For SI 5.2.6.1 - Map Editor you need to have 32 bit java. It can be Oracle java. If you have multiple Java versions to use then, copy the JRE path till bin directory and then add that into the PATH environment variable.

1. Right click on My computer and click on Properties.
2. On the Advanced system properties->Environment variables-> Add the JRE 1.7 path till bin directory. This path should be in front of any other JRE path. TO test whether it is set correctly just run on command prompt->java -version.

Ex:C:\Program Files (x86)\Java\jre7\bin

incompatible lang setting on linux

Problem: incompatible lang setting on linux
Resolution:

1 If the base locale for the system is English, edit
the /etc/sysconfig/i18n file by changing the LANG
variable from en_US.utf8 to en_US.
Save and close the /etc/sysconfig/i18n file.
2 Reboot the system.

****************


Problem:

You may get error like below during SI 5.2.6 installation:

Your Current JVM information :
=============================
Found Oracle(Sun) JDK
JDK Vendor : Oracle Corporation
JDK version not supported.

OR

Your Current JVM information :
=============================
JRE 1.7.0 IBM J9 2.7 Windows Server 2012 R2 amd64-64 Compressed References 20150407_243189 (JIT enabled, AOT enabled)
J9VM - R27_Java727_SR3_20150407_1831_B243189
JIT  - tr.r13.java_20150406_89182
GC   - R27_Java727_SR3_20150407_1831_B243189_CMPRSS
J9CL - 20150407_243189
=============================
***********************
Validating for : IBM-1.7-SR5
Checking for valid JDK Vendor....IBM
Found valid JDK vendor IBM
Checking for valid JDK Version....1.7
Found valid JDK version 1.7
Checking for valid JDK minor version....SR5
JDK minor version is not supported.


OR

Your Current JVM information :
=============================
JRE 1.7.0 IBM J9 2.7 Windows Server 2012 R2 x86-32 20150407_243189 (JIT enabled, AOT enabled)
J9VM - R27_Java727_SR3_20150407_1831_B243189
JIT  - tr.r13.java_20150406_89182
GC   - R27_Java727_SR3_20150407_1831_B243189
J9CL - 20150407_243189
=============================
***********************
Validating for : IBM-1.7-SR5
Checking for valid JDK Vendor....IBM
Found valid JDK vendor IBM
Checking for valid JDK Version....1.7
Found valid JDK version 1.7
Checking for valid JDK minor version....SR5
JDK minor version is not supported.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Please upgrade your JDK to supported version as per the documentation.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
JDK version not supported.


Resolution:

Use the IBM java instead of SUN java. Download SDK_5020600.zip and extract that java.

How to change the ICONs on the top bar

Hi All,

To change the ICON with your customized ICON on the SI dashboard, please find the ICON in the below location.

ICON name: topbar_sub_integrator, Integrator_login
Installation folder:

\SI51\install\noapp\deploy\dashboard\webapp\images

You may need to use ms paint to save your customized ICON in gif format.

Also check this, I am not sure how to change the second half of the header

C:\SI51\install\noapp\deploy\dashboard\webapp\WEB-INF\templates\jsp\screens\html\Login.jsp

Perimeter Installation on Windows 64 bit OS

                               Perimeter Installation on Windows 64 bit OS

       I.          Install the same JDK version that SI is running on preferably.

     II.          Make sure you know whether it is a 32 bit or 64 bit version of Windows If you are installing in Windows.

    III.          Before you install the perimeter server, you need to gather the following information and answer the following questions:

Table 1.0 Simple Table for myself to understand easily

Perimeter Server Information Gathering Checklist	Your Notes
Path to java	C:\Program Files\Java\jdk1.6.0_31
Path to the Sterling B2B Integrator installation directory	C:\perimeter1
Will this perimeter server be installed in a less secure network?	NO
Please enter the network address that integration server (SI) will listen on for the connection from this server: (Sterling B2B Integrator host IP)
Please enter the port that integration server (SI) will listen on for the connection from this server: (Sterling B2B Integrator side Listen port)	9070
Please enter the local port that perimeter will use for the connection to the integration server (SI): (Perimeter server side listening port)	9060

I believe there are some documentation errors from the website.

1.      Do not create the perimeter server directory before you run the installation.  Because, PS code will estimate the size on the disk.

2.      Also, the second point “Path to the Sterling B2B Integrator installation directory” is not the right word in website check list. It should be the path to perimeter server installation directory.

In my example, I am expecting my HTTP data on port 9080.

On Sterling B2B Integrator side, I am listening on port 9070 from Perimeter.

On Perimeter side, Perimeter will listen on the port 9060 from Sterling B2B Integrator.

Installation:

Open the command prompt by “Run as Administrator”. Navigate to Java/bin folder.

Note down the path to the folder ps_4500.jar file which you either copied from Sterling B2B integrator (\install\packages) or from the CD.

Just give your Sterling B2B Integrator Host if no proxy is involved between.

v  Do not run the installPS.cmd now.

v  Just open the installPS.cmd in a text editor. Just change the below value from false to true.

java_64_bits=true.
Now run the installPS and startPSservice.