How to Upgrade from Knowage 6.1.1 CE to Knowage 6.2.0-RC CE

Question

Dear Experts,

I want to upgrade the Knowage 6.1.1 version to latest 6.2.0 version, could you please let me know how to upgrade it.

Thanks,

Iftikhar

Answer 1

Dear,

In order to update a previous instance of Knowage 6.1 to 6.2 you have to:

Downalod from https://www.knowage-suite.com/site/ce-download/ :

• The new WAR Packages: all files  knowage*.war
• The New Metadata DataBase Script, the DDL to upgrade the knowage database used by knowage 6.1

From:

Inside mysql-mariadb-dbscripts-6_2_0_20180719.zip you can find the DDL MySQL_upgradescript_6.1_to_6.2.sql, you have to execute the DDL on knowage database ( remember to make a backup copy before ).

Obviously if you are using Oracle or PostgreSQL download : oracle-dbscripts-6_2_0_20180719.zip or postgres-dbscripts-6_2_0_20180719.zip

The upgrade process is:

1. Stop Tomcat
2. Make a backup copy of your installation and related knowage database.
3. Remove the old knowage*.war and knowage* directory under <Tomcat>/webapps
4. Clean the <Tomcat>/TEMP and <Tomcat>/WORK directory
5. Copy the new knowage*.war inside <Tomcat>/webapps direcotry
6. Execute the MySQL_upgradescript_6.1_to_6.2.sql DDL
7. Start Tomcat
8. After the first installation you have to check:
   1. If you don’t use MariaDB or MySQL to store knowage database you have to change all the hibernate.cfg.xml  (https://knowage-suite.readthedocs.io/en/latest/installation-guide/manual-installation.html#configuration-of-the-metadata-db-dialect) and change the quartz configuration (https://knowage-suite.readthedocs.io/en/latest/installation-guide/manual-installation.html#modification-of-the-quartz-configuration)
   2. If you’ve added some JNDI Data Source on Knowage 6.1, you have to update all the /META-INF/context.xml

Remember to restart Tomcat after changes related to point 7.

Let me Know if you’ll found problems.

Best Regards

Angelo