Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Building and Debugging Pentaho 5.0

  1. #1
    Join Date
    Aug 2013
    Posts
    8

    Question Building and Debugging Pentaho 5.0

    Hi!

    I want to contribute to the Pentaho project and already started building from source-code. But I still having some trouble about deploying the basics of Pentaho BA. Here is the list of tasks successfully done:

    A) Install eclipse, get the code, compile and deploy. (Building and debuggin Pentaho 5.0 - http://wiki.pentaho.com/display/Serv...I+Platform+5.0) after solving this thread: http://forums.pentaho.com/showthread...PostgreSQL-9-2

    B) Check if it's all working.

    And I am stuck again, now in the item "B". When I create a new JPivot View, the system alert is "[pt_427] This page cannot be accessed directly. It must be linked to from other pages". Some users simply says that JPivot is not supported anymore, other say it's supported but users should use Pentaho Analyzer. And even are people saying that republishing the cube solves the problem.

    My question is:
    1- When I get the source-code from Github, does the "Pentaho Analyzer" is also deployed? If yes, how can I access the Pentaho Analyzer?
    2- Should I republish the sample cube? (I am using the sample-data before create the datasources in postgresql). How could I republish the cubes? I heard it's made by Mondrian Workbench, is that right? As in the item "A", is the workbench distributed by the pentaho-platform package from Github?

    Please help!

  2. #2
    Join Date
    Aug 2013
    Posts
    8

    Default

    My "pentaho.log" in "$CATALINA_HOME$\logs\pentaho.log" bring the following error:

    2013-10-25 13:26:45,431 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
    2013-10-25 13:26:45,434 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection: MDXConnection.ERROR_0002 - Invalid connection properties: DataSource=SampleData; PoolNeeded=false; EnableXmla=false; Provider=mondrian; Catalog=mondrian:/SampleData; Locale=pt_BR
    org.pentaho.platform.api.data.DBDatasourceServiceException: javax.naming.NameNotFoundException: Name SampleData is not bound in this Context
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getJndiDataSource(BaseDatasourceService.java:112)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.retrieve(PooledOrJndiDatasourceService.java:50)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.getDataSource(PooledOrJndiDatasourceService.java:106)
    at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:237)
    at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.init(MDXConnection.java:138)
    at org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection.setProperties(MDXConnection.java:99)
    at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:124)
    at org.pentaho.platform.plugin.action.mondrian.MondrianModelComponent.getInitialQuery(MondrianModelComponent.java:126)
    at org.pentaho.platform.plugin.action.mondrian.MondrianModelComponent.getInitialQuery(MondrianModelComponent.java:276)
    at org.pentaho.jpivot.PivotViewComponent.executeAction(PivotViewComponent.java:469)
    at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:465)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1313)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1278)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1182)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1132)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1015)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:918)
    at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352)
    at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282)
    at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:188)
    at org.pentaho.jpivot.AnalysisViewService.getNewAnalysisViewRuntime(AnalysisViewService.java:553)
    at org.pentaho.jpivot.Pivot_jsp._jspService(Pivot_jsp.java:472)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:88)
    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:169)
    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.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.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.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.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.Http11AprProcessor.process(Http11AprProcessor.java:879)
    at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1760)
    at java.lang.Thread.run(Thread.java:724)
    Caused by: javax.naming.NameNotFoundException: Name SampleData is not bound in this Context
    at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
    at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
    at javax.naming.InitialContext.lookup(InitialContext.java:411)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getJndiDataSource(BaseDatasourceService.java:72)
    ... 78 more

  3. #3
    Join Date
    Aug 2013
    Posts
    8

    Default

    I did rebuild the project with the "resolve" option and the pentaho.log doesn't shows no errors. But after configuring the Data Sources with this tutorial: <http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+PostgreSQL> but the button "Manage Data Sources" stopped working. Now the localhost*.log shows this errors when I click "Manage Data Sources" taking no action:

    Out 27, 2013 11:21:36 PM org.apache.catalina.core.StandardWrapperValve invoke
    SEVERE: Servlet.service() for servlet PluginDispatchServlet threw exception
    org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting children for folder with id "8ea60684-402c-4a8b-8e03-32605dedfc1f"

    Reference number: 3078fb08-d148-43c2-8394-1e6dea4f35dd

  4. #4

    Default

    I have the same problem. Manage Data Sources button stopped working when connecting to PostgreSQL. Any idea?

  5. #5
    Join Date
    Aug 2013
    Posts
    8

    Default

    Quote Originally Posted by SabrinaLoberia View Post
    I have the same problem. Manage Data Sources button stopped working when connecting to PostgreSQL. Any idea?
    Sorry, I dont have a workaround for this. I just forked another version of the project in github and builded all over again. Now it's working.

  6. #6

    Default

    Solution by Tiago. It works!!.

    It seems to be working now. Somehow, when changing the configuration files from HSLQDB to MySQL, something went broken with the samples, so the steps i did to resolve the issue were:



    • Change the configuration back to use HSQLDB;
    • Start the server;
    • On the user console delete all samples, and datasources associated with the samples;
    • Change the configuration again to use MySQL;

Tags for this Thread

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.