Difference between revisions of "Knowledge:Migration from 6.4.1 to 6.4.2"

From OpenKM Documentation
Jump to: navigation, search
(→‎Task 8 - UPDATE SIZE)
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{{Note|OpenKM 6.4.2 is currently under development.}}
+
* See [http://issues.openkm.com/changelog_page.php?version_id=76 changelog at Mantis]
−
 
 
−
* See [http://issues.openkm.com/changelog_page.php?version_id=71 changelog at Mantis]
 
  
 
* Download update from http://openkm.com/download/okm/OpenKM-6.4.2.zip (eMpg8eIjY5)
 
* Download update from http://openkm.com/download/okm/OpenKM-6.4.2.zip (eMpg8eIjY5)
Line 7: Line 5:
 
* Make a backup!!!
 
* Make a backup!!!
  
−
== Task 1 ==
+
== Task 1 - Install jdk 1.7 ==
 +
Is mandatory install jdk 1.7 otherside application will not be deployed.
  
 +
== Task 2 - Automation classes automatic loaded ==
 
* '''All OKM_NODETYPE* tables should be deleted'''
 
* '''All OKM_NODETYPE* tables should be deleted'''
 
* '''All OKM_TASK_MANAGER* tables should be deleted'''
 
* '''All OKM_TASK_MANAGER* tables should be deleted'''
  
 +
'''HSQL'''
 +
<source lang="sql">
 +
DROP TABLE OKM_NODE_TYPE;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_USER;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_ROLE;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_RECORD;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_MAIL;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_FOLDER;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_DOCUMENT;
 +
DROP TABLE OKM_TASK_MANAGER_TASK;
 +
DROP TABLE OKM_TASK_MANAGER_PROJECT;
 +
DROP TABLE OKM_TASK_MANAGER_STATUS;
 +
</source>
 +
'''
 +
MySQL'''
 +
<source lang="sql">
 +
SET FOREIGN_KEY_CHECKS=0;
 +
DROP TABLE OKM_NODE_TYPE;
 +
SET FOREIGN_KEY_CHECKS=1;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_USER;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_ROLE;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_RECORD;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_MAIL;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_FOLDER;
 +
DROP TABLE OKM_TASK_MANAGER_TASK_DOCUMENT;
 +
DROP TABLE OKM_TASK_MANAGER_TASK;
 +
DROP TABLE OKM_TASK_MANAGER_PROJECT;
 +
DROP TABLE OKM_TASK_MANAGER_STATUS;
 +
</source>
  
−
== Task 2 - Update Automation now classes are loaded automatically ==
+
== Task 3 - Update Automation now classes are loaded automatically ==
 
* '''Migration of automation step 1'''
 
* '''Migration of automation step 1'''
 +
'''HSQL'''
 
<source lang="sql">
 
<source lang="sql">
 
SELECT AAC_ID, AAC_TYPE, 'UPDATE OKM_AUTO_ACTION set AAC_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AAC_TYPE) || ''' where AAC_ID=' || AAC_ID || ';'  FROM OKM_AUTO_ACTION;
 
SELECT AAC_ID, AAC_TYPE, 'UPDATE OKM_AUTO_ACTION set AAC_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AAC_TYPE) || ''' where AAC_ID=' || AAC_ID || ';'  FROM OKM_AUTO_ACTION;
 
SELECT AVL_ID, AVL_TYPE, 'UPDATE OKM_AUTO_VALIDATION set AVL_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AVL_TYPE) || ''' where AVL_ID=' || AVL_ID || ';' FROM OKM_AUTO_VALIDATION;
 
SELECT AVL_ID, AVL_TYPE, 'UPDATE OKM_AUTO_VALIDATION set AVL_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AVL_TYPE) || ''' where AVL_ID=' || AVL_ID || ';' FROM OKM_AUTO_VALIDATION;
 +
</source>
 +
 +
'''MYSQL'''
 +
<source lang="sql">
 +
SELECT AAC_ID, AAC_TYPE, CONCAT('UPDATE OKM_AUTO_ACTION set AAC_CLASS_NAME=''',(SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AAC_TYPE),''' where AAC_ID=',AAC_ID,';')  FROM OKM_AUTO_ACTION;
 +
SELECT AVL_ID, AVL_TYPE, CONCAT('UPDATE OKM_AUTO_VALIDATION set AVL_CLASS_NAME=''',(SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AVL_TYPE),''' where AVL_ID=',AVL_ID,';') FROM OKM_AUTO_VALIDATION;
 
</source>
 
</source>
  
Line 28: Line 64:
 
UPDATE OKM_CONFIG SET CFG_KEY='text.banner' WHERE CFG_KEY='logo.banner';
 
UPDATE OKM_CONFIG SET CFG_KEY='text.banner' WHERE CFG_KEY='logo.banner';
 
UPDATE OKM_CONFIG SET CFG_KEY='text.welcome' WHERE CFG_KEY='logo.welcome';
 
UPDATE OKM_CONFIG SET CFG_KEY='text.welcome' WHERE CFG_KEY='logo.welcome';
 +
UPDATE OKM_CONFIG SET CFG_TYPE='string' WHERE CFG_KEY='max.file.size';
  
−
-- Workflow
+
-- Mail account seen
−
UPDATE OKM_PROFILE SET PRF_DB_WORKFLOW_VIS='F';
+
ALTER TABLE OKM_MAIL_ACCOUNT DROP COLUMN MA_MMARK_SEEN;
−
UPDATE OKM_PROFILE SET PRF_MN_FI_START_WORKFLOW_VIS='F';
 
−
UPDATE OKM_PROFILE SET PRF_TB_START_WORKFLOW_VIS='F';
 
 
</source>
 
</source>
  
Line 59: Line 94:
 
</source>
 
</source>
  
−
 
+
== Task 4 - Update OCR Template, now classes are loaded automatically ==
−
== Task 3 - Update OCR Template, now classes are loaded automatically ==
 
 
<source lang="sql">
 
<source lang="sql">
 
drop table OKM_OCR_TEMPLATE_METADATA;
 
drop table OKM_OCR_TEMPLATE_METADATA;
 
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.StringParser' WHERE OTF_TYPE='1';
 
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.StringParser' WHERE OTF_TYPE='1';
−
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.NumberParser' WHERE OTF_TYPE='2'
+
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.NumberParser' WHERE OTF_TYPE='2';
−
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.DateParser' WHERE OTF_TYPE='3'
+
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.DateParser' WHERE OTF_TYPE='3';
 
</source>
 
</source>
  
−
'''HSQL'''
+
'''All databases'''
 
<source lang="sql">
 
<source lang="sql">
 
ALTER TABLE OKM_OCR_TEMPLATE_FIELD DROP COLUMN OTF_TYPE;
 
ALTER TABLE OKM_OCR_TEMPLATE_FIELD DROP COLUMN OTF_TYPE;
 
</source>
 
</source>
  
−
 
+
== Task 5 ==
−
== Task 4 ==
 
 
* Check for database errors:
 
* Check for database errors:
  
Line 80: Line 113:
 
$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log
 
$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log
 
</source>
 
</source>
 +
 +
== Task 6 - Folder style default value==
 +
Go to administration->database query and execute ( set default folder style=0)
 +
 +
'''All databases'''
 +
<source lang="sql">
 +
update OKM_NODE_FOLDER SET NFL_STYLE=0;
 +
 +
-- If have several tennats should be added for each tenant
 +
-- IMPORTA IF YOU'RE IN HSQL SHOULD ( 2GB hsql limitation -> divide in several files ):
 +
-- 1-> In database sql SHUTDOWN COMPACT ( connection i closed and file compacted )
 +
-- 2-> Restart OpenKM
 +
-- 3-> Execute the query, probably now goes right read http://sourceforge.net/mailarchive/forum.php?forum_name=hsqldb-user&max_rows=25&style=nested&viewmonth=200602
 +
 +
INSERT INTO OKM_FOLDER_STYLE (FS_ID, FS_TENANT, FS_NAME,FS_RD_CHILD_IMG_CONT, FS_RD_CHILD_IMG_MIME,FS_RD_CHILD_SUB_IMG_CONT, FS_RD_CHILD_SUB_IMG_MIME,FS_RD_EMPTY_IMG_CONT, FS_RD_EMPTY_IMG_MIME,FS_RD_EMPTY_SUB_IMG_MIME, FS_RD_EMPTY_SUB_IMG_CONT,FS_WR_CHILD_IMG_CONT, FS_WR_CHILD_IMG_MIME, FS_WR_CHILD_SUB_IMG_CONT, FS_WR_CHILD_SUB_IMG_MIME, FS_WR_EMPTY_IMG_CONT, FS_WR_EMPTY_IMG_MIME, FS_WR_EMPTY_SUB_IMG_MIME, FS_WR_EMPTY_SUB_IMG_CONT, FS_COMPLETE) VALUES ('1', '1', 'Default','R0lGODlhDwANAKUrAI8ZLJ8dL54gNbkVKKYkMJ8nNdAWH9UVHq4kOK0rOr4kNa0vPrQyO/8VG7wyOLwyP8Q2PcQ2RP81Jf9IP9hwdeB7ePd8ef5/ZviAgPiGheiRiPiOiPiTkPCZkPiYk/ihmPiomPinoPiooPi5sPjQyPjRyfjTy/nUzfnWz/nX0frW2P///////////////////////////////////////////////////////////////////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZywN8PQoQIj8gfYsVcIZLHCAjU0VQokWz26CB5v2DH8TEqm8+CIyPEDi3e8HiCQ198PiLS5cCfLAgbGwuBGx4lByoSDQMkARYLGJEYGSaIigolAAsWnJ0nlg0KJj8FpaYFFAaJoSdQR6AKKK5CEwO2EylBADs=','image/gif','R0lGODlhDwANAKU6ALkVKJ8nNdAWH9UVHklTY74kNa0vPqswP6oxQKU0Q0Zhcv8VGzpoeD9tfEJvfkVygUl1hEx4hlR3hlJ4h1B5iE96if81Jf9IP9hwdXicqIGjrvd8ebCaof5/ZviAgPiGhZKwupezu6yrsPiOiJq2v6Kzu/iYk6jAyPihmLK9w/iooL7L0LnN08HKzr/L0L3M0cDLz8rZ3vjQyPjRyfjTy/nUzfnWz/nX0frW2Pr7/P///////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZ6wN+PUqFMhMjkz5Fr5hxKZOV0IoE0mYq2IkFGYuCwOOJlmVkvV6sFWymQEOopdTDY7/cHiVRKoFAqMh0DhBcGDSEiBiOMJjMDOBYLADIMHAYemR4fNJCSBTMECBukpTWeCwU0PwGtrgEYApGpNVFIqAU2tkIXAL4XN0EAOw==','image/gif','R0lGODlhDwALAKUtAI8ZLJ8dL54gNaYkMJ8nNa4kOKItOq0rOqQxPq0vPrQyO680QrwyOLwyP8Q2PcQ2RNhwdeB7ePd8efd+e/eBffiAgPeDgPiGheiRiPiJiPiMiviOiPiPjfiQiviTkPCZkPiYk/ialfidl/ihmPiomPinoPiooPiqoviro/ispPi5sPjQyP////jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTyyH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgA/ACwAAAAADwALAAAGZcDfz0F0CI/IX4HFZBWSxweJ9MFEII9s9shYeb9gxrGhKpvPgqOixC4l3vD3AnHw2BOjkcl0QqXyBAMbGwmDGyAgISIbHQQ/ARIJFZMVFxcZGhyOPwAJEp+gExQWm0IEp6ioBkhBADs=','image/gif','image/gif','R0lGODlhDwALAKU8AJ8nNVRKW6ItOqQxPq0vPllTZaczQqY0Q680QjpoeD9tfEJvfkVygWVpdUl1hH1fbnJldGtpeEx4hl9xf1Z2hVJ4h096iXicqIGjrvd8efd+e5OnsfeBffiAgPeDgPiGhZKwuviJiJazvJ6wuPiMiviOiPiPjfiQipq2v7Kts/iYk/ialfidl6jAyKnAyPihmL+5vPiooPiqoviro/ispLnN08TJzcbJzMTKzcfJy8rZ3vr7/P///////////////yH5BAEKAD8ALAAAAAAPAAsAAAZswN+vYrFMhMjkb7Fr7hZKpKXVQoEwF8oDEnkgJbqweNz41s61G86WaxeQDqoLRqjb64gBA4VKEV4vMTEyMzSAAAoiIwQljSoqKywlJwA/CRsHHZodHx8hJCaVPwEGGaanGhweokIArq+vAklBADs=','R0lGODlhDwANAKUjAI9SGZ5fHZ5fIJ5mJ6VsJK1sJLltFa1yK61yL7R/Mrx/MryFMsOFNsOLNtSLFf+oFdiwcODAeP/GJP/GP+jQiPjQePjQgPDYkPjYiPjYkP/iZPjgmPjgoPjomPjosPrs1fjwyPr59//++f///////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgA/ACwAAAAADwANAAAGacDfr0FsCI/IX2HEHBWSR0anc6FEIIxs9rgAeb/gxVHhKZvPgmOCw+Yg3vD4IUNHbO4ijWM/QRAwGAiAgCIOHxIPBiEBFQgWj4+Fh4khAAgVmJmSiIo/A5+gA5uUUEeGnCGlQhMGrRMhQQA7','image/gif','R0lGODlhDwANAKUiACRUZC9ebjRjcjhmdjlndz1rej5sez9tfEl1hEx4hlB7ilJ9i1aAjlmDkX6grIGjrpSxu5i0vpy3wKa/x6zDy67FzLLIz7fL0rnN07/R18HT2cTV2sjY3c3b4Nrl6O3y9Pf5+vr7/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZpwN+PQWQIj8gfIcQMEZLHBYdjmUAei2z2qPB4v2DFMdEpm8+BI2LD3hze8LgBQz9o7qBMYy85DC4XB4CAIA0eEQ4FHwEUBxWPj4WHiR8ABxSYmZKIij8Cn6ACm5RQR4acH6VCEgWtEh9BADs=','image/gif','R0lGODlhDwALAIQaAI9SGZ5fHZ5fIJ5mJ6VsJK1sJK1yK61yL7R/Mrx/MryFMsOFNsOLNtiwcODAeOjQiPjQePjQgPDYkPjYiPjYkPjgmPjgoPjomPjosPjwyP///////////////////////yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgAfACwAAAAADwALAAAFTeD3MSQjnuhXaKxWpOdyXdLjNEuen0rm/0DFKYEpGo+CE8LCtBye0KiBQj1Urtjr40CYTA7ecHj7CUAOkbQ6Tf4ADpC4PN4WDe74PCoEADs=','image/gif','image/gif','R0lGODlhDwALAIQaACRUZC9ebjRjcjhmdjlndz5sez9tfEl1hEx4hlB7ilJ9i1aAjoGjrpSxu6a/x6zDy67FzLLIz7fL0rnN08HT2cTV2sjY3c3b4Nrl6Pr7/P///////////////////////yH5BAEKAB8ALAAAAAAPAAsAAAVN4Pct5CKe6EdkbEakp2JZkdMwSp6fCeb/wMQJcSkaj4HTocKsGJ7QaGFCNVCu2KvDMJBIDN5wePsJPAyQtDpN/gAMj7g83hYJ7vg8KgQAOw==','T');
 +
</source>
 +
 +
== Task 7 - Task start/end hour default value ==
 +
Go to administration->database query and execute ( set default has start hour and has default end hour = true)
 +
 +
'''All databases'''
 +
<source lang="sql">
 +
UPDATE OKM_TASK_MANAGER_TASK SET TMT_HAS_END_HOUR='T', TMT_HAS_START_HOUR='T';
 +
</source>
 +
 +
== Task 8 - Update max file size ==
 +
* Go to Administration > Database Query, and update configuration properties:
 +
 +
<source lang="sql">
 +
update OKM_CONFIG set CFG_TYPE='string' where CFG_KEY='max.file.size';
 +
</source>
 +
 +
* Go to Administration > Configuration, and update '''max.file.size''' configuration property value by appending "MB": if current value is 200, set to 200MB.
 +
 +
* Go to Administration / Utilities / Rebuild lucene indexes
 +
  
 
* Set installation customer at [http://update.openkm.com/admin/license_list.php License Manager].
 
* Set installation customer at [http://update.openkm.com/admin/license_list.php License Manager].

Latest revision as of 13:19, 31 October 2013

  • Make a backup!!!

Task 1 - Install jdk 1.7

Is mandatory install jdk 1.7 otherside application will not be deployed.

Task 2 - Automation classes automatic loaded

  • All OKM_NODETYPE* tables should be deleted
  • All OKM_TASK_MANAGER* tables should be deleted

HSQL 

DROP TABLE OKM_NODE_TYPE;
DROP TABLE OKM_TASK_MANAGER_TASK_USER;
DROP TABLE OKM_TASK_MANAGER_TASK_ROLE;
DROP TABLE OKM_TASK_MANAGER_TASK_RECORD;
DROP TABLE OKM_TASK_MANAGER_TASK_MAIL;
DROP TABLE OKM_TASK_MANAGER_TASK_FOLDER;
DROP TABLE OKM_TASK_MANAGER_TASK_DOCUMENT;
DROP TABLE OKM_TASK_MANAGER_TASK;
DROP TABLE OKM_TASK_MANAGER_PROJECT;
DROP TABLE OKM_TASK_MANAGER_STATUS;

MySQL 

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE OKM_NODE_TYPE;
SET FOREIGN_KEY_CHECKS=1;
DROP TABLE OKM_TASK_MANAGER_TASK_USER;
DROP TABLE OKM_TASK_MANAGER_TASK_ROLE;
DROP TABLE OKM_TASK_MANAGER_TASK_RECORD;
DROP TABLE OKM_TASK_MANAGER_TASK_MAIL;
DROP TABLE OKM_TASK_MANAGER_TASK_FOLDER;
DROP TABLE OKM_TASK_MANAGER_TASK_DOCUMENT;
DROP TABLE OKM_TASK_MANAGER_TASK;
DROP TABLE OKM_TASK_MANAGER_PROJECT;
DROP TABLE OKM_TASK_MANAGER_STATUS;

Task 3 - Update Automation now classes are loaded automatically

  • Migration of automation step 1

HSQL 

SELECT AAC_ID, AAC_TYPE, 'UPDATE OKM_AUTO_ACTION set AAC_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AAC_TYPE) || ''' where AAC_ID=' || AAC_ID || ';'  FROM OKM_AUTO_ACTION;
SELECT AVL_ID, AVL_TYPE, 'UPDATE OKM_AUTO_VALIDATION set AVL_CLASS_NAME=''' || (SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AVL_TYPE) || ''' where AVL_ID=' || AVL_ID || ';' FROM OKM_AUTO_VALIDATION;

MYSQL 

SELECT AAC_ID, AAC_TYPE, CONCAT('UPDATE OKM_AUTO_ACTION set AAC_CLASS_NAME=''',(SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AAC_TYPE),''' where AAC_ID=',AAC_ID,';')  FROM OKM_AUTO_ACTION;
SELECT AVL_ID, AVL_TYPE, CONCAT('UPDATE OKM_AUTO_VALIDATION set AVL_CLASS_NAME=''',(SELECT AMD_CLASS_NAME FROM OKM_AUTO_METADATA WHERE AMD_ID=AVL_TYPE),''' where AVL_ID=',AVL_ID,';') FROM OKM_AUTO_VALIDATION;
  • Stop Tomcat
  • Run from your preferred SQL client these queries:
-- Configuration
UPDATE OKM_CONFIG SET CFG_KEY='text.banner' WHERE CFG_KEY='logo.banner';
UPDATE OKM_CONFIG SET CFG_KEY='text.welcome' WHERE CFG_KEY='logo.welcome';
UPDATE OKM_CONFIG SET CFG_TYPE='string' WHERE CFG_KEY='max.file.size';

-- Mail account seen
ALTER TABLE OKM_MAIL_ACCOUNT DROP COLUMN MA_MMARK_SEEN;
  • Edit OpenKM.cfg and set hibernate.hbm2ddl to update
  • Replace the OpenKM.war
  • Review file descriptor limit and, eventually, increase it.
  • Start Tomcat again
  • Migration of automation step 2

Go to database query and execute sql output from automation step 1. Finally execute the sql queries to drop non used columns. 

-- Automation
ALTER TABLE OKM_AUTO_ACTION DROP COLUMN AAC_TYPE;
ALTER TABLE OKM_AUTO_VALIDATION DROP COLUMN AVL_TYPE;
DROP TABLE OKM_AUTO_METADATA;

-- Remove node scripting
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPTING;
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPT_CODE;

-- Node class
UPDATE OKM_NODE_BASE SET NBS_NODE_CLASS=0;

Task 4 - Update OCR Template, now classes are loaded automatically

drop table OKM_OCR_TEMPLATE_METADATA;
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.StringParser' WHERE OTF_TYPE='1';
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.NumberParser' WHERE OTF_TYPE='2';
UPDATE OKM_OCR_TEMPLATE_FIELD SET OTF_CLASS_NAME='com.openkm.ocr.template.parser.DateParser' WHERE OTF_TYPE='3';

All databases 

ALTER TABLE OKM_OCR_TEMPLATE_FIELD DROP COLUMN OTF_TYPE;

Task 5

  • Check for database errors:
$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log

Task 6 - Folder style default value

Go to administration->database query and execute ( set default folder style=0)

All databases 

update OKM_NODE_FOLDER SET NFL_STYLE=0;

-- If have several tennats should be added for each tenant
-- IMPORTA IF YOU'RE IN HSQL SHOULD ( 2GB hsql limitation -> divide in several files ):
-- 1-> In database sql SHUTDOWN COMPACT ( connection i closed and file compacted )
-- 2-> Restart OpenKM
-- 3-> Execute the query, probably now goes right read http://sourceforge.net/mailarchive/forum.php?forum_name=hsqldb-user&max_rows=25&style=nested&viewmonth=200602

INSERT INTO OKM_FOLDER_STYLE (FS_ID, FS_TENANT, FS_NAME,FS_RD_CHILD_IMG_CONT, FS_RD_CHILD_IMG_MIME,FS_RD_CHILD_SUB_IMG_CONT, FS_RD_CHILD_SUB_IMG_MIME,FS_RD_EMPTY_IMG_CONT, FS_RD_EMPTY_IMG_MIME,FS_RD_EMPTY_SUB_IMG_MIME, FS_RD_EMPTY_SUB_IMG_CONT,FS_WR_CHILD_IMG_CONT, FS_WR_CHILD_IMG_MIME, FS_WR_CHILD_SUB_IMG_CONT, FS_WR_CHILD_SUB_IMG_MIME, FS_WR_EMPTY_IMG_CONT, FS_WR_EMPTY_IMG_MIME, FS_WR_EMPTY_SUB_IMG_MIME, FS_WR_EMPTY_SUB_IMG_CONT, FS_COMPLETE) VALUES ('1', '1', 'Default','R0lGODlhDwANAKUrAI8ZLJ8dL54gNbkVKKYkMJ8nNdAWH9UVHq4kOK0rOr4kNa0vPrQyO/8VG7wyOLwyP8Q2PcQ2RP81Jf9IP9hwdeB7ePd8ef5/ZviAgPiGheiRiPiOiPiTkPCZkPiYk/ihmPiomPinoPiooPi5sPjQyPjRyfjTy/nUzfnWz/nX0frW2P///////////////////////////////////////////////////////////////////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZywN8PQoQIj8gfYsVcIZLHCAjU0VQokWz26CB5v2DH8TEqm8+CIyPEDi3e8HiCQ198PiLS5cCfLAgbGwuBGx4lByoSDQMkARYLGJEYGSaIigolAAsWnJ0nlg0KJj8FpaYFFAaJoSdQR6AKKK5CEwO2EylBADs=','image/gif','R0lGODlhDwANAKU6ALkVKJ8nNdAWH9UVHklTY74kNa0vPqswP6oxQKU0Q0Zhcv8VGzpoeD9tfEJvfkVygUl1hEx4hlR3hlJ4h1B5iE96if81Jf9IP9hwdXicqIGjrvd8ebCaof5/ZviAgPiGhZKwupezu6yrsPiOiJq2v6Kzu/iYk6jAyPihmLK9w/iooL7L0LnN08HKzr/L0L3M0cDLz8rZ3vjQyPjRyfjTy/nUzfnWz/nX0frW2Pr7/P///////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZ6wN+PUqFMhMjkz5Fr5hxKZOV0IoE0mYq2IkFGYuCwOOJlmVkvV6sFWymQEOopdTDY7/cHiVRKoFAqMh0DhBcGDSEiBiOMJjMDOBYLADIMHAYemR4fNJCSBTMECBukpTWeCwU0PwGtrgEYApGpNVFIqAU2tkIXAL4XN0EAOw==','image/gif','R0lGODlhDwALAKUtAI8ZLJ8dL54gNaYkMJ8nNa4kOKItOq0rOqQxPq0vPrQyO680QrwyOLwyP8Q2PcQ2RNhwdeB7ePd8efd+e/eBffiAgPeDgPiGheiRiPiJiPiMiviOiPiPjfiQiviTkPCZkPiYk/ialfidl/ihmPiomPinoPiooPiqoviro/ispPi5sPjQyP////jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTy/jTyyH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgA/ACwAAAAADwALAAAGZcDfz0F0CI/IX4HFZBWSxweJ9MFEII9s9shYeb9gxrGhKpvPgqOixC4l3vD3AnHw2BOjkcl0QqXyBAMbGwmDGyAgISIbHQQ/ARIJFZMVFxcZGhyOPwAJEp+gExQWm0IEp6ioBkhBADs=','image/gif','image/gif','R0lGODlhDwALAKU8AJ8nNVRKW6ItOqQxPq0vPllTZaczQqY0Q680QjpoeD9tfEJvfkVygWVpdUl1hH1fbnJldGtpeEx4hl9xf1Z2hVJ4h096iXicqIGjrvd8efd+e5OnsfeBffiAgPeDgPiGhZKwuviJiJazvJ6wuPiMiviOiPiPjfiQipq2v7Kts/iYk/ialfidl6jAyKnAyPihmL+5vPiooPiqoviro/ispLnN08TJzcbJzMTKzcfJy8rZ3vr7/P///////////////yH5BAEKAD8ALAAAAAAPAAsAAAZswN+vYrFMhMjkb7Fr7hZKpKXVQoEwF8oDEnkgJbqweNz41s61G86WaxeQDqoLRqjb64gBA4VKEV4vMTEyMzSAAAoiIwQljSoqKywlJwA/CRsHHZodHx8hJCaVPwEGGaanGhweokIArq+vAklBADs=','R0lGODlhDwANAKUjAI9SGZ5fHZ5fIJ5mJ6VsJK1sJLltFa1yK61yL7R/Mrx/MryFMsOFNsOLNtSLFf+oFdiwcODAeP/GJP/GP+jQiPjQePjQgPDYkPjYiPjYkP/iZPjgmPjgoPjomPjosPrs1fjwyPr59//++f///////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgA/ACwAAAAADwANAAAGacDfr0FsCI/IX2HEHBWSR0anc6FEIIxs9rgAeb/gxVHhKZvPgmOCw+Yg3vD4IUNHbO4ijWM/QRAwGAiAgCIOHxIPBiEBFQgWj4+Fh4khAAgVmJmSiIo/A5+gA5uUUEeGnCGlQhMGrRMhQQA7','image/gif','R0lGODlhDwANAKUiACRUZC9ebjRjcjhmdjlndz1rej5sez9tfEl1hEx4hlB7ilJ9i1aAjlmDkX6grIGjrpSxu5i0vpy3wKa/x6zDy67FzLLIz7fL0rnN07/R18HT2cTV2sjY3c3b4Nrl6O3y9Pf5+vr7/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAD8ALAAAAAAPAA0AAAZpwN+PQWQIj8gfIcQMEZLHBYdjmUAei2z2qPB4v2DFMdEpm8+BI2LD3hze8LgBQz9o7qBMYy85DC4XB4CAIA0eEQ4FHwEUBxWPj4WHiR8ABxSYmZKIij8Cn6ACm5RQR4acH6VCEgWtEh9BADs=','image/gif','R0lGODlhDwALAIQaAI9SGZ5fHZ5fIJ5mJ6VsJK1sJK1yK61yL7R/Mrx/MryFMsOFNsOLNtiwcODAeOjQiPjQePjQgPDYkPjYiPjYkPjgmPjgoPjomPjosPjwyP///////////////////////yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQBCgAfACwAAAAADwALAAAFTeD3MSQjnuhXaKxWpOdyXdLjNEuen0rm/0DFKYEpGo+CE8LCtBye0KiBQj1Urtjr40CYTA7ecHj7CUAOkbQ6Tf4ADpC4PN4WDe74PCoEADs=','image/gif','image/gif','R0lGODlhDwALAIQaACRUZC9ebjRjcjhmdjlndz5sez9tfEl1hEx4hlB7ilJ9i1aAjoGjrpSxu6a/x6zDy67FzLLIz7fL0rnN08HT2cTV2sjY3c3b4Nrl6Pr7/P///////////////////////yH5BAEKAB8ALAAAAAAPAAsAAAVN4Pct5CKe6EdkbEakp2JZkdMwSp6fCeb/wMQJcSkaj4HTocKsGJ7QaGFCNVCu2KvDMJBIDN5wePsJPAyQtDpN/gAMj7g83hYJ7vg8KgQAOw==','T');

Task 7 - Task start/end hour default value

Go to administration->database query and execute ( set default has start hour and has default end hour = true)

All databases 

UPDATE OKM_TASK_MANAGER_TASK SET TMT_HAS_END_HOUR='T',	TMT_HAS_START_HOUR='T';

Task 8 - Update max file size

  • Go to Administration > Database Query, and update configuration properties:
update OKM_CONFIG set CFG_TYPE='string' where CFG_KEY='max.file.size';
  • Go to Administration > Configuration, and update max.file.size configuration property value by appending "MB": if current value is 200, set to 200MB.
  • Go to Administration / Utilities / Rebuild lucene indexes


  • Enjoy OpenKM 6.4.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.


Nota clasica.png Recommended to clear browser cache and Java Plugin cache

Retrieved from "https://www.openkm.com/wiki/index.php?title=Knowledge:Migration_from_6.4.1_to_6.4.2&oldid=10836"