Upgrade WebLogic Manually from 6.5.x to 7.0.x

This section provides you the steps to upgrade Kony MobileFabric Integration Service manually from 6.5.x to 7.0.x on WebLogic application server.

Prerequisites

The following table displays the prerequisites for upgrading Kony MobileFabric Integration Service. Assuming that you have already installed Kony MobileFabric Integration Service and have setup the required Databases (Reports and Admin).

Artifacts	Type	Purpose
Flyway scripts Scripts to migrate from 6.5.x to 7.0.x	Flyway Scripts	To setup the required schema
admin.war middleware.war services.war	WAR files	To be deployed to Application Server
Flyway tool	version 3.2.1	https://flywaydb.org/getstarted/download.html

Backup

1. Stop the application server.
   1. Take a backup of the following files. These file are available at <Weblogic_install_dir>\user_projects\domain\your_domain
      1. .WAR files
         • middleware.war
         • admin.war
         • services.war
         • metrics.ear (applicable only for metrics).
2. After taking the backup, delete or uninstall the above files.

Migrating Database from 6.5.x to 7.0.x

Migrating database from 6.5.x to 7.0.x is done using flyway tool.

• Download your Flyway tool from https://flywaydb.org/getstarted/download.html
• Download your DB specific migration scripts.

Migrating Admin Database

To migrate admin DB, follow these steps:

1. Open V3_konyadmin-xxxx-7.0.0.0.sql. xxxx is the type of DB you are using.

Example: MS-SQL V3__konyadmin-sqlserver-7.0.0.0.sql. Similarly for My SQL, V3__konyadmin-mysql-7.0.0.0.sql etc.

2. In the V3_konyadmin-xxxx-7.0.0.sql, replace all KONY_SERVER place holders with the actual values from your middleware.properties file.

Example: ‘${KONY_SERVER_RICH_CLIENT_DEPLOY}' => ‘corresponding_value_in_your_middleware.properties’

Note: If no values are assigned in middleware.properties, set those values to null in the SQL files.
Example: In middleware.properties, if you have
#Memcache configuration=
#memcache.cluster=
Then in SQL files, set the placeholders value as null.

Important: For null values, remove the colon ' '.

3. After editing, the V3-xxx.sql script, place all the scripts into SQL folder in flyway installation directory.

   Example: \flyway-commandline-3.2.1-windows-x64\flyway-3.2.1\sql

4. Executing the scripts– Before executing the scripts, configure flyway to your database.

5. Open flyway.conf from \flyway-commandline-3.2.1-windows-x64\flyway-3.2.1\conf
6. Edit the following variables. Un-comment them after editing

   • flyway.url=<your jdbc URL> example for MySQL, it is flyway.url=jdbc:mysql://<IP>:<PORT>.

   • flyway.driver=<SQL DRIVER>

   • flyway.user

   • flyway.password

   • flyway.schemas= <your admin Database name>

   • flyway.baselineVersion=3

7. Open the command line and type cd to \flyway-commandline-3.2.1-windows-x64\flyway-3.2.1.

8. Execute the command flyway repair followed by flyway migrate.

9. You admin database is now migrated to 7.0.

Migrating Reports Database

To migrate your reports database, follow these steps:

1. Download the flyway scripts with respect to the type of database you are using (Oracle, MySQL, SQL) of 7.0.

2. Place the downloaded scripts in \flyway-commandline-3.2.1-windows-x64\flyway-3.2.1\sql.

3. Open flyway.conf from \flyway-commandline-3.2.1-windows-x64\flyway-3.2.1\conf.

4. Edit the following variables. Un-comment them after editing and save the file.

   • flyway.url=<your jdbc URL> example for MySQL, it is flyway.url=jdbc:mysql://<IP>:<PORT>.

   • flyway.driver=<SQL DRIVER>

   • flyway.user

   • flyway.password

   • flyway.schemas= <your Reports Database name>

   • flyway.baselineVersion=3

5. Execute the flyway repair followed by flyway migrate as you have done with Admin Database.

6. Your Reports database in now migrated to 7.0.

Migrating WAR files

1. Download admin.war, middleware.war and services.war of 7.0.

2. Remove the old admin, middleware and services WAR files in deployments folder from <install_location>\deployments after taking the backup by following these steps:

   1. Go to Deployments page in WebLogic console.

   2. Select the older admin, middleware and services WAR files and click Delete to delete them.
   3. Deploy new admin.WAR, middleware.WAR and services.WAR files by following these steps:
      • In Deployments page, click Install in the Deployments section.
      • Click Upload your files.
      • Click Choose file in Deployment Archive.
      • Locate the WAR files to upload and click Next.

      • Select Install this deployment as an application and click Next.

      • Select the cluster or servers you want to deploy the WAR and click Next.

      • Click Next again and click Finish.
      • Repeat the above steps to deploy all the WAR files.

Verification

Verify the upgrade process by logging into the console and look for Server Version and Health Check.

To verify the upgrade process  

1. Access the URL http://ipaddress:port/middleware/version.html in a browser.
2. Navigate to the URL http://ipaddress:port/admin/version.html and look for server version.
3. Navigate to Settings and click Health Check and look for Report DB, Admin DB and Reporting Queue. Note that the status should be in PASSED state.

4. Navigate to Settings and click Configuration.

   

   Note: Access to Reporting Queue will be green only if you have configured metrics and the JMS server is up and running.

Copyright © 2013 Kony, Inc. All rights reserved.