org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0007 - file not found

Pentaho BI Platform Tracking | Jem Matzan | 6 years ago
  1. 0

    This is the /pentaho-solutions/olap/datasources.xml file provided with manual deployments: <?xml version="1.0" encoding="UTF-8"?> <DataSources> <DataSource> <DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName> <DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> <URL>http://localhost:8080/pentaho/Xmla?userid=joe&amp;password=password</URL> <DataSourceInfo>Provider=mondrian</DataSourceInfo> <ProviderName>PentahoXMLA</ProviderName> <ProviderType>MDP</ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> <Catalogs> <Catalog name="SteelWheels"> <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo> <Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definition> </Catalog> <Catalog name="SampleData"> <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo> <Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definition> </Catalog> </Catalogs> </DataSource> </DataSources> Because these resources do not exist in a clean pentaho-solutions directory, the following exception occurs on startup: 10:57:40,950 ERROR [MondrianCatalogHelper] MondrianCatalogHelper.ERROR_0013 - Failed to load schema solution:steel-wheels/analysis/steelwheels.mondrian.xml org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0007 - file not found at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.docAtUrlToString(MondrianCatalogHelper.java:699) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.loadCatalogsIntoCache(MondrianCatalogHelper.java:606) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.init(MondrianCatalogHelper.java:219) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.listCatalogs(MondrianCatalogHelper.java:400) at com.pentaho.analyzer.content.a.j.dl(SourceFile:55) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) (truncated)

    Pentaho BI Platform Tracking | 6 years ago | Jem Matzan
    org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0007 - file not found
  2. 0

    This is the /pentaho-solutions/olap/datasources.xml file provided with manual deployments: <?xml version="1.0" encoding="UTF-8"?> <DataSources> <DataSource> <DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName> <DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> <URL>http://localhost:8080/pentaho/Xmla?userid=joe&amp;password=password</URL> <DataSourceInfo>Provider=mondrian</DataSourceInfo> <ProviderName>PentahoXMLA</ProviderName> <ProviderType>MDP</ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> <Catalogs> <Catalog name="SteelWheels"> <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo> <Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definition> </Catalog> <Catalog name="SampleData"> <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo> <Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definition> </Catalog> </Catalogs> </DataSource> </DataSources> Because these resources do not exist in a clean pentaho-solutions directory, the following exception occurs on startup: 10:57:40,950 ERROR [MondrianCatalogHelper] MondrianCatalogHelper.ERROR_0013 - Failed to load schema solution:steel-wheels/analysis/steelwheels.mondrian.xml org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0007 - file not found at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.docAtUrlToString(MondrianCatalogHelper.java:699) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.loadCatalogsIntoCache(MondrianCatalogHelper.java:606) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.init(MondrianCatalogHelper.java:219) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.listCatalogs(MondrianCatalogHelper.java:400) at com.pentaho.analyzer.content.a.j.dl(SourceFile:55) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) (truncated)

    Pentaho BI Platform Tracking | 6 years ago | Jem Matzan
    org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0007 - file not found
  3. 0

    How to reproduce: 1) Start BI Server 2) Open Aggregation Designer 3) Open my simple aggregation design (attached) 4) Click File > Export and Publish 5) Click "Publish" 6) Enter valid server and credentials 7) Click OK, the "Connecting to repository" appears and then is replaced by the "Publish Schema" dialog 8) Set the schema location and publish settings 9) Click "Publish" 10) A pop-up says "Publish error: null" and the following NPE appears: java.lang.NullPointerException at org.pentaho.mondrian.publish.PublishToServerCommand.execute(PublishToServerCommand.java:350) at org.pentaho.aggdes.ui.form.controller.PublishController.publishSchema(PublishController.java:100) ... The NPE is caused by the publish method of PublishToServerCommand.java returning a null result, which probably means publication failed somehow. Indeed, at the same time, the following exception appears in the BI Server's log: org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0004 - already exists at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:449) at org.pentaho.platform.web.servlet.MondrianCatalogPublisher.doGet(MondrianCatalogPublisher.java:205) ... For step 8, I have no clear idea what the settings mean, so I might have set unexpected values: - Location: "/xyzbi", the directory where I usually store my schemas with Schema Workbench. - Pentaho or JNDI data source: "infobright", which is the only data source I created. I created it using the Administration Console. - Register XMLA datasource: Tried both checked and unchecked, same result.

    Pentaho BI Platform Tracking | 6 years ago | Nicolas Raoul
    org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0004 - already exists
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to reproduce: 1) Start BI Server 2) Open Aggregation Designer 3) Open my simple aggregation design (attached) 4) Click File > Export and Publish 5) Click "Publish" 6) Enter valid server and credentials 7) Click OK, the "Connecting to repository" appears and then is replaced by the "Publish Schema" dialog 8) Set the schema location and publish settings 9) Click "Publish" 10) A pop-up says "Publish error: null" and the following NPE appears: java.lang.NullPointerException at org.pentaho.mondrian.publish.PublishToServerCommand.execute(PublishToServerCommand.java:350) at org.pentaho.aggdes.ui.form.controller.PublishController.publishSchema(PublishController.java:100) ... The NPE is caused by the publish method of PublishToServerCommand.java returning a null result, which probably means publication failed somehow. Indeed, at the same time, the following exception appears in the BI Server's log: org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0004 - already exists at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:449) at org.pentaho.platform.web.servlet.MondrianCatalogPublisher.doGet(MondrianCatalogPublisher.java:205) ... For step 8, I have no clear idea what the settings mean, so I might have set unexpected values: - Location: "/xyzbi", the directory where I usually store my schemas with Schema Workbench. - Pentaho or JNDI data source: "infobright", which is the only data source I created. I created it using the Administration Console. - Register XMLA datasource: Tried both checked and unchecked, same result.

    Pentaho BI Platform Tracking | 6 years ago | Nicolas Raoul
    org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0004 - already exists

    Root Cause Analysis

    1. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException

      MondrianCatalogHelper.ERROR_0007 - file not found

      at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.docAtUrlToString()
    2. org.pentaho.platform
      MondrianCatalogHelper.listCatalogs
      1. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.docAtUrlToString(MondrianCatalogHelper.java:699)
      2. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.loadCatalogsIntoCache(MondrianCatalogHelper.java:606)
      3. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.init(MondrianCatalogHelper.java:219)
      4. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.listCatalogs(MondrianCatalogHelper.java:400)
      4 frames
    3. com.pentaho.analyzer
      AnalyzerContentGenerator.createContent
      1. com.pentaho.analyzer.content.a.j.dl(SourceFile:55)
      2. com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:134)
      2 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. com.pentaho.platform
      a.invoke
      1. com.pentaho.platform.web.http.context.a.invoke(SourceFile:220)
      1 frame
    6. Unknown
      $Proxy24.createContent
      1. $Proxy24.createContent(Unknown Source)
      1 frame
    7. org.pentaho.platform
      GenericServlet.doGet
      1. org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
      1 frame
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    9. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    10. org.pentaho.platform
      PentahoWebContextFilter.doFilter
      1. org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
      1 frame
    11. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    12. org.pentaho.platform
      PentahoRequestContextFilter.doFilter
      1. org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
      1 frame
    13. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    14. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    15. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    16. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    17. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    18. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    19. org.pentaho.platform
      SecurityStartupFilter.doFilter
      1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
      1 frame
    20. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    21. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    22. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    23. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
      1 frame
    24. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    25. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    26. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame