PDA

View Full Version : Building and Debugging Pentaho 5.0



jjunqueira
10-25-2013, 12:02 AM
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/ServerDoc2x/BI+Platform+5.0) after solving this thread: http://forums.pentaho.com/showthread.php?150483-BI-Platform-5-0-and-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!

jjunqueira
10-25-2013, 11:33 AM
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

jjunqueira
10-28-2013, 09:51 AM
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

SabrinaLoberia
12-09-2013, 10:27 AM
I have the same problem. Manage Data Sources button stopped working when connecting to PostgreSQL. Any idea?

jjunqueira
12-09-2013, 01:39 PM
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.

SabrinaLoberia
01-20-2014, 11:44 AM
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;