Knowledge:Migration from 6.2.4 to 6.2.5

• See changelog at Mantis

• Download update from http://openkm.com/download/okm/OpenKM-6.2.5.zip

• Make a backup!!!

• Stop Tomcat

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

• Replace the OpenKM.war

• Review file descriptor limit and, eventually, increase it.

• Start Tomcat again

• Set installation customer at License Manager.

• 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';

Register new automation and select available which have okm:folder should be 4 ( otherside there's some problem )

INSERT INTO OKM_AUTO_METADATA (AMD_AT, AMD_CLASS_NAME, AMD_NAME, AMD_GROUP, AMD_TYPE00, AMD_SRC00, AMD_DESC00, AMD_TYPE01, AMD_SRC01, AMD_DESC01 ) VALUES ('post','com.openkm.automation.validation.HasCategory', 'HasCategory', 'validation', 'text', 'okm:folder', 'String', '', '', '');
SELECT * FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder';

From SQL get some values to be added on script:

SELECT CONCAT('map.put("',AVP_PARAM,'",OKMRepository.getInstance().getNodeUuid(null, "',AVP_PARAM,'");') FROM OKM_AUTO_VALIDATION_PARAMS where AVP_VALIDATION in (SELECT AVL_ID FROM OKM_AUTO_VALIDATION where AVL_TYPE in (SELECT AMD_ID FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder'));

Add the results of the last query in the script and execute. You'll get update SQL that should be executed to update the automation params converting path to UUID.

import com.openkm.api.OKMRepository;
import java.util.*;

Map map = new HashMap();
// ADD HERE THE RESULTS OF THE LAST QUERY !!!!!
// map.put("/okm:root/test/", OKMRepository.getInstance().getNodeUuid(null, "/okm:root/test/"));
for (String path : map.keySet()) {
    print("UPDATE OKM_AUTO_VALIDATION_PARAMS SET AVP_PARAM='"+map.get(path) +"' WHERE AVP_PARAM='" +path+"' and AVP_ID in (SELECT AVP_ID FROM OKM_AUTO_VALIDATION_PARAMS where AVP_VALIDATION in (SELECT AVL_ID FROM OKM_AUTO_VALIDATION where AVL_TYPE in (SELECT AMD_ID FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder')));");
}

• Go to Administration > Utilities > Cache Stats and reset the cache identified as xx.xx.xx.

• Enjoy OpenKM 6.2.5!

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 (prevents "The response could not be deserialized" errors) and Java Plugin cache