• Problema pasar de version 6.2.5 a 6.3.0

  • Problemas con la instalación de OpenKM? No problemo, la solución está más cerca de lo que piensas.
Problemas con la instalación de OpenKM? No problemo, la solución está más cerca de lo que piensas.
Forum rules: Por favor, antes de preguntar algo consulta el wiki de documentación o utiliza la función de búsqueda del foro. Recuerda que no tenemos una bola de cristal ni poderes mentales, o sea que que para informar sobre un error es necesario que nos indiques tanto la versión de OpenKM que usas como la del navegador y sistema operativo. Para más información consulta Cómo informar de fallos de forma efectiva.
 #29395  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
 #29396  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)
 #29415  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 ?
 #29426  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!!
 #29473  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 )
 #43720  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.
 #43725  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 ?

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.