Open neolinkbb opened 5 years ago
brunogamacatao
commented
5 years ago I am trying to reproduce this issue on the image you've sent me. If you could please send me your Saiku logs, it would really help me to fix this problem earlier. Thank you so much.
neolinkbb
commented
5 years ago Hi,
This is the logs of when i press Properties : ReferenceError: ChartEditor is not defined jquery.min.js line 4 > eval:87:14 jQuery 4 show_editor show dispatch handle
This the logs of when i try to execute a saved query : Error performing POST on /saiku/rest/saiku/api/query/8ACF06CE-793F-07F4-983A-8A37C573C511 SaikuServer.js:106:17 failure https://saiku-cd.neolink.link/js/saiku/adapters/SaikuServer.js:106 jQuery 4 c fireWith k r Internal Server Error SaikuServer.js:107:17 failure https://saiku-cd.neolink.link/js/saiku/adapters/SaikuServer.js:107 jQuery 4 c fireWith k r
Thanks and i hope it will help you.
Regards,
Blandine Bouchacourt Data Analyst 22, rue Christophe Colomb – 41000 Blois blandine.b@neolink.linkmailto:blandine.b@neolink.link [neolink]https://www.neolink.link/
De : Bruno Gama Catão notifications@github.com Envoyé : dimanche 29 septembre 2019 16:20 À : OSBI/saiku saiku@noreply.github.com Cc : Blandine BOUCHACOURT blandine.b@neolink.link; Author author@noreply.github.com Objet : Re: [OSBI/saiku] I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) (#708)
I am trying to reproduce this issue on the image you've sent me. If you could please send me your Saiku logs, it would really help me to fix this problem earlier. Thank you so much.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/OSBI/saiku/issues/708?email_source=notifications&email_token=ANJ62MXISIMJAPB7POCI3K3QMC2PRA5CNFSM4I2X2CT2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD73WAIY#issuecomment-536305699, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ANJ62MX7MKA6DL4V4PKYXB3QMC2PRANCNFSM4I2X2CTQ.
neolinkbb
commented
5 years ago Hi,
You can find the logs of when i want to execute a saved query attached to this mail. And i don’t have any log of when i press properties.
Thanks.
Regards,
Blandine Bouchacourt Data Analyst 22, rue Christophe Colomb – 41000 Blois blandine.b@neolink.linkmailto:blandine.b@neolink.link [neolink]https://www.neolink.link/
De : Blandine BOUCHACOURT Envoyé : lundi 30 septembre 2019 09:25 À : OSBI/saiku reply@reply.github.com; OSBI/saiku saiku@noreply.github.com Cc : Author author@noreply.github.com Objet : RE: [OSBI/saiku] I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) (#708)
Hi,
This is the logs of when i press Properties : ReferenceError: ChartEditor is not defined jquery.min.js line 4 > eval:87:14 jQuery 4 show_editor show dispatch handle
This the logs of when i try to execute a saved query : Error performing POST on /saiku/rest/saiku/api/query/8ACF06CE-793F-07F4-983A-8A37C573C511 SaikuServer.js:106:17 failure https://saiku-cd.neolink.link/js/saiku/adapters/SaikuServer.js:106 jQuery 4 c fireWith k r Internal Server Error SaikuServer.js:107:17 failure https://saiku-cd.neolink.link/js/saiku/adapters/SaikuServer.js:107 jQuery 4 c fireWith k r
Thanks and i hope it will help you.
Regards,
Blandine Bouchacourt Data Analyst 22, rue Christophe Colomb – 41000 Blois blandine.b@neolink.linkmailto:blandine.b@neolink.link [neolink]https://www.neolink.link/
De : Bruno Gama Catão notifications@github.com<mailto:notifications@github.com> Envoyé : dimanche 29 septembre 2019 16:20 À : OSBI/saiku saiku@noreply.github.com<mailto:saiku@noreply.github.com> Cc : Blandine BOUCHACOURT blandine.b@neolink.link<mailto:blandine.b@neolink.link>; Author author@noreply.github.com<mailto:author@noreply.github.com> Objet : Re: [OSBI/saiku] I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) (#708)
I am trying to reproduce this issue on the image you've sent me. If you could please send me your Saiku logs, it would really help me to fix this problem earlier. Thank you so much.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/OSBI/saiku/issues/708?email_source=notifications&email_token=ANJ62MXISIMJAPB7POCI3K3QMC2PRA5CNFSM4I2X2CT2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD73WAIY#issuecomment-536305699, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ANJ62MX7MKA6DL4V4PKYXB3QMC2PRANCNFSM4I2X2CTQ.
09:35:10,707 ERROR [SecurityAwareConnectionManager] Error connecting: job java.lang.NullPointerException at org.saiku.web.core.SecurityAwareConnectionManager.connect(SecurityAwareConnectionManager.java:294) at org.saiku.web.core.SecurityAwareConnectionManager.getInternalConnection(SecurityAwareConnectionManager.java:109) at org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:134) at org.saiku.datasources.connection.AbstractConnectionManager.getOlapConnection(AbstractConnectionManager.java:197) at org.saiku.olap.discover.OlapMetaExplorer.getNativeCube(OlapMetaExplorer.java:168) at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:95) at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:212) at org.saiku.service.olap.ThinQueryService.createQuery(ThinQueryService.java:137) at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:165) at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) 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 com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:168) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:162) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 09:35:10,708 ERROR [Query2Resource] Error creating new query org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:224) at org.saiku.service.olap.ThinQueryService.createQuery(ThinQueryService.java:137) at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:165) at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) 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 com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:168) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:162) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:97) at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:212) ... 80 more Caused by: org.saiku.olap.util.exception.SaikuOlapException: Cannot get native cube for ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.olap.discover.OlapMetaExplorer.getNativeCube(OlapMetaExplorer.java:189) at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:95) ... 81 more 30-Sep-2019 09:35:10.710 SEVERE [http-nio-8080-exec-106] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 500 (Internal Server Error) javax.ws.rs.WebApplicationException: org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:168) at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) 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 com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:168) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:162) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:224) at org.saiku.service.olap.ThinQueryService.createQuery(ThinQueryService.java:137) at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:165) ... 78 more Caused by: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:97) at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:212) ... 80 more Caused by: org.saiku.olap.util.exception.SaikuOlapException: Cannot get native cube for ( [job].[Cubes Job].[Cubes Job].[internaute] ) at org.saiku.olap.discover.OlapMetaExplorer.getNativeCube(OlapMetaExplorer.java:189) at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:95) ... 81 more
brunogamacatao
commented
5 years ago Dear Blandine,
Can you please check if the cube '[job].[Cubes Job].[Cubes Job].[internaute]' exists in your schema definition?
This error is being thrown by a class named OlapMetaExplorer, method getNativeCube. It is trying to find the before mentioned cube on your OLAP connection. Depending on your DBMS it may be case sensitive, so, if your table is named Internaute instead of internaute it may have a problem to find it.
Feel free to send me your schema definition file, so I can check it for any problem.
Thanks a lot, Bruno
neolinkbb
commented
5 years ago Hi Bruno,
In my schema (job.xml saved on Data Source Management/Schema on Saiku) i have this following lines for the cube Internaute :
My table’s name is dim_internaute. I didn’t change anything since before summer holidays. It was working at this time.
Is it what you want to know ?
Regards,
Blandine Bouchacourt Data Analyst 22, rue Christophe Colomb – 41000 Blois blandine.b@neolink.linkmailto:blandine.b@neolink.link [neolink]https://www.neolink.link/
De : Bruno Gama Catão notifications@github.com Envoyé : dimanche 6 octobre 2019 18:31 À : OSBI/saiku saiku@noreply.github.com Cc : Blandine BOUCHACOURT blandine.b@neolink.link; Author author@noreply.github.com Objet : Re: [OSBI/saiku] I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) (#708)
Dear Blandine,
Can you please check if the cube '[job].[Cubes Job].[Cubes Job].[internaute]' exists in your schema definition? This error is being thrown by a class named OlapMetaExplorer, method getNativeCube. It is trying to find the before mentioned cube on your OLAP connection. Depending on your DBMS it may be case sensitive, so, if your table is named Internaute instead of internaute it may have a problem to find it. Feel free to send me your schema definition file, so I can check it for any problem.
Thanks a lot, Bruno
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/OSBI/saiku/issues/708?email_source=notifications&email_token=ANJ62MR6NYWVJITRRVRQTWDQNIHDZA5CNFSM4I2X2CT2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAOOEJQ#issuecomment-538763814, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ANJ62MWMYACQAC5ZZ4NBLRDQNIHDZANCNFSM4I2X2CTQ.
Is this a bug report?
YES
Environment
java -version: java version "1.8.0_211" Java(TM) SE Runtime Environment (build 1.8.0_211-b12) Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)Operating system: CentOS (server where Saiku was installed), Windows 10 family (my computer)
Browser and version (if relevant) : Firefox 69.0.1 (64 bits)
Saiku plugin to Pentaho or Saiku Standalone : Saiku Standalone
Saiku CE or Saiku EE : Saiku EE
Saiku version: Saiku Suite V2.1 GA
Problem
We had a problem during this summer : my team restart Saiku and Kylin. We lost all our cube. So i had to create again the cube. On Saiku, one of our data source was delete (I don’t know how and why). I create again a new data source copying the other one (who was not deleted). It didn't work because i used the same name as the last one. So i had to change the name of the data source. It works and i had access to all my cube. This is the data source configuration :
The losted data source name was « job » and the new one name is « job1 ». The problem we have now is that all the query save is not accessible anymore. The only solution i had was to create again all the query. Do you know if there is an other solution or something to do in case we have the same problem ?
The message we have when we tried to execute our saved query :
We tried to find where was save the data source but we didn’t find anything. Do you know were it’s save ? Can we recover the first data source "job" ? I think it’s the cause of our problem.
Another thing is that we don’t have access to the Properties menu on the Chart Mode. When I press on Properties nothing happen. How can i solve this ? Do i have to change something on Saiku configuration ?
Thanks for your help.