Sunday, December 13, 2015

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

Friday, August 28, 2015

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.




Friday, August 21, 2015

Sterling Integrator installation and starting problems

I installed SI on Java 32 bit and it installed successfully but I was unable to start the server. There were no logs created apart from one "servicelist" which shows windows services.

Later when I installed SI on Java 64 bit it is successful.
*************************************************************************
External host name and port is important.

If you install SI with hostname as localhost then the installation may work fine. When we wanted to run the GPM from any other computer then we see issue in connecting. So it is suggested to give the proper host name during the installation itself.


The ProcessModeler.jnlp.in file is accessed from E:\IBM\SterlingIntegrator\install\noapp\deploy\gbm\webapp\pmodeler. It looks like below.

<jnlp spec="1.0+" codebase="http://&EXT_HOST_ADDR;:&DAV_PORT;/gbm/pmodeler" href="ProcessModeler.jnlp" version="1.0">
    <title>Modeler-&HOST_NAME;-&WEBAPP_LIST_PORT;</title>
        <argument>&EXT_HOST_ADDR;</argument>

Where the EXT_HOST_ADDR is defined in sandbox.cfg file.
Open the file and change this value
EXT_HOST_ADDR=Your hostname

Run the setupfiles.

*************************************************************************
Installation Steps followed on Windows Non Cluster

1. Install the database. If it is Oracle, run the below DB script. This works for SI 5.1 and 5.2.6.2 as of today. For production environments, please refer the Oracle tuning parameters to setup.

create user siadmin identified by Welcome1;
grant resource to siadmin;
GRANT "CONNECT" TO siadmin;
GRANT SELECT_CATALOG_ROLE TO siadmin;
ALTER USER siadmin DEFAULT ROLE "CONNECT", SELECT_CATALOG_ROLE;
GRANT CREATE PROCEDURE TO siadmin;
GRANT CREATE TRIGGER TO siadmin;
GRANT CREATE TYPE TO siadmin;
GRANT EXECUTE ANY PROCEDURE TO siadmin;
GRANT EXECUTE ANY TYPE TO siadmin;
GRANT SELECT ANY TABLE TO siadmin;
GRANT SELECT ANY DICTIONARY TO siadmin;
grant create any table to siadmin;
grant insert any table to siadmin;
grant update any table to siadmin;
grant create any view to siadmin;
grant create any synonym to siadmin;
grant create session to siadmin;
grant create any sequence to siadmin;
grant alter session to siadmin;
GRANT SELECT ON CTXSYS.CTX_USER_INDEXES TO siadmin;
GRANT SELECT ON SYS.DBA_DATA_FILES TO siadmin;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO siadmin;
GRANT SELECT ON SYS.DBA_USERS TO siadmin;
GRANT SELECT ON SYS.V_$PARAMETER TO siadmin;

2. Get the IBM Java from IBM site
3. Start the Installer


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

Friday, January 16, 2015

Sterling Integrator 5.1 GPM does not start

Hi All,

Recently, One of my friend installed Sterling Integrator 5.1 on Windows 2008 R2 server. The installation went well and it took almost 20 minutes.

After the installation, accessed the dashboard on the port 15000 (http://localhost:15000) with default username admin and password as password. He wanted to run GPM. So, navigated to Business Process module and clicked on Manager and then clicked on Run Graphical Process Modeler - Go button.

He do not remember exact words in the exception but it sounds more of like below.

The first exceptiont is "You are seeing this message because either Java 5 is not installed on your system or, you are using older version of Java web start. Please download the java 1.5 from http://java.sun.com". 

I was surprised to see this message because JRE 1.6 is already running on my server. SI 5.1 requires JDK 1.6.0_14. So when we install JDK it also installs JRE then why the above exception occurred. 

The reason behind is Java Web Start is not running even though we installed JDK and JRE.

Go to the installed JDK folder (something like C:\Program Files\Java\jdk1.6.0_14\bin) and find javaws.exe file. Run this file as an administrator. When you run this file it prompts with pop-up that shows the options and parameters to supply. 

After that he went back to the SI dashboard and click on "Run Graphical Process Modeler - Go button"

He got an exception - "unable to launch GPM". When I see the details, it is trying to connect to http://java.sun.com and download  through the JNLP file.

To let JNLP know where my Java WS is running, I opened the command prompt as an administrator.

Navigated to JDK bin folder to run Java WS with arguments. 

Command entered is: javaws -offline requiredjnlpfile

like this:  javaws -offline C:\SI51\install\noapp\deploy\gbm\webapp\pmodeler\ProcessModeler.jnlp

Now GPM is started successfully.

Note: The environment I dealt with is Windows 2008 R2, Oracle 10.1. version, 64 bit OS, SI 5.1, JRE 1.6.0_14.

For any questions: meduri.phanendra@gmail.com

http://silearning.freeforums.net