Difference between revisions of "Knowledge:Migration from 6.2.4 to 6.2.5"

From OpenKM Documentation
Jump to: navigation, search
Line 24: Line 24:
 
* Go to '''Administration''' > '''Database Query''' and execute these SQL sentences:
 
* Go to '''Administration''' > '''Database Query''' and execute these SQL sentences:
  
−
Delete obsolete configuration properties to avoid confusion:
+
** Delete obsolete configuration properties to avoid confusion:
  
 
<source lang="sql">
 
<source lang="sql">
Line 32: Line 32:
 
</source>
 
</source>
  
−
Register new automation and select available which have '''okm:folder''' should be 4 ( otherside there's some problem )
+
** Register new automation and select available which have '''okm:folder''' should be 4 ( otherside there's some problem )
  
 
<source lang="sql">
 
<source lang="sql">
Line 39: Line 39:
 
</source>
 
</source>
  
−
From SQL get some values to be added on script:
+
** Generate sentences to be added at the below script:
  
 
<source lang="sql">
 
<source lang="sql">
Line 45: Line 45:
 
</source>
 
</source>
  
−
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.
+
** 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.
 +
 
 
<source lang="java">
 
<source lang="java">
 
import com.openkm.api.OKMRepository;
 
import com.openkm.api.OKMRepository;

Revision as of 11:42, 17 November 2012

  • 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
  • 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';
    • Generate sentences to be added at the below 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.


Nota clasica.png Recommended to clear browser cache (prevents "The response could not be deserialized" errors) and Java Plugin cache

Retrieved from "https://www.openkm.com/wiki/index.php?title=Knowledge:Migration_from_6.2.4_to_6.2.5&oldid=7902"