OpenKM 6.2 Migration Problem

[luke]

Hi

I have 2 problems with migrating OpenKM 5.1.11 to 6.2

1.Profile

Code: Select all

SELECT CONCAT('INSERT INTO OKM_USER_CONFIG (UC_USER, UC_HOME_PATH, UC_HOME_NODE, UC_HOME_TYPE, UC_PROFILE) VALUES (''', UC_USER, ''', ''', UC_HOME_PATH, ''', ''', UC_HOME_UUID, ''', ''', UC_HOME_TYPE, ''', ''', UC_PROFILE, ''');') FROM OKM_USER_CONFIG;

This script from Wiki OpenKM Migration doesn`t work for me. I have an error of java.lang.ArrayIndexOutOfBoundsException: 2 in statement

2. I try to install 6.2 from installer and from zip file every time when I try to login to OpenKM I have Http error (I already changed IP address in Tomcat server.xml):

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

Code: Select all

java.lang.ClassNotFoundException: org.apache.jsp.index_jsp
	java.net.URLClassLoader$1.run(URLClassLoader.java:202)
	java.security.AccessController.doPrivileged(Native Method)
	java.net.URLClassLoader.findClass(URLClassLoader.java:190)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:132)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
	org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:172)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.27 logs.

Or another one:

HTTP Status 404 - /OpenKM/

type Status report

message /OpenKM/

description The requested resource (/OpenKM/) is not available.
Apache Tomcat/7.0.27

Please Help

[jllort]

Do not merge problems ! Installation is one problem and migration, in this post please only fill problems related to migration ( about installation of 6.2 refer to other post and indicate your OS and the path you installed openkm ).

About script error which is your database ?

[luke]

I am using stock OpenKM database. I just want to execute this script in the database query. The first scripts works like a charm but I can`t make the last one works. The full error is :

Code: Select all

Class: 	java.sql.SQLException
Message: 	S1000 General error java.lang.ArrayIndexOutOfBoundsException: 2 in statement [SELECT CONCAT('INSERT INTO OKM_USER_CONFIG (UC_USER, UC_HOME_PATH, UC_HOME_NODE, UC_HOME_TYPE, UC_PROFILE) VALUES (''', UC_USER, ''', ''',]

When I do Select * from OKM_USER_CONFIG
I get such columns.

Code: Select all

UC_USER 	UC_HOME_PATH 	UC_HOME_UUID 	UC_HOME_TYPE 	UC_PROFILE

[jllort]

The columns name should be UC_HOME_NODE in openkm database 6.x is strange you got UC_HOME_UUID.

Really this table is not critical, here we indicate the default user home and the profile assigned.

[luke]

These results are from OpenKM 5.1.11 because in the migration guide it`s said to execute the script in OpenKM 5.1.11 and paste the results in OpenKM 6.2 It`s not a big problem to create profiles but if it`s possible to migrate it so why not to do it

[jllort]

table OKM_USER_CONFIG are not tables OKM_PROFILE* about what are you talking about OKM_PROFILE* tables ? if you're talking about it migration sql script are wellcome if you decide to build it, we will share with rest of the user at documentation.