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.

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