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 (7.88 KiB) Viewed 8474 times
Please find attached catalina.log and also the text output from my server window.
catalina.log:
Code: Select all2017-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 all2017-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)