Migration from 6.2.1 to 6.2.2

• Make a backup!!!

• Go to Administration > Database Query and execute these SQL sentences:

UPDATE OKM_CRON_TAB SET CT_NAME='User Items Serialize' WHERE CT_NAME='UserItemsSerialize';
UPDATE OKM_CRON_TAB SET CT_NAME='User Mail Importer' WHERE CT_NAME='UserMailImporter';
UPDATE OKM_CRON_TAB SET CT_NAME='Text Extractor Worker' WHERE CT_NAME='TextExtractorWorker';
UPDATE OKM_CRON_TAB SET CT_NAME='Repository Info' WHERE CT_NAME='RepositoryInfo';
UPDATE OKM_CRON_TAB SET CT_NAME='Session Watchdog' WHERE CT_NAME='SessionWatchdog';
UPDATE OKM_CRON_TAB SET CT_NAME='Datastore Garbage Collector' WHERE CT_NAME='DataStoreGarbageCollector';

• Stop Tomcat

• Edit OpenKM.cfg and set hibernate.hbm2ddl to update

• Replace the OpenKM.war

• Run from your preferred SQL client these queries:

hsql

ALTER TABLE OKM_NODE_NOTE ALTER COLUMN NNT_TEXT CLOB;

MySQL

alter table OKM_NODE_NOTE modify NNT_TEXT longtext;

PostgreSQL

alter table OKM_NODE_NOTE alter NNT_TEXT TYPE text;

• Start Tomcat again

• The following configuration properties are deprecated:
  • managed.text.extraction.schedule
  • schedule.repository.info
  • schedule.mail.importer

• Go to Administration > Database Query and execute these SQL sentences:

• • Delete obsolete configuration properties to avoid confusion:

DELETE FROM OKM_CONFIG WHERE CFG_KEY='managed.text.extraction.schedule';
DELETE FROM OKM_CONFIG WHERE CFG_KEY='schedule.repository.info';
DELETE FROM OKM_CONFIG WHERE CFG_KEY='schedule.mail.importer';

• • Delete obsolete translations to avoid confusion:

delete from OKM_TRANSLATION where TR_KEY='fileupload.send';

• Enjoy OpenKM 6.2.2!

If you have any weird problem try to stop Tomcat, delete these folders:

• $TOMCAT_HOME/webapps/OpenKM
• $TOMCAT_HOME/work/Catalina/localhost

And start Tomcat again.

Recommended to clear browser cache and Java Plugin cache