Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

https://forum.openkm.com/viewtopic.php?t=21366

Page 1 of 1

javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Wed Jun 14, 2017 5:39 pm
by zomer_1993
Que tal, me gustaría que me apoyaran con este error que me lanza al ir a http://My-IP:8080/OpenKM/
Code: Select all
Class:	org.apache.jasper.JasperException
Message:	javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query
Date:	Wed Jun 14 12:02:40 CDT 2017
Estoy utilizando una VM (Centos 7 Minimal) en la cual instale openkm-6.3.2-community-tomcat-bundle.zip tal y como lo marca el Manual de instalación que proporciona OpenKM https://docs.openkm.com/kcenter/view/ok ... entos.html.
Al dirigirme a la dirección http://My-IP:8080/OpenKM/ utilizando Windows 10 en navegador Chrome me muestra el mensaje que les comento y lo que me despliega catalina.log es lo siguiente:
Code: Select all
2017-06-14 12:02:40,388 [http-bio-0.0.0.0-8080-exec-4] ERROR org.apache.catalina  .core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp]- El Servlet.service()   para el servlet [jsp] en el contexto con ruta [/OpenKM] lanzó la excepción [org  .apache.jasper.JasperException: javax.servlet.ServletException: com.openkm.core.  DatabaseException: could not execute query] con causa raíz
org.hsqldb.HsqlException: usuario no tiene privilegios suficientes o objeto no e  ncontrado: OKM_LANGUAGE
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.SchemaManager.getTable(Unknown Source)
        at org.hsqldb.ParserDQL.readTableName(Unknown Source)
        at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
        at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
        at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
        at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
        at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
        at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
        at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
        at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
        at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
        at org.hsqldb.ParserDQL.XreadQueryExpression(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)
        at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(Del  egatingConnection.java:281)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrap  per.prepareStatement(PoolingDataSource.java:313)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch  er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch  er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc  her.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(Lo  ader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2542)
        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.ja  va: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.LanguageDAO.findAll(LanguageDAO.java:104)
        at com.openkm.dao.LanguageDAO.findAll(LanguageDAO.java:78)
        at org.apache.jsp.login_005fdesktop_jsp._jspService(login_005fdesktop_js  p.java:167)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper  .java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3  90)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl  icationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF  ilterChain.java:208)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp  atcher.java:748)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD  ispatcher.java:604)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis  patcher.java:543)
        at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary  .java:954)
        at org.apache.jsp.login_jsp._jspService(login_jsp.java:63)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper  .java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3  90)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl  icationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF  ilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52  )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl  icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF  ilterChain.java:208)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:311)
        at org.springframework.security.web.access.intercept.FilterSecurityInter  ceptor.invoke(FilterSecurityInterceptor.java:116)
        at org.springframework.security.web.access.intercept.FilterSecurityInter  ceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.access.ExceptionTranslationFilter.do  Filter(ExceptionTranslationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.session.SessionManagementFilter.doFi  lter(SessionManagementFilter.java:101)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.authentication.AnonymousAuthenticati  onFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.servletapi.SecurityContextHolderAwar  eRequestFilter.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.AbstractAuthenticatio  nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.context.SecurityContextPersistenceFi  lter.doFilter(SecurityContextPersistenceFilter.java:87)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.  doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai  nProxy.java:173)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D  elegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat  ingFilterProxy.java:259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl  icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF  ilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV  alve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV  alve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica  torBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j  ava:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j  ava:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:  950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal  ve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav  a:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp  11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(  AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin  t.java:315)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.  java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor  .java:617)
        at java.lang.Thread.run(Thread.java:748)
Agradecería su ayuda.

Re: javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Sat Jun 17, 2017 8:51 am
by jllort
Esto es una instalacion limpia ? porque no utilizas el wizard para llevar a cabo la instalación, en la seccion de descargas tienes la aplicación y un vídeo donde puedes ver el funcionamiento ( el wizard es perfectamente compatible con la centos ).
https://www.openkm.com/en/download.html

Re: javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

PostPosted:Sat Jun 17, 2017 2:02 pm
by zomer_1993
jllort wrote: ↑Sat Jun 17, 2017 8:51 am Esto es una instalacion limpia ? porque no utilizas el wizard para llevar a cabo la instalación, en la seccion de descargas tienes la aplicación y un vídeo donde puedes ver el funcionamiento ( el wizard es perfectamente compatible con la centos ).
https://www.openkm.com/en/download.html
Muchas gracias por tu ayuda, y si llevé a cabo esa instalación, incluso me descargue el pdf. la solución la hallé en este post viewtopic.php?f=3&t=10536&p=24538&hilit ... ion#p24538
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited