Troubleshooting Pentaho

The following content was extracted from the Support Manual compiled by Sungard Technology Services in December 2010:

1 How to install Pentaho and Pentaho Server?
2 How to set up Pentaho to run on different port (if Mifos is running on 8080)?
3 How to Start Pentaho Designer, Admin console and BI-server?
- 3.1 BI_SERVER
- 3.2 Admin console URL
- 3.3 Pentaho Designer
4 How to do user management in Pentaho?
5 How to deploy the design file on Pentaho server from designer?
6 How to schedule your reports?
7 How to remove connection pool exhausted error?
8 How to do JNDI settings in Pentaho?
9 How to turn off auto-submit button in Pentaho?
10 How to call stored procedure/kettle files in Pentaho designer?
11 Browser recommendations for Pentaho

How to install Pentaho and Pentaho Server?

(NOTE: for full detailed instructions on installing the Mifos Business Intelligence Suite containing Pentaho and the Data Warehouse at Installing Mifos BI (Pentaho))

There is no need to install Pentaho the designer and server. Just unzip the pentaho installer files and copy it in your root directory. On clicking the executable files both server and designer starts.

“biserver-ce” is the name of BI- server folder.

“report-designer” is the name of designer folder.

“administration-console” is the name of administrator folder for users and roles.

How to set up Pentaho to run on different port (if Mifos is running on 8080)?

Mifos will run on your default Tomcat on port 8080. To run Mifos and Mifos BI simultaneously, you will need to change which port Pentaho runs on. To do so you must change the port to 8086 via the web.xml and server.xml files. These tips were compiled by Ramya in this mailing list discussion.

These steps assume the Mifos war is installed in your default tomcat which runs on port 8080 - http://localhost:8080/mifos

http://localhost:8080/mifos1) Navigate to following location:

D:\PENTAHO_REPORTS\biserver-ce-3.6.0-stable\biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml

Edit the base-url section of your web.xml file. Change the port to 8086 from 8080


<context-param>
                                <param-name>base-url</param-name>

                                <param-value>http://localhost:8086/pentaho/</param-value>
</context-param>

2) Navigate to:

D:\PENTAHO_REPORTS\biserver-ce-3.6.0-stable\biserver-ce\tomcat\conf\server.xml

Edit the following two sections:

i) Change the shutdown port no to 8007 from 8005


<Server port="8007" shutdown="SHUTDOWN">

ii) Change the port from 8080 to 8086


<!-- Define a non-SSL HTTP/1.1 Connector on port 8080 -->

<Connector URIEncoding="UTF-8" port="8086" maxHttpHeaderSize="8192"

               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"

              enableLookups="false" redirectPort="8443" acceptCount="100"

               connectionTimeout="20000" disableUploadTimeout="true" />

With these three changes, both applications should run simultaneously with Mifos BI at http://localhost:8086/pentaho

How to Start Pentaho Designer, Admin console and BI-server?

BI_SERVER

Click the following

C:\Program Files\Pentaho\biserver-ce\start-pentaho.bat

Default URL to access is: http://<ip address of the server>:8089/pentaho

Default username/pwd is : joe/password

Admin console URL

For Admin console, you need to start the following batch file at specified location

C:\Program Files\Pentaho\administration-console\start-pac.bat

http://<ip address of server>:8099

The default username/pwd is admin/password

Pentaho Designer

C:\Program Files\Pentaho\report-designer\startdesigner.bat

How to do user management in Pentaho?

From admin console of Pentaho, you can create the users, roles and database connections for the server.

Open Admin console with admin user. Go to Adminitration tab.

Creating JNDI and JDBC connections on Pentaho server.

Setting maximum and minimum active connections on server. Go to Advanced tab for it.

Creation of roles

Creation of users

How to deploy the design file on Pentaho server from designer?

a) Open the designer by clicking the “startdesigner.bat” file.

b) Open the design file which you want to deploy and then click on publish button

c) The following screen will open .Enter the credentials and select the location on server to deploy the file.

Note: at the time of deployment, your server must be already started.

How to schedule your reports?

In the admin console, there is an option of scheduling the files or jobs also. You can use it and set the time of generation of the file automatically.

Go to scheduler tab

Click on create schedule and fill accordingly.

How to remove connection pool exhausted error?

Various ways to solve this problem