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

From OpenKM Documentation
Jump to: navigation, search
Line 29: Line 29:
 
</source>
 
</source>
  
−
Add the results of the last query on the script and execute, you'll get update SQL that should be executed
+
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 16:11, 16 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
  • Go to Administration > Database Query and execute:

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.


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=7897"