How to publish Pentaho Reports to BI server.


Problem Statement :

After developing (creating) a report from Pentaho Report Designer(PRD)  most us will be  curious to know , how the report looks from end user point of view. We need to publish this in Pentaho User Console(PUC)  for look and feel of reports. Most people will be finding it difficult to know,  where do we need publish this report to make it available for end user and what  will be the  publish password

Scope of this Article:

This topic helps to you know, where does the publish password is saved in system files and it also provide little of bit of exposure to configuration files in Pentaho business intelligence server

Technology:

  • Pentaho Report Designer ( any version )
  • Pentaho BI server  ( any version )

Details:-

  1. Find publish option under file menu tab.
  2. inpuc

  3. You can find a dialogue box for Repository login .
  4. Fully Qualified URL to be used http://localhost:8080/pentaho/ (If BI server is hosted in different machine , you need to specify its path Ex:- http://192.xxx.x.xxx:8080/pentaho )
  5. login by default  username: joe and password: password and select ok.
  6. inpuc

  7. Specify the filename of the report
  8. Browse location where you want to save the report
  9. Specify the output type
  10. inpuc

  11. Enter the publish password (You can know publish password in publisher_config.xml file located in biserver-ee\pentaho-solutions\system) and click ok.
  12. If the report is published successfully then you will see the following dialog box
  13. Report is published successfully

inpuc

Summary:

This article helps you to Publish PRPT reports to BIserver.

Walking Tree promotes Pentaho and we support the corporates as well as the developers to ensure that the business is able to take complete advantage of Pentaho’s wonderful capability. In case you are looking for a professional assistance then do visit our website to get in touch with us.

Reference:

BI developer

Tagged with: , ,
Posted in Data Warehouse & BI, Pentaho
10 comments on “How to publish Pentaho Reports to BI server.
  1. Dina says:

    I am having a problem while publishing a report from 5.01 which is on Windows 7 machine to bi-server 4.8 which is on Linux machine. Even if I have chosen the server version 4.8 in the version . I still have the
    error message
    “Unable to publish your file .Please try again or contact your system administrator for assistance.”
    Your help will be greatly appreciated.
    Thanks

  2. Albertus says:

    Good Day

    When i publish my report without parameters then report work on server to view, but when i create a report with parameters then my report does view on Report Designer, but only view a blank report on BI Server! Any idea what could be wrong?

  3. Mudasir Dar says:

    Hi Kumar,

    im devloping report in Report_Designer, which works fine on my local machine…but im trying to publish it on remote server (AWS),it does not get published. only the reports which dont contain(templates) any data source get sucessfully published.

    checking out the issue, i found it is an issue with datasource, how can i create or connect Remote Datasource in my local Report -designer.

    so that data will be available by the time of publishing reports.

    Thanks,
    Mudasir

  4. Kumar says:

    Hai Surya,

    I am using pentaho BA server 5.0 MDE ,I checked all of the things u have mentioned in the post even though am getting the same error .Actually am unable to find the log file of that error.please help me to resolve this issue.

    Thanks & Regards,

    Kumar.

    • suryathanuri says:

      Hi Kumar ,

      Please find log4j.xml file at below path
      “/biserver-ee/tomcat/webapps/pentaho/WEB-INF/classes”
      Increase log level to “debug” and try publishing .xmi file to server . please paste the debug log or attach the log file for that particular session .

      Thanks,
      http://www.walkingtree.in/.

  5. suryathanuri says:

    Hello Kumar ,

    We are assuming that you have properly filled the following options before publishing .xmi file to server .

    if not , lets have a detailed look at publish information , till BA server 4.8 :-
    Filename :- As by your requirement , should extend by .xmi
    Publish Location :- As by your requirement .
    Web Publish URL : http://localhost:8080/pentaho/RepositoryFilePublisher
    Please use respective domain name or IP address in place of localhost . If your BI server is not defaulted to 8080 , please mention your specific port .
    Publish password :- your admin console password
    Server Userid :- username of your BI server (http://localhost:8080/pentaho)
    Server Password :- Password of your BI server (http://localhost:8080/pentaho)

    If you are using pentaho BA server 5.0 MDE :-
    Web Publish URL : http://localhost:8080/pentaho/RepositoryFilePublisher
    Please use respective domain name or IP address in place of localhost . If your BI server is not defaulted to 8080 , please mention your specific port .
    Server Userid :- username of your BI server (http://localhost:8080/pentaho)
    Server Password :- Password of your BI server (http://localhost:8080/pentaho)
    Domain Name :- Domain name of the file .

    To support you better , please attach your error log file .

    Thanks,
    http://www.walkingtree.in/.

  6. Kumar says:

    Hello Surya,
    Am unable to Publish Metadata Editor Domain to Pentaho server .I already published the reports which are designed by Report Designer successfully with out any error .But for Metadata Editor am getting this following error .

    “Unable to publish your file .Please try again or contact system administrator for assistance.”

    Could you please help to resolve this error.

    Thanks & Regards,

    Kumar.

  7. suryathanuri says:

    Hi santosh ,

    Are you trying to publish on server at local machine or Remote machine.
    If remote machine , make sure that your pentaho server is up at Remote machine.

  8. santosh says:

    Hello Surya,

    When i am trying to publish a report i am getting the following error:

    “Login to the server failed could not connect to the server on the localhost’ ”

    and the error log is:

    org.apache.commons.vfs.FileSystemException: Could not connect to HTTP server on “localhost”.
    at org.apache.commons.vfs.provider.http.HttpClientFactory.createConnection(HttpClientFactory.java:105)
    at org.pentaho.reporting.libraries.pensol.vfs.WebSolutionFileProvider.doCreateFileSystem(WebSolutionFileProvider.java:71)
    at org.apache.commons.vfs.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
    at org.apache.commons.vfs.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:62)
    at org.apache.commons.vfs.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:641)
    at org.apache.commons.vfs.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:582)
    at org.pentaho.reporting.designer.extensions.pentaho.repository.util.PublishUtil.createVFSConnection(PublishUtil.java:299)
    at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.ValidateLoginTask.validateLoginData(ValidateLoginTask.java:71)
    at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.ValidateLoginTask.run(ValidateLoginTask.java:46)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(Unknown Source)
    at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.(Unknown Source)
    at java.net.Socket.(Unknown Source)
    at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:79)
    at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:121)
    at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
    at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1321)
    at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
    at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
    at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
    at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
    at org.apache.commons.vfs.provider.http.HttpClientFactory.createConnection(HttpClientFactory.java:101)
    … 9 more

    Please do help in resolving this.

    Regards,
    Santosh Bhagavatula

  9. santosh says:

    Hello Surya,

    I am trying to publish the report to the server i am getting the following error

    “Login to the server failed. Coulg not connect to the HTTP server on ‘localhost’ ”

    can u please help me resolve this issue.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out https://walkingtree.tech/index.php/blog for all latest blogs.

Sencha Select Partner Sencha Training Partner
Xamarin Authorized Partner
Recent Publication
%d bloggers like this: