org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogServiceException: MondrianCatalogHelper.ERROR_0004 - already exists

Pentaho BI Platform Tracking | Nicolas Raoul | 6 years ago
  1. 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
  2. 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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

    Root Cause Analysis

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

      MondrianCatalogHelper.ERROR_0004 - already exists

      at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog()
    2. org.pentaho.platform
      MondrianCatalogPublisher.doGet
      1. org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:449)
      2. org.pentaho.platform.web.servlet.MondrianCatalogPublisher.doGet(MondrianCatalogPublisher.java:205)
      2 frames