--- title: "No Data in Saiku Error" url: "https://openforis.support/questions/459/no-data-in-saiku-error" tags: ["saiku"] status: "answered" score: 0 answer_count: 2 asked: "2016-02-16T09:23:41" last_activity: "2016-02-17T02:42:27" source: "Open Foris Support - Q&A Forum" license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license." --- # No Data in Saiku Error Asked by Somphavy on 2016-02-16 Hi there when i open saiku there is no data as show in the image below ![alt text][1] [1]: http://www.openforis.org/support/upfiles/Untitled_3.png What is the problem and how can i fix it Thanks in advance ## Answer (score 0, by collectearth on 2016-02-16) Link: https://openforis.support/questions/459/no-data-in-saiku-error/460 Hi Somphavy, Was Saiku working previously? Could you copy and paste here the text that comes up on the "black window" which shows the status of the saiku server? You can usually find the problems when Saiku started in that dialog (not the browser interface but the back dialog) ## Answer (score 0, by Somphavy on 2016-02-17) Link: https://openforis.support/questions/459/no-data-in-saiku-error/466 Hi there The Collect Earth is newly install at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:593) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Feb 17, 2016 8:39:29 AM com.sun.jersey.api.core.PackagesResourceConfig init INFO: Scanning for root resource and provider classes in the packages: org.saiku.web Feb 17, 2016 8:39:29 AM com.sun.jersey.api.core.ScanningResourceConfig logClasses INFO: Root resource classes found: class org.saiku.web.rest.resources.ExporterResource class org.saiku.web.rest.resources.BasicRepositoryResource class org.saiku.web.rest.resources.BasicTagRepositoryResource class org.saiku.web.rest.resources.StatisticsResource class org.saiku.web.rest.resources.OlapDiscoverResource class org.saiku.web.rest.resources.DataSourceResource class org.saiku.web.rest.resources.BasicRepositoryResource2 class org.saiku.web.rest.resources.QueryResource class org.saiku.web.rest.resources.FilterRepositoryResource class org.saiku.web.rest.resources.SessionResource Feb 17, 2016 8:39:29 AM com.sun.jersey.api.core.ScanningResourceConfig init INFO: No provider classes found. Feb 17, 2016 8:39:30 AM org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer configure INFO: org.codehaus.enunciate.modules.amf.JAXRSProvider not found. Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, datasourceResourceBean, of type org.saiku.web.rest.resources.DataSourceResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, olapDiscoverBean, of type org.saiku.web.rest.resources.OlapDiscoverResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, queryResource, of type org.saiku.web.rest.resources.QueryResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, sessionResource, of type org.saiku.web.rest.resources.SessionResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, repositoryBean, of type org.saiku.web.rest.resources.BasicRepositoryResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, repository2bean, of type org.saiku.web.rest.resources.BasicRepositoryResource2 as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, tagRepositoryBean, of type org.saiku.web.rest.resources.BasicTagRepositoryResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, filterRepositoryBean, of type org.saiku.web.rest.resources.FilterRepositoryResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, exporterBean, of type org.saiku.web.rest.resources.ExporterResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, statsBean, of type org.saiku.web.rest.resources.StatisticsResource as a root resource class Feb 17, 2016 8:39:30 AM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate INFO: Initiating Jersey application, version 'Jersey: 1.11 12/09/2011 10:27 AM' Feb 17, 2016 8:39:35 AM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-0.0.0.0-8181 Feb 17, 2016 8:39:36 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8109 Feb 17, 2016 8:39:36 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/165 config=null Feb 17, 2016 8:39:36 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 48391 ms name:collectEarth driver:mondrian.olap4j.MondrianOlap4jDriver url:jdbc:mondrian:Jdbc=jdbc:sqlite:C:/Users/JIC/AppData/Roaming/CollectEarth/collectEarthDatabase.dbSaiku;Catalog=C:/Users/JIC/AppData/Roaming/CollectEarth/projects/lao_lulucf/collectEarthCubes.xml;JdbcDrivers=org.sqlite.JDBC 08:39:40,251 WARN [RolapCube] RolapCube.createUsage: duplicate HierarchyUsage: kind=PRIVATE, hierarchyName=??????????, fullName=??????????, foreignKey=null, source=null, level=null, name=?????????? 08:39:40,253 WARN [RolapCube] RolapCube.createUsage: duplicate HierarchyUsage: kind=PRIVATE, hierarchyName=??????????, fullName=??????????, foreignKey=null, source=null, level=null, name=?????????? 08:39:40,255 WARN [RolapCube] RolapCube.createUsage: duplicate HierarchyUsage: kind=PRIVATE, hierarchyName=??????????, fullName=??????????, foreignKey=null, source=null, level=null, name=?????????? mondrian.olap.MondrianException: Mondrian Error:Hierarchy '????????????????' in cube 'Collect Earth Plot' must have a foreign key, since it is not based on the cube's fact table. at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:989) at mondrian.rolap.RolapCube.registerDimension(RolapCube.java:1770) at mondrian.rolap.RolapCube.(RolapCube.java:203) at mondrian.rolap.RolapCube.(RolapCube.java:227) at mondrian.rolap.RolapSchema.load(RolapSchema.java:594) at mondrian.rolap.RolapSchema.load(RolapSchema.java:422) at mondrian.rolap.RolapSchema.(RolapSchema.java:217) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:214) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:66) at mondrian.rolap.RolapConnection.(RolapConnection.java:160) at mondrian.rolap.RolapConnection.(RolapConnection.java:90) at mondrian.olap.DriverManager.getConnection(DriverManager.java:112) at mondrian.olap.DriverManager.getConnection(DriverManager.java:68) at mondrian.olap4j.MondrianOlap4jConnection.(MondrianOlap4jConnection.java:153) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:75) at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:46) at org.saiku.datasources.connection.SaikuConnectionFactory.getConnection(SaikuConnectionFactory.java:29) at org.saiku.web.impl.SecurityAwareConnectionManager.connect(SecurityAwareConnectionManager.java:284) at org.saiku.web.impl.SecurityAwareConnectionManager.getInternalConnection(SecurityAwareConnectionManager.java:99) at org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:110) at org.saiku.datasources.connection.AbstractConnectionManager.getAllConnections(AbstractConnectionManager.java:136) at org.saiku.datasources.connection.AbstractConnectionManager.getAllOlapConnections(AbstractConnectionManager.java:156) at org.saiku.olap.discover.OlapMetaExplorer.getAllConnections(OlapMetaExplorer.java:135) at org.saiku.service.olap.OlapDiscoverService.getAllConnections(OlapDiscoverService.java:57) at org.saiku.web.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) 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:288) 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:1469) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer.service(EnunciateJerseyServletContainer.java:250) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source)