Pentaho

 View Only
  • 1.  Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-01-2023 10:02

    Greetings

    I'm using Pentaho CE 9.4 on a Windows Server 2016 with Java 11
    I have no problems with PDI but from time to time something happens using dashaboards.
    In PUC when trying to open a dashboard, i get the error message:
    "Sorry, something went wrong
    Pleasy try again or contact your system administrator"
    Cheking the logs, i see at localhost.log the messsage:
    SEVERE [https-openssl-nio-8444-exec-3] org.apache.catalina.core.StandardWrapperValve.invoke El Servlet.service() para el servlet [jaxrsEndpoint-spring] en el contexto con ruta [/pentaho] lanzó la excepción [La ejecución del Servlet lanzó una excepción] con causa raíz
    javax.jcr.PathNotFoundException: /pentaho/tenant0/public/cde/components
    at org.apache.jackrabbit.core.session.SessionItemOperation.perform(SessionItemOperation.java:192)
    at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216)
    at org.apache.jackrabbit.core.SessionImpl.perform(SessionImpl.java:363)
    at org.apache.jackrabbit.core.SessionImpl.getItem(SessionImpl.java:826)
    at jdk.internal.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory$LogoutSuppressingInvocationHandler.invoke(CredentialsStrategySessionFactory.java:657)
    at com.sun.proxy.$Proxy133.getItem(Unknown Source)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileUtils.getTree(JcrRepositoryFileUtils.java:1141)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao$26.doInJcr(JcrRepositoryFileDao.java:1063)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.execute(PentahoJcrTemplate.java:74)
    at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:115)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao.getTree(JcrRepositoryFileDao.java:1058)
    at org.pentaho.platform.repository2.unified.DefaultUnifiedRepository.getTree(DefaultUnifiedRepository.java:490)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:61)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
    at com.sun.proxy.$Proxy134.getTree(Unknown Source)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$42.call(ExceptionLoggingDecorator.java:470)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$42.call(ExceptionLoggingDecorator.java:468)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:537)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:518)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getTree(ExceptionLoggingDecorator.java:468)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getTree(ExceptionLoggingDecorator.java:478)
    at pt.webdetails.cpf.repository.pentaho.unified.UnifiedRepositoryAccess.listFiles(UnifiedRepositoryAccess.java:406)
    at pt.webdetails.cpf.repository.pentaho.unified.UnifiedRepositoryAccess.listFiles(UnifiedRepositoryAccess.java:345)
    at pt.webdetails.cdf.dd.model.meta.reader.cdexml.fs.XmlFsPluginModelReader.readCustomComponentsLocation(XmlFsPluginModelReader.java:198)
    at pt.webdetails.cdf.dd.model.meta.reader.cdexml.fs.XmlFsPluginModelReader.readCustomComponentsLocations(XmlFsPluginModelReader.java:188)
    at pt.webdetails.cdf.dd.model.meta.reader.cdexml.fs.XmlFsPluginModelReader.readComponents(XmlFsPluginModelReader.java:182)
    at pt.webdetails.cdf.dd.model.meta.reader.cdexml.fs.XmlFsPluginModelReader.read(XmlFsPluginModelReader.java:99)
    at pt.webdetails.cdf.dd.MetaModelManager.readModel(MetaModelManager.java:118)
    at pt.webdetails.cdf.dd.MetaModelManager.<init>(MetaModelManager.java:56)
    at pt.webdetails.cdf.dd.MetaModelManager.<clinit>(MetaModelManager.java:41)
    at pt.webdetails.cdf.dd.DashboardManager.readDashboardFromCdfdeJs(DashboardManager.java:473)
    at pt.webdetails.cdf.dd.DashboardManager.getDashboard(DashboardManager.java:450)
    at pt.webdetails.cdf.dd.DashboardManager.getDashboardCdfRunJs(DashboardManager.java:228)
    at pt.webdetails.cdf.dd.DashboardManager.getDashboardCdfRunJs(DashboardManager.java:165)
    at pt.webdetails.cdf.dd.api.RenderApi.loadDashboard(RenderApi.java:497)
    at pt.webdetails.cdf.dd.api.RenderApi.render(RenderApi.java:207)
    at pt.webdetails.cdf.dd.DashboardDesignerContentGenerator.createContent(DashboardDesignerContentGenerator.java:127)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:240)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:165)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:57)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:36)
    at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:302)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    at org.pentaho.platform.web.servlet.JAXRSServlet$InternalWebComponent.service(JAXRSServlet.java:288)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:139)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:144)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:238)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:90)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)
    at org.pentaho.platform.web.http.filters.PreFlightReportingFilter.doFilter(PreFlightReportingFilter.java:50)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.pentaho.platform.web.http.filters.PentahoMDCFilter.doFilter(PentahoMDCFilter.java:72)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:192)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:149)
    at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternalSuper(PentahoBasicProcessingFilter.java:123)
    at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:117)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:283)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at com.hitachivantara.security.web.impl.service.cors.servlet.CorsProtocolFilter.doFilter(CorsProtocolFilter.java:80)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at com.hitachivantara.security.web.impl.service.csrf.servlet.CsrfGateFilter.doFilter(CsrfGateFilter.java:202)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:58)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:73)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.base/java.lang.Thread.run(Thread.java:834)
    And in the catalina.log i have this message:
    01-Aug-2023 10:42:02.277 WARNING [https-openssl-nio-8444-exec-5] com.sun.jersey.spi.inject.Errors.processErrorMessages The following warnings have been detected with resource and/or provider classes:
      WARNING: A sub-resource method, public org.pentaho.platform.web.http.api.resources.JaxbList org.pentaho.platform.dataaccess.datasource.api.resources.JDBCDatasourceResource.getConnectionIDs(), with URI template, "/", is treated as a resource method
      
      
      Any clue of what is the source of the error or what is the solution?
      Thank you in advance


    ------------------------------
    Carl Messner
    Administrative Assistant
    MCSF
    ------------------------------


  • 2.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-01-2023 13:21
    I also face this issue, but only that time when I restart the server. And on running position server I don't face it. For solution I again and again restart the server until issue resolved.

    Thanks & Regards,

    Arif Mughal







  • 3.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-01-2023 13:23
    I also face this issue, but only that time when I restart the server. And on running position server I don't face it. For solution, I again and again restart the server until the issue resolve.
    Arif Mughal







  • 4.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-02-2023 05:15

    Hi Arif, 

    Yes, i had noted too that the issue solves by itself after restart the server again and previously i delete the contents of  the folders:
    \pentaho\server\pentaho-server\tomcat\temp
    \pentaho\server\pentaho-server\tomcat\work\Catalina\localhost
    \pentaho\server\pentaho-server\pentaho-solutions\system\jackrabbit\repository

    \pentaho\server\pentaho-server\pentaho-solutions\system\karaf\caches

    But i have no clue what is the origin ot the issue and if there is a way fo fix it definitly.

    Best regards



    ------------------------------
    Carl Messner
    Administrative Assistant
    MCSF
    ------------------------------



  • 5.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-02-2023 06:39

    I this safe to delete the contents of the following folders?

    \pentaho\server\pentaho-server\tomcat\work\Catalina\localhost
    \pentaho\server\pentaho-server\pentaho-solutions\system\jackrabbit\repository

    Arif Mughal






  • 6.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-02-2023 07:31

    Yes

    ...\Catalina\localhost

    I have the repository on postgresql, so it's safe to delete the folder. But i'm not sure if it's safe to delete it in case the repository is on  hsqldb

    ..\jackrabbit\repository



    ------------------------------
    Carl Messner
    Data Analyst
    MCSF
    ------------------------------



  • 7.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-02-2023 07:41
    ok thanks
    Arif Mughal






  • 8.  RE: Pentaho CDE Error: "Sorry, something went wrong...."

    Posted 08-07-2023 05:40
    Does anyone have a clue about the source of the error or the solution? @Community Team ?
    Thank you in advance


    ------------------------------
    Carl Messner
    Administrative Assistant
    MCSF
    ------------------------------