Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Cant publish a report from Pentaho Report Designer

  1. #1
    Join Date
    May 2013
    Posts
    2

    Default Cant publish a report from Pentaho Report Designer

    Hello All,

    I was successfully able to create a report using pentaho report designer but not able to publish that report. When I try to publish the report by clicking File -> Publish I see a pop-up screen(attached) with fields URL, Timeout, User and Password. Mentioned below are the values supplied to those fields.

    URL: http://localhost:8080/pentaho
    Timeout: 30
    User: Joe
    Password: password

    After I click "OK" it try's to validate login info and nothing happens. I also checked publisher_config.xml file and it had "password" as the password.

    Anything needs to be done before publishing the report from report designer? Let me know if you need any more info to solve this issue.


    Name:  Pentaho_1.jpg
Views: 108
Size:  31.6 KB

  2. #2
    Join Date
    May 2013
    Posts
    2

    Default

    In the Pentaho Credentials you put the user and password of the datasource you have in Pentaho Admin Console that you are using to query the database. The password in publisher_config.xml is requested in the next window.

  3. #3
    Join Date
    May 2013
    Posts
    2

    Default

    Thanks Aldarius.

    Am now trying to create a datasource using "Create Datasource Wizard" in http://localhost:8080/pentaho/Home. I defined the datasource but getting an error "The call failed on server. See server log for details" while trying to save the datasource. When I checked the server log this is what I see. what do you think is the issue?

    2013-05-28 09:16:42,374 ERROR [org.pentaho.platform.plugin.services.metadata.MetadataDomainRepository] !MetadataPublisher.ERROR_0001_COULD_NOT_LOAD!
    java.lang.OutOfMemoryError: Java heap space
    2013-05-28 09:16:59,604 ERROR [org.pentaho.platform.plugin.services.metadata.MetadataDomainRepository] !MetadataPublisher.ERROR_0001_COULD_NOT_LOAD!
    java.lang.OutOfMemoryError: Java heap space
    2013-05-28 09:17:11,917 ERROR [org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet] Service method 'public org.pentaho.platform.dataaccess.datasource.wizard.sources.query.QueryDatasourceSummary org.pentaho.platform.dataaccess.datasource.wizard.service.impl.DatasourceServiceImpl.generateQueryDomain(java.lang.String,java.lang.String,org.pentaho.platform.dataaccess.datasource.IConnection,org.pentaho.platform.dataaccess.datasource.wizard.models.DatasourceDTO) throws org.pentaho.platform.dataaccess.datasource.wizard.service.DatasourceServiceException' threw an unexpected exception: java.lang.OutOfMemoryError: Java heap space
    com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public org.pentaho.platform.dataaccess.datasource.wizard.sources.query.QueryDatasourceSummary org.pentaho.platform.dataaccess.datasource.wizard.service.impl.DatasourceServiceImpl.generateQueryDomain(java.lang.String,java.lang.String,org.pentaho.platform.dataaccess.datasource.IConnection,org.pentaho.platform.dataaccess.datasource.wizard.models.DatasourceDTO) throws org.pentaho.platform.dataaccess.datasource.wizard.service.DatasourceServiceException' threw an unexpected exception: java.lang.OutOfMemoryError: Java heap space
    at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:378)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:581)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:544)
    at org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:131)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224)
    at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    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:102)
    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)
    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:134)
    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.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 com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72)
    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:113)
    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:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.OutOfMemoryError: Java heap space

    Quote Originally Posted by Aldarius View Post
    In the Pentaho Credentials you put the user and password of the datasource you have in Pentaho Admin Console that you are using to query the database. The password in publisher_config.xml is requested in the next window.

  4. #4
    Join Date
    Mar 2012
    Posts
    276

    Default

    Hi,

    java.lang.OutOfMemoryError: Java heap space ,Increase your BI server memory capacity in start-pentaho file under 'pentaho\server\biserver-ee' folder , Restart you BI server and Refresh PUC and try creating a new datasource .

    ex:- set CATALINA_OPTS=-Xms256m -Xmx2048m -XX:MaxPermSize=1024m


    Cheers,
    Surya

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.