• [SOLVED] Database error after upgrading 6.3.2 to 6.3.3

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #43831  by lou1973
 
Hi I'm trying to upgrade OpenKM 6.3.2 to 6.3.3
I followed all the steps here: https://docs.openkm.com/kcenter/view/ok ... o-633.html

Server seems to start up OK, but I get this after I log in:
Screenshot3.png
Screenshot3.png (10.46 KiB) Viewed 8503 times
When I close the error message box, the whole taxonomy tree is empty so I can't see any documents.
The same thing happens when I go to 6.3.4

When I downgrade back to 6.3.2 by replacing the OpenKM.war with the older version, the errors go away and everything works fine again.

I'm really excited to use the improvements you made in the latest version 6.3.4 but I can't get past these errors in 6.3.3

Using OpenKM CE on Win7 + PostgreSQL

Thanks for your help
Last edited by lou1973 on Mon May 29, 2017 7:30 pm, edited 1 time in total.
 #43851  by jllort
 
Try:
1- Stop OpenKM.
2- Execute from database:
Code: Select all
DELETE FROM OKM_DASHBOARD;
DELETE FROM OKM_DASHBOARD_ACTIVITY;
3- Start OpenKM.

If does not going right, drop these tables, set hibernate.hbml=update and start openkm
If all fails, share with us the catalina.log file
 #43912  by lou1973
 
Thanks, I'm still getting the "database error" messages even when I drop those 2 tables.

When I log in to the web app, there's some blue squares almost like a progress bar -- I get 4 database errors and there are 4 blue squares that are not filled in -- not sure if this means anything to you.
Screenshot_20170529_130105.png
Screenshot_20170529_130105.png (7.88 KiB) Viewed 8449 times
Please find attached catalina.log and also the text output from my server window.

catalina.log:
Code: Select all
2017-05-29 12:49:40,265 [main] INFO  org.apache.catalina.core.AprLifecycleListener- The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_131\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\ImageMagick-6.9.3-Q16;C:\ProgramData\Oracle\Java\javapath;C:\ImageMagick-6.9.3-Q16;C:\Oracle\product\11.2.0\client_64\bin;C:\Program Files\Java\jre7\bin;C:\Program Files (x86)\Java\jre7\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\cygwin64\bin;C:\Windows/SysWOW64;C:\Program Files\7-Zip;C:\openkm-6.3.1-community\tomcat\lib\sigar;.
2017-05-29 12:49:40,658 [main] INFO  org.apache.coyote.http11.Http11Protocol- Initializing ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:49:40,685 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Initializing ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:49:40,689 [main] INFO  org.apache.catalina.startup.Catalina- Initialization processed in 1197 ms
2017-05-29 12:49:40,820 [main] INFO  org.apache.catalina.core.StandardService- Starting service Catalina
2017-05-29 12:49:40,821 [main] INFO  org.apache.catalina.core.StandardEngine- Starting Servlet Engine: Apache Tomcat/7.0.61
2017-05-29 12:49:40,879 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application archive C:\openkm-6.3.1-community\tomcat\webapps\OpenKM.war
2017-05-29 12:49:42,386 [localhost-startStop-1] INFO  org.apache.catalina.loader.WebappClassLoader- validateJarFile(C:\openkm-6.3.1-community\tomcat\webapps\OpenKM\WEB-INF\lib\servlet-api-2.5-20081211.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
2017-05-29 12:49:42,387 [localhost-startStop-1] INFO  org.apache.catalina.loader.WebappClassLoader- validateJarFile(C:\openkm-6.3.1-community\tomcat\webapps\OpenKM\WEB-INF\lib\servlet-api-6.0.36.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
2017-05-29 12:50:04,850 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
2017-05-29 12:50:04,853 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/core is already defined
2017-05-29 12:50:04,854 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
2017-05-29 12:50:04,857 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
2017-05-29 12:50:04,886 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
2017-05-29 12:50:04,887 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
2017-05-29 12:50:04,888 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
2017-05-29 12:50:04,889 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
2017-05-29 12:50:04,889 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
2017-05-29 12:50:04,900 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
2017-05-29 12:50:04,910 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
2017-05-29 12:50:04,911 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
2017-05-29 12:50:04,913 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
2017-05-29 12:50:04,914 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
2017-05-29 12:50:04,915 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
2017-05-29 12:50:04,963 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- No Spring WebApplicationInitializer types detected on classpath
2017-05-29 12:50:05,961 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Initializing Spring root WebApplicationContext
2017-05-29 12:50:57,969 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deployment of web application archive C:\openkm-6.3.1-community\tomcat\webapps\OpenKM.war has finished in 77,090 ms
2017-05-29 12:50:57,972 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory C:\openkm-6.3.1-community\tomcat\webapps\ROOT
2017-05-29 12:51:01,828 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deployment of web application directory C:\openkm-6.3.1-community\tomcat\webapps\ROOT has finished in 3,855 ms
2017-05-29 12:51:01,842 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:51:01,863 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:51:01,865 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 81144 ms
2017-05-29 12:59:40,350 [main] INFO  org.apache.catalina.core.StandardServer- A valid shutdown command was received via the shutdown port. Stopping the Server instance.
2017-05-29 12:59:40,353 [main] INFO  org.apache.coyote.http11.Http11Protocol- Pausing ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:59:40,407 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Pausing ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:59:40,463 [main] INFO  org.apache.catalina.core.StandardService- Stopping service Catalina
2017-05-29 12:59:41,151 [localhost-startStop-2] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Closing Spring root WebApplicationContext
2017-05-29 12:59:41,415 [localhost-startStop-2] ERROR org.apache.catalina.loader.WebappClassLoader- The web application [/OpenKM] appears to have started a thread named [OfficeProcessThread-0] but has failed to stop it. This is very likely to create a memory leak.
2017-05-29 12:59:41,415 [localhost-startStop-2] ERROR org.apache.catalina.loader.WebappClassLoader- The web application [/OpenKM] appears to have started a thread named [Thread-14] but has failed to stop it. This is very likely to create a memory leak.
2017-05-29 12:59:43,125 [main] INFO  org.apache.coyote.http11.Http11Protocol- Stopping ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:59:43,126 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Stopping ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:59:43,127 [main] INFO  org.apache.coyote.http11.Http11Protocol- Destroying ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:59:43,129 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Destroying ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
text output from my server window:
Code: Select all
2017-05-29 12:49:40,265 [main] INFO  org.apache.catalina.core.AprLifecycleListener- The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_131\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\ImageMagick-6.9.3-Q16;C:\ProgramData\Oracle\Java\javapath;C:\ImageMagick-6.9.3-Q16;C:\Oracle\product\11.2.0\client_64\bin;C:\Program Files\Java\jre7\bin;C:\Program Files (x86)\Java\jre7\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\cygwin64\bin;C:\Windows/SysWOW64;C:\ProgramFiles\7-Zip;C:\openkm-6.3.1-community\tomcat\lib\sigar;.
2017-05-29 12:49:40,658 [main] INFO  org.apache.coyote.http11.Http11Protocol- Initializing ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:49:40,685 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Initializing ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:49:40,689 [main] INFO  org.apache.catalina.startup.Catalina- Initialization processed in 1197 ms
May 29, 2017 12:49:40 PM com.openkm.util.LoggerWatchdog doOnChange
INFO: *** Log4j configuration file changed ***
2017-05-29 12:49:40,820 [main] INFO  org.apache.catalina.core.StandardService- Starting service Catalina
2017-05-29 12:49:40,821 [main] INFO  org.apache.catalina.core.StandardEngine- Starting Servlet Engine: Apache Tomcat/7.0.61
2017-05-29 12:49:40,879 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application archive C:\openkm-6.3.1-community\tomcat\webapps\OpenKM.war
2017-05-29 12:49:42,386 [localhost-startStop-1] INFO  org.apache.catalina.loader.WebappClassLoader- validateJarFile(C:\openkm-6.3.1-community\tomcat\webapps\OpenKM\WEB-INF\lib\servlet-api-2.5-20081211.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
2017-05-29 12:49:42,387 [localhost-startStop-1] INFO  org.apache.catalina.loader.WebappClassLoader- validateJarFile(C:\openkm-6.3.1-community\tomcat\webapps\OpenKM\WEB-INF\lib\servlet-api-6.0.36.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
2017-05-29 12:50:04,850 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
2017-05-29 12:50:04,853 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/core is already defined
2017-05-29 12:50:04,854 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
2017-05-29 12:50:04,857 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
2017-05-29 12:50:04,886 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
2017-05-29 12:50:04,887 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
2017-05-29 12:50:04,888 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
2017-05-29 12:50:04,889 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
2017-05-29 12:50:04,889 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
2017-05-29 12:50:04,900 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
2017-05-29 12:50:04,910 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
2017-05-29 12:50:04,911 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
2017-05-29 12:50:04,913 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
2017-05-29 12:50:04,914 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
2017-05-29 12:50:04,915 [localhost-startStop-1] INFO  org.apache.tomcat.util.digester.Digester- TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
2017-05-29 12:50:04,963 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- No Spring WebApplicationInitializer types detected on classpath
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/openkm-6.3.1-community/tomcat/lib/activemq-all-5.9.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/openkm-6.3.1-community/tomcat/webapps/OpenKM/WEB-INF/lib/logback-classic-1.1.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/openkm-6.3.1-community/tomcat/webapps/OpenKM/WEB-INF/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
12:50:05,588 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
12:50:05,597 |-INFO in ReconfigureOnChangeFilter{invocationCounter=0} - Will scan for changes in [[C:\openkm-6.3.1-community\tomcat\webapps\OpenKM\WEB-INF\classes\logback.xml]] every 60 seconds.
12:50:05,597 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Adding ReconfigureOnChangeFilter as a turbo filter
12:50:05,609 |-INFO in ch.qos.logback.classic.joran.action.JMXConfiguratorAction - begin
12:50:05,616 |-INFO in ch.qos.logback.core.joran.action.StatusListenerAction - Added status listener of type [ch.qos.logback.core.status.OnConsoleStatusListener]
12:50:05,631 |-INFO in ch.qos.logback.core.joran.action.TimestampAction - Using current interpretation time, i.e. now, as time reference.
12:50:05,631 |-INFO in ch.qos.logback.core.joran.action.TimestampAction - Adding property to the context with key="bySecond" and value="2017-05-29" to the LOCAL scope
12:50:05,631 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
12:50:05,634 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]
12:50:05,686 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
12:50:05,780 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
12:50:05,785 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE]
12:50:05,839 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - No compression will be used
12:50:05,843 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - Will use the pattern C:/openkm-6.3.1-community/tomcat/logs/openkm_%d{yyyy-MM-dd}.%i.log for the active file
12:50:05,847 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@1238c617 - The date pattern is 'yyyy-MM-dd' from file name pattern 'C:/openkm-6.3.1-community/tomcat/logs/openkm_%d{yyyy-MM-dd}.%i.log'.
12:50:05,848 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@1238c617 - Roll-over at midnight.
12:50:05,849 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@1238c617 - Setting initial period to Mon May 29 12:50:05 CAT 2017
12:50:05,875 |-WARN in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - This appender no longer admits a layout as a sub-component, set an encoder instead.
12:50:05,876 |-WARN in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - To ensure compatibility, wrapping your layout in LayoutWrappingEncoder.
12:50:05,877 |-WARN in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - See also http://logback.qos.ch/codes.html#layoutInsteadOfEncoder for details
12:50:05,880 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: C:\openkm-6.3.1-community\tomcat/logs/openkm.log
12:50:05,881 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [C:\openkm-6.3.1-community\tomcat/logs/openkm.log]
12:50:05,887 |-INFO in ch.qos.logback.core.joran.util.ConfigurationWatchListUtil@14e13c92 - Adding [file:/C:/openkm-6.3.1-community/tomcat/logback.xml] to configuration watch list.
12:50:05,888 |-WARN in ch.qos.logback.core.joran.action.IncludeAction - Failed to open [file:/C:/openkm-6.3.1-community/tomcat/logback.xml]
12:50:05,888 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
12:50:05,889 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@11b580db - Registering current configuration as safe fallback point
SLF4J: Actual binding is of type [ch.qos.logback.classic.util.ContextSelectorStaticBinder]
2017-05-29 12:50:05,961 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Initializing Spring root WebApplicationContext
12:50:05,966 |-WARN in Logger[org.springframework.web.context.ContextLoader] - No appenders present in context [default] for logger [org.springframework.web.context.ContextLoader].
May 29, 2017 12:50:53 PM org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is SigarProcessManager
May 29, 2017 12:50:53 PM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir 'C:\openkm-6.3.1-community\tomcat\temp\.jodconverter_socket_host-127.0.0.1_port-2002'
May 29, 2017 12:50:53 PM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: started process; pid = 1636
May 29, 2017 12:50:55 PM org.artofsolving.jodconverter.office.ManagedOfficeProcess$6 attempt
WARNING: office process died with exit code 81; restarting it
May 29, 2017 12:50:55 PM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir 'C:\openkm-6.3.1-community\tomcat\temp\.jodconverter_socket_host-127.0.0.1_port-2002'
May 29, 2017 12:50:56 PM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: started process; pid = 4812
May 29, 2017 12:50:56 PM org.artofsolving.jodconverter.office.OfficeConnection connect
INFO: connected: 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1'
2017-05-29 12:50:57,969 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deployment of web application archive C:\openkm-6.3.1-community\tomcat\webapps\OpenKM.war has finished in 77,090 ms
2017-05-29 12:50:57,972 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory C:\openkm-6.3.1-community\tomcat\webapps\ROOT
2017-05-29 12:51:01,828 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deployment of web application directory C:\openkm-6.3.1-community\tomcat\webapps\ROOT has finished in 3,855 ms
2017-05-29 12:51:01,842 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-05-29 12:51:01,863 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2017-05-29 12:51:01,865 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 81144 ms
Please help, and thank you very much.

(It works fine when I return to the older OpenKM.war but I need the new upgrade)
 #43917  by lou1973
 
Aha solved it!

I wanted to do a repository check, (Administration Tab -> Utilities --> Check Repository)
but it seems to hang.

When I do a "View Repository"
I get a HTTP 500 Internal Server Error, with the message as below.
Code: Select all
com.openkm.core.DatabaseException: could not load an entity: [com.openkm.dao.bean.NodeBase#bebcfa78-a3a5-4755-b340-ed89cdb8dadf]
	com.openkm.dao.NodeBaseDAO.findByPk(NodeBaseDAO.java:78)
	...
	...
	root cause
	
	org.hibernate.exception.SQLGrammarException: could not load an entity: [com.openkm.dao.bean.NodeBase#bebcfa78-a3a5-4755-b340-ed89cdb8dadf]
	...
	...
	root cause
	
	org.postgresql.util.PSQLException: ERROR: column nodebase0_1_.ndc_encryption does not exist
	
I went back to double check the upgrade instructions because I did add columns NDC_ENCRYPTION and NDC_SIGNED to the table.
Then I noticed that for H2 and MySQL, it says ALTER TABLE OKM_NODE_DOCUMENT
but for PostgreSQL the instructions say ALTER TABLE OKM_MIME_TYPE

So i changed the table from OKM_MIME_TYPE to OKM_NODE_DOCUMENT and it works!
So it's only the upgrade instructions for PostgreSQL that were incorrect :-)

Thanks again for a great system!

Lou

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.