Original Message:
Sent: 8/2/2023 7:31:00 AM
From: Carl Messner
Subject: RE: Pentaho CDE Error: "Sorry, something went wrong...."
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
------------------------------
Original Message:
Sent: 08-02-2023 06:38
From: Arif Mughal
Subject: Pentaho CDE Error: "Sorry, something went wrong...."
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
Original Message:
Sent: 8/2/2023 5:15:00 AM
From: Carl Messner
Subject: RE: Pentaho CDE Error: "Sorry, something went wrong...."
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
Original Message:
Sent: 08-01-2023 13:22
From: Arif Mughal
Subject: Pentaho CDE Error: "Sorry, something went wrong...."
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.
Original Message:
Sent: 8/1/2023 10:02:00 AM
From: Carl Messner
Subject: Pentaho CDE Error: "Sorry, something went wrong...."
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
------------------------------