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.
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.
Post Reply
maraf1
Senior Boarder
Senior Boarder
Posts: 62
Joined: Thu Oct 31, 2013 1:54 pm

Problema pasar de version 6.2.5 a 6.3.0

Post by maraf1 » Thu Jul 24, 2014 9:26 am

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

maraf1
Senior Boarder
Senior Boarder
Posts: 62
Joined: Thu Oct 31, 2013 1:54 pm

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by maraf1 » Thu Jul 24, 2014 10:44 am

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)

jllort
Moderator
Moderator
Posts: 9447
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by jllort » Sat Jul 26, 2014 6:21 pm

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 ?

maraf1
Senior Boarder
Senior Boarder
Posts: 62
Joined: Thu Oct 31, 2013 1:54 pm

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by maraf1 » Mon Jul 28, 2014 11:45 am

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!!

maraf1
Senior Boarder
Senior Boarder
Posts: 62
Joined: Thu Oct 31, 2013 1:54 pm

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by maraf1 » 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.

jllort
Moderator
Moderator
Posts: 9447
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by jllort » Sun Aug 03, 2014 8:48 am

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 )

olortegui
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: Sat Apr 29, 2017 1:34 pm

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by olortegui » Sat Apr 29, 2017 1:37 pm

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

olortegui
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: Sat Apr 29, 2017 1:34 pm

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by olortegui » Sat Apr 29, 2017 1:38 pm

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.

jllort
Moderator
Moderator
Posts: 9447
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Problema pasar de version 6.2.5 a 6.3.0

Post by jllort » Sun Apr 30, 2017 5:39 pm

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 ?

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest