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

From OpenKM Documentation
Jump to: navigation, search
Line 42: Line 42:
 
Go to database query and execute sql output from automation step 1. Finally execute the sql queries to drop non used columns.
 
Go to database query and execute sql output from automation step 1. Finally execute the sql queries to drop non used columns.
 
<source lang="sql">
 
<source lang="sql">
 +
-- Automation
 
ALTER TABLE OKM_AUTO_ACTION DROP COLUMN AAC_TYPE;
 
ALTER TABLE OKM_AUTO_ACTION DROP COLUMN AAC_TYPE;
 
ALTER TABLE OKM_AUTO_VALIDATION DROP COLUMN AVL_TYPE;
 
ALTER TABLE OKM_AUTO_VALIDATION DROP COLUMN AVL_TYPE;
 
DROP TABLE OKM_AUTO_METADATA;
 
DROP TABLE OKM_AUTO_METADATA;
−
UPDATE OKM_NODE_BASE SET NBS_NODE_CLASS=0;
+
 
 +
-- Remove node scripting
 
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPTING;
 
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPTING;
 
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPT_CODE;
 
ALTER TABLE OKM_NODE_BASE DROP COLUMN NDC_SCRIPT_CODE;
 +
 +
-- Node class
 +
UPDATE OKM_NODE_BASE SET NBS_NODE_CLASS=0;
 
</source>
 
</source>
  

Revision as of 22:39, 31 July 2013


Nota clasica.png OpenKM 6.4.2 is currently under development.

  • Make a backup!!!
  • All OKM_NODETYPE* tables should be deleted
  • All OKM_TASK_MANAGER* tables should be deleted
  • Migration of automation step 1
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;
  • 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';

-- Workflow
UPDATE OKM_PROFILE SET PRF_DB_WORKFLOW_VIS='F';
UPDATE OKM_PROFILE SET PRF_MN_FI_START_WORKFLOW_VIS='F';
UPDATE OKM_PROFILE SET PRF_TB_START_WORKFLOW_VIS='F';
  • 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;
  • Check for database errors:
$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log
  • 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=10029"