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

  • 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.
 #44085  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.
 #44109  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
 #44117  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

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.