Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: "Error serializing joins" when creating OLAP Data Source via Wizard

  1. #1
    Join Date
    Jul 2015
    Posts
    2

    Question "Error serializing joins" when creating OLAP Data Source via Wizard

    Hi,

    I've been trying to troubleshoot the following issue for a few days now so I thought I'd ask for help.
    I'm trying to create an OLAP data source based on a star schema via the wizard.
    I am able to connect to the database and go through the steps of selecting tables and defining joins.
    When I click finish, the server logs an Error (see stacktrace at end of post) and the web UI hangs.
    Please let me know what I'm doing wrong.

    Here are my specs [and alternatives I've tried]:
    Server: Ubuntu 14.04.2 LTS instance on AWS
    Pentaho version: biserver-ce-5.4.0.1-130 [biserver-ce-4.8.0]
    Java version: latest java-7-openjdk-amd64 [Oracle java version 1.8.0_45]
    Database: MySQL 5.6.23 on AWS [PostgreSQL 9.4.1 on AWS]
    JDBC Driver: mysql-connector-java-5.1.36 [mysql-connector-java-5.1.17 / mysql-connector-java-5.0.8 / mysql-connector-java-3.1.14 / postgresql-9.3-1102-jdbc4]

    Here's the log containing the dreaded "Error serializing joins":
    Code:
    2015-07-21 09:02:07,712 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/js/saiku/plugins/CCC_Chart/cdo.js not found in plugin saiku
    2015-07-21 09:02:08,146 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/js/saiku/plugins/Buckets/plugin.js not found in plugin saiku
    2015-07-21 09:02:10,082 ERROR [mondrian.util.ServiceDiscovery] Class class mondrian.spi.impl.NuoDbDialect cannot be assigned to interface interface mondrian.spi.Dialect
    2015-07-21 15:17:15,202 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_supported_languages.properties not found in plugin saiku
    2015-07-21 15:17:15,322 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties.properties not found in plugin saiku
    2015-07-21 15:17:15,442 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_en.properties not found in plugin saiku
    2015-07-21 15:17:15,565 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /saiku-ui/saikuplugin.properties_en_US.properties not found in plugin saiku
    2015-07-21 15:18:03,621 INFO  [org.pentaho.di] 2015/07/21 15:18:03 - TFD PostgreSQL EDW - Creating database connection pool for 'TFD PostgreSQL EDW'...
    2015-07-21 15:18:03,621 INFO  [org.pentaho.di] 2015/07/21 15:18:03 - TFD PostgreSQL EDW - Successfully created database connection pool for 'TFD PostgreSQL EDW'
    2015-07-21 15:18:48,409 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.MultitableDatasourceService] Error serializing joins
    org.pentaho.agilebi.modeler.ModelerException: Index: 24, Size: 24
        at org.pentaho.agilebi.modeler.util.MultiTableModelerSource.generateDomain(MultiTableModelerSource.java:193)
        at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.MultitableDatasourceService.serializeJoins(MultitableDatasourceService.java:148)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
        at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:545)
        at org.pentaho.platform.web.servlet.AbstractGwtRpcProxyServlet.processCall(AbstractGwtRpcProxyServlet.java:138)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
        at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:185)
        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:87)
        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.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:191)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
        at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
        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.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:133)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
        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.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
        at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
        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.SystemStatusFilter.doFilter(SystemStatusFilter.java:55)
        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.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
        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.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
        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.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
        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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.IndexOutOfBoundsException: Index: 24, Size: 24
        at java.util.ArrayList.rangeCheck(ArrayList.java:635)
        at java.util.ArrayList.get(ArrayList.java:411)
        at org.pentaho.agilebi.modeler.geo.GeoContext.determineLocationField(GeoContext.java:324)
        at org.pentaho.agilebi.modeler.geo.GeoContext.buildDimensions(GeoContext.java:178)
        at org.pentaho.agilebi.modeler.strategy.SimpleAutoModelStrategy.addGeoDimensions(SimpleAutoModelStrategy.java:219)
        at org.pentaho.agilebi.modeler.strategy.StarSchemaAutoModelStrategy.autoModelOlap(StarSchemaAutoModelStrategy.java:121)
        at org.pentaho.agilebi.modeler.BaseModelerWorkspaceHelper.autoModelFlat(BaseModelerWorkspaceHelper.java:434)
        at org.pentaho.agilebi.modeler.util.MultiTableModelerSource.generateDomain(MultiTableModelerSource.java:165)
        ... 79 more

  2. #2
    Join Date
    Jul 2015
    Posts
    2

    Default

    Successfully reproduced the exact same stacktrace on the default Amazon Linux AMI instead of Ubuntu:

    Server: Amazon Linux AMI on AWS
    Pentaho version: biserver-ce-5.4.0.1-130
    Java version: latest java-7-openjdk-amd64
    Database: PostgreSQL 9.4.1 on AWS
    JDBC Driver: postgresql-9.3-1102-jdbc4


    Also, it's worth noting that I can create a schema in the workbench and then upload it to the BI server.
    My issue is specifically with the creation of a data source via the Wizard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.