Page 1 of 1

Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Thu Jul 24, 2014 9:26 am
by maraf1
He seguido el wiki para pasar de una versión a la otra.

Se me presentan algunas dudas y algun error:

Dudas.
Si no elimino la carpeta OpenKm, aunque modifique OpenKM.cfg y el parámetro hibernate.hbm2ddl = update . Poniendo el .war de la verison 6.3.0 Me carga correctamente pero al entrar en el openkm y pasar los querys. reinicio todo y al ver la version me sigue apareciendo que está en versión 6.2.5

Si elimino la carpeta OpenKM, al hacer el deploy me crea y genera de nuevo los ficheros en esa carpeta. Lanzo el tomcat correctamente pero al logarme en el openKM se me queda en el mensaje de "cargando datos de usuario"

GRACIAS

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Thu Jul 24, 2014 10:44 am
by maraf1
Os adjunto el log por si podeis ver algo..... MUCHAS GRACIAS
Code: Select all
2014-07-24 12:34:01,199 [pool-2-thread-1] INFO  com.openkm.util.JBPMUtils - Creating JBPM default configuration
2014-07-24 12:34:01,246 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Initializing MIME types... ***
2014-07-24 12:34:01,246 [pool-2-thread-1] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: -5501, SQLState: 42501
2014-07-24 12:34:01,246 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT6_55_
2014-07-24 12:34:01,246 [pool-2-thread-1] ERROR com.openkm.core.MimeTypeConfig - could not execute query
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.MimeTypeDAO.findAll(MimeTypeDAO.java:204)
	at com.openkm.core.MimeTypeConfig.loadMimeTypes(MimeTypeConfig.java:103)
	at com.openkm.servlet.RepositoryStartupServlet.start(RepositoryStartupServlet.java:214)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:127)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:962)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1603)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.MimeTypeDAO.findAll(MimeTypeDAO.java:198)
	... 20 more
Caused by: java.sql.SQLSyntaxErrorException: usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT6_55_
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 28 more
Caused by: org.hsqldb.HsqlException: usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT6_55_
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
	at org.hsqldb.QueryExpression.resolve(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 39 more
2014-07-24 12:34:01,262 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Activating update info ***
2014-07-24 12:34:01,262 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Activating cron ***
2014-07-24 12:34:01,262 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Activating UI Notification ***
2014-07-24 12:34:01,293 [pool-2-thread-1] INFO  com.openkm.module.common.CommonAuthModule - PrincipalAdapter: com.openkm.principal.DatabasePrincipalAdapter
2014-07-24 12:34:01,308 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Activating thesaurus repository ***
2014-07-24 12:34:01,324 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Start OpenOffice manager ***
2014-07-24 12:34:01,340 [pool-2-thread-1] INFO  com.openkm.util.DocConverter - *** Build Office Manager ***
2014-07-24 12:34:01,340 [pool-2-thread-1] INFO  com.openkm.util.DocConverter - system.openoffice.path=C:/Program Files (x86)/OpenOffice 4
2014-07-24 12:34:01,340 [pool-2-thread-1] INFO  com.openkm.util.DocConverter - system.openoffice.tasks=200
2014-07-24 12:34:01,340 [pool-2-thread-1] INFO  com.openkm.util.DocConverter - system.openoffice.port=2002
2014-07-24 12:34:01,355 [pool-2-thread-1] INFO  org.artofsolving.jodconverter.office.ProcessPoolOfficeManager - ProcessManager implementation is SigarProcessManager
2014-07-24 12:34:01,489 [pool-2-thread-1] WARN  com.openkm.servlet.RepositoryStartupServlet - failed to start and connect
org.artofsolving.jodconverter.office.OfficeException: failed to start and connect
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:64)
	at org.artofsolving.jodconverter.office.PooledOfficeManager.start(PooledOfficeManager.java:101)
	at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.start(ProcessPoolOfficeManager.java:62)
	at com.openkm.util.DocConverter.start(DocConverter.java:190)
	at com.openkm.servlet.RepositoryStartupServlet.start(RepositoryStartupServlet.java:273)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:127)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:962)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1603)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
Caused by: java.util.concurrent.ExecutionException: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.util.concurrent.FutureTask.get(FutureTask.java:188)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:62)
	... 22 more
Caused by: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:142)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:31)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:58)
	... 5 more
Caused by: java.lang.IllegalStateException: a process with acceptString 'socket,host=127.0.0.1,port=2002' is already running; pid 9348
	at org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:67)
	at org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:60)
	at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:119)
	... 7 more
2014-07-24 12:34:01,489 [pool-2-thread-1] INFO  com.openkm.extension.core.ExtensionManager - Initialize and load plugins...
2014-07-24 12:34:01,570 [pool-2-thread-1] WARN  net.xeoh.plugins.base.impl.classpath.loader.FileLoader - Supplied path does not exist. Unable to add plugins from there.
2014-07-24 12:34:01,570 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Execute start script ***
2014-07-24 12:34:01,570 [pool-2-thread-1] WARN  com.openkm.util.ExecutionUtils - Unable to read script: C:\openkm-6.2.5community\tomcat\start.bsh
2014-07-24 12:34:01,570 [pool-2-thread-1] WARN  com.openkm.util.ExecutionUtils - Unable to read jar: C:\openkm-6.2.5community\tomcat\start.jar
2014-07-24 12:34:01,570 [pool-2-thread-1] INFO  com.openkm.servlet.RepositoryStartupServlet - *** Execute start SQL ***
2014-07-24 12:34:01,570 [pool-2-thread-1] WARN  com.openkm.servlet.RepositoryStartupServlet - Unable to read sql: C:\openkm-6.2.5community\tomcat\start.sql
2014-07-24 12:34:01,617 [pool-2-thread-1] WARN  org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet - CMIS version is not defined! Setting it to CMIS 1.0.
2014-07-24 12:34:01,664 [pool-2-thread-1] INFO  org.apache.catalina.startup.HostConfig - Despliegue del directorio C:\openkm-6.2.5community\tomcat\webapps\docs de la aplicación web
2014-07-24 12:34:01,710 [pool-2-thread-1] INFO  org.apache.catalina.startup.HostConfig - Despliegue del directorio C:\openkm-6.2.5community\tomcat\webapps\examples de la aplicación web
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/core is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
2014-07-24 12:34:01,820 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.tomcat.util.digester.Digester - TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/examples] - ContextListener: contextInitialized()
2014-07-24 12:34:01,835 [pool-2-thread-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/examples] - SessionListener: contextInitialized()
2014-07-24 12:34:01,851 [pool-2-thread-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/examples] - ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@16e612a')
2014-07-24 12:34:01,851 [pool-2-thread-1] INFO  org.apache.catalina.startup.HostConfig - Despliegue del directorio C:\openkm-6.2.5community\tomcat\webapps\host-manager de la aplicación web
2014-07-24 12:34:01,898 [pool-2-thread-1] INFO  org.apache.catalina.startup.HostConfig - Despliegue del directorio C:\openkm-6.2.5community\tomcat\webapps\manager de la aplicación web
2014-07-24 12:34:01,944 [pool-2-thread-1] INFO  org.apache.catalina.startup.HostConfig - Despliegue del directorio C:\openkm-6.2.5community\tomcat\webapps\ROOT de la aplicación web
2014-07-24 12:34:01,991 [    main] INFO  org.apache.coyote.http11.Http11Protocol - Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2014-07-24 12:34:01,991 [    main] INFO  org.apache.coyote.ajp.AjpProtocol - Starting ProtocolHandler ["ajp-bio-8009"]
2014-07-24 12:34:01,991 [    main] INFO  org.apache.catalina.startup.Catalina - Server startup in 64282 ms
2014-07-24 12:34:29,134 [http-bio-0.0.0.0-8080-exec-5] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - RepositoryServlet: ERROR: The serialization policy file '/frontend/B9523FAA790CD867CEB9825702B60479.gwt.rpc' was not found; did you forget to include it in this deployment?
2014-07-24 12:34:29,134 [http-bio-0.0.0.0-8080-exec-7] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - DashboardServlet: ERROR: The serialization policy file '/frontend/B38E0759B0C91C0CDB53E963A8D48914.gwt.rpc' was not found; did you forget to include it in this deployment?
2014-07-24 12:34:29,136 [http-bio-0.0.0.0-8080-exec-7] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - DashboardServlet: WARNING: Failed to get the SerializationPolicy 'B38E0759B0C91C0CDB53E963A8D48914' for module 'http://localhost:8080/OpenKM/frontend/'; a legacy, 1.3.3 compatible, serialization policy will be used.  You may experience SerializationExceptions as a result.
2014-07-24 12:34:29,136 [http-bio-0.0.0.0-8080-exec-10] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - RepositoryServlet: ERROR: The serialization policy file '/frontend/B9523FAA790CD867CEB9825702B60479.gwt.rpc' was not found; did you forget to include it in this deployment?
2014-07-24 12:34:29,144 [http-bio-0.0.0.0-8080-exec-10] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - RepositoryServlet: WARNING: Failed to get the SerializationPolicy 'B9523FAA790CD867CEB9825702B60479' for module 'http://localhost:8080/OpenKM/frontend/'; a legacy, 1.3.3 compatible, serialization policy will be used.  You may experience SerializationExceptions as a result.
2014-07-24 12:34:29,136 [http-bio-0.0.0.0-8080-exec-5] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - RepositoryServlet: WARNING: Failed to get the SerializationPolicy 'B9523FAA790CD867CEB9825702B60479' for module 'http://localhost:8080/OpenKM/frontend/'; a legacy, 1.3.3 compatible, serialization policy will be used.  You may experience SerializationExceptions as a result.
2014-07-24 12:34:29,276 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.config.GlobalSettings - Trying to find Dozer configuration file: dozer.properties
2014-07-24 12:34:29,286 [http-bio-0.0.0.0-8080-exec-5] WARN  org.dozer.config.GlobalSettings - Dozer configuration file not found: dozer.properties.  Using defaults for all Dozer global properties.
2014-07-24 12:34:29,291 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.DozerInitializer - Initializing Dozer. Version: 5.3.2, Thread Name: http-bio-0.0.0.0-8080-exec-5
2014-07-24 12:34:29,294 [http-bio-0.0.0.0-8080-exec-9] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - GeneralServlet: ERROR: The serialization policy file '/frontend/1D321FB65775A823E9919192300FCBD6.gwt.rpc' was not found; did you forget to include it in this deployment?
2014-07-24 12:34:29,294 [http-bio-0.0.0.0-8080-exec-9] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - GeneralServlet: WARNING: Failed to get the SerializationPolicy '1D321FB65775A823E9919192300FCBD6' for module 'http://localhost:8080/OpenKM/frontend/'; a legacy, 1.3.3 compatible, serialization policy will be used.  You may experience SerializationExceptions as a result.
2014-07-24 12:34:29,299 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.jmx.JMXPlatformImpl - Dozer JMX MBean [org.dozer.jmx:type=DozerStatisticsController] auto registered with the Platform MBean Server
2014-07-24 12:34:29,301 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.jmx.JMXPlatformImpl - Dozer JMX MBean [org.dozer.jmx:type=DozerAdminController] auto registered with the Platform MBean Server
2014-07-24 12:34:29,311 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.DozerBeanMapper - Initializing a new instance of dozer bean mapper.
2014-07-24 12:34:29,331 [http-bio-0.0.0.0-8080-exec-7] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - WorkspaceServlet: ERROR: The serialization policy file '/frontend/4D0D1702ACB7719D0F74BBC8F7C6867B.gwt.rpc' was not found; did you forget to include it in this deployment?
2014-07-24 12:34:29,347 [http-bio-0.0.0.0-8080-exec-7] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - WorkspaceServlet: WARNING: Failed to get the SerializationPolicy '4D0D1702ACB7719D0F74BBC8F7C6867B' for module 'http://localhost:8080/OpenKM/frontend/'; a legacy, 1.3.3 compatible, serialization policy will be used.  You may experience SerializationExceptions as a result.
2014-07-24 12:34:29,362 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.loader.CustomMappingsLoader - Using the following xml files to load custom mappings for the bean mapper instance: [dozerBeanMapping.xml]
2014-07-24 12:34:29,362 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.loader.CustomMappingsLoader - Trying to find xml mapping file: dozerBeanMapping.xml
2014-07-24 12:34:29,362 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.loader.CustomMappingsLoader - Using URL [file:/C:/openkm-6.2.5community/tomcat/webapps/OpenKM/WEB-INF/classes/dozerBeanMapping.xml] to load custom xml mappings
2014-07-24 12:34:29,378 [http-bio-0.0.0.0-8080-exec-5] INFO  org.dozer.loader.CustomMappingsLoader - Successfully loaded custom xml mappings from URL: [file:/C:/openkm-6.2.5community/tomcat/webapps/OpenKM/WEB-INF/classes/dozerBeanMapping.xml]
2014-07-24 12:34:29,487 [http-bio-0.0.0.0-8080-exec-7] INFO  com.openkm.vernum.VersionNumerationFactory - VersionNumerationAdapter: com.openkm.vernum.MajorMinorVersionNumerationAdapter
2014-07-24 12:34:29,518 [http-bio-0.0.0.0-8080-exec-7] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: -5501, SQLState: 42501
2014-07-24 12:34:29,534 [http-bio-0.0.0.0-8080-exec-7] ERROR org.hibernate.util.JDBCExceptionReporter - usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT_SEARCH
2014-07-24 12:34:29,534 [http-bio-0.0.0.0-8080-exec-7] ERROR com.openkm.servlet.frontend.WorkspaceServlet - could not execute query
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.MimeTypeDAO.findBySearch(MimeTypeDAO.java:231)
	at com.openkm.servlet.frontend.WorkspaceServlet.getUserWorkspace(WorkspaceServlet.java:421)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
	at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
	at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
	at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.MimeTypeDAO.findBySearch(MimeTypeDAO.java:225)
	... 50 more
Caused by: java.sql.SQLSyntaxErrorException: usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT_SEARCH
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 58 more
Caused by: org.hsqldb.HsqlException: usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT_SEARCH
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
	at org.hsqldb.QueryExpression.resolve(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 69 more
2014-07-24 12:34:29,549 [http-bio-0.0.0.0-8080-exec-7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - Exception while dispatching incoming RPC call
com.google.gwt.user.client.rpc.SerializationException: Type 'com.openkm.frontend.client.OKMException' was not assignable to 'com.google.gwt.user.client.rpc.IsSerializable' and did not have a custom field serializer.For security purposes, this type will not be serialized.: instance = com.openkm.frontend.client.OKMException: could not execute query
	at com.google.gwt.user.server.rpc.impl.ServerSerializationStreamWriter.serialize(ServerSerializationStreamWriter.java:619)
	at com.google.gwt.user.client.rpc.impl.AbstractSerializationStreamWriter.writeObject(AbstractSerializationStreamWriter.java:126)
	at com.google.gwt.user.server.rpc.impl.ServerSerializationStreamWriter$ValueWriter$8.write(ServerSerializationStreamWriter.java:153)
	at com.google.gwt.user.server.rpc.impl.ServerSerializationStreamWriter.serializeValue(ServerSerializationStreamWriter.java:539)
	at com.google.gwt.user.server.rpc.RPC.encodeResponse(RPC.java:616)
	at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:390)
	at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:588)
	at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
	at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
	at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Sat Jul 26, 2014 6:21 pm
by jllort
Has seguido los pasos exactamente como se indican aqui ? En especial la parte esta que añade una columna ( esto lo puedes hacer con la 6.2.5 levantanda, porque cuando arrancas la 6.3.0 esto ya debería estar hecho ). Que base de datos estas utilizando ?

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Mon Jul 28, 2014 11:45 am
by maraf1
Creo que sí.
Lo he vuelto a hacer. Primero de la 6.2.5 a la 6.2.6 y perfecto.
He pasado los scripts en la 6.2.6 y una vez que vuelvo a cambiar el .WAR (eliminarndo la carpeta y poniendo el parámetro en update)
Me arranca el TOMCAT pero en el login del OpenKM se queda "cargando datos de usuario..."

He problado también borrando estos directorios:
$TOMCAT_HOME/webapps/OpenKM
$TOMCAT_HOME/work/Catalina/localhost

Estoy utilizando la BBDD que viene por defecto....
Una vez controle algo más intentaré pasarme a MySQL... pero poco a poco.

Lo he hecho con 3 versiones "limpias" y nada. HE instalado 6.2.5 y sin incluir nada ni dar de alta usuarios ni nada he pasado a la 6.2.6 y perfecto.
He hecho lo mismo después con la 6.3.0 y se queda en "cargando datos de usuario"

El log arroja un error: usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT_SEARCH
Lo primero es poder cambiar de version sin problemas. Lo he repetido varias veces y siempre el mismo resultado.

HELP ME!!

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Wed Jul 30, 2014 2:04 pm
by maraf1
Paquete que es uno.

YA está arreglado. Tenía que escoger la opcion JDBC al esjecuitar las selects


Perfecto.

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Sun Aug 03, 2014 8:48 am
by jllort
Nos alegramos que lo hayas arreglado, siempre que veas algo de este estilo = "usuario no tiene privilegios suficientes o objeto no encontrado: MIMETYPE0_.MT_SEARCH", el sistema te esta indicando que algo de base de datos le falta ( no te dejes engañar por el tema que te dice que no tienes privilegios, lo que en realidad pasa es que el campo MT_SEARCH no lo encuentra ( sea por privilegios, cosa rara o porque en realidad no existe en la base de datos, que en el 99% de los casos será este último )

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Sat Apr 29, 2017 1:37 pm
by olortegui
Disculpa, puedes poner un ejemplo de como lo solucionaste.
Gracias.

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Sat Apr 29, 2017 1:38 pm
by olortegui
maraf1 wrote: Wed Jul 30, 2014 2:04 pm Paquete que es uno.

YA está arreglado. Tenía que escoger la opcion JDBC al esjecuitar las selects


Perfecto.
Disculpa, puedes poner un ejemplo de como lo solucionaste.
Gracias.

Re: Problema pasar de version 6.2.5 a 6.3.0

PostPosted:Sun Apr 30, 2017 5:39 pm
by jllort
Una forma de hacerlo es entrar en la administración, eliminar la tabla problemática y poner el OpenKM en update. Antes de hacer esta operación te recomendamos que hagas un backup. Por cierto con que base de datos tienes OpenKM configurado ?