General issues
Follow the suggestions in these topics to help resolve common software issues associated with the Pentaho suite:
- JDBC driver issues
- Data conversion issues with MySQL driver 5.0.8
- Fixing JTDS varchar(Max) limitations in MSSQL 2005
- Snowflake timeout errors
- Log table data is deleted
See Pentaho Troubleshooting articles for additional topics.
JDBC driver issues
Before you begin
Perform the following steps to install the appropriate driver for your Pentaho Server:
Procedure
Stop the Pentaho Server.
Copy your driver into this location: <pentaho-install-directory>/server/pentaho-server/tomcat/lib.
Start the Pentaho Server.
Data conversion issues with MySQL driver 5.0.8
To solve this problem, you must replace the mysql-connector-java-5.0.8.jar with the mysql-connector-java-5.0.7.jar in your client tool or application server's lib folder
Fixing JTDS varchar(Max) limitations in MSSQL 2005
The solution is to upgrade the MSSQL 2005 JDBC driver to version 1.0.809.102 or later. Download and install the http://msdn.microsoft.com/en-us/sqlserver/aa937724 file from Microsoft.com, then restart your MSSQL server.
Snowflake timeout errors
When you are pooling the Pentaho database connection, you may see errors. Snowflake JDBC connections use a default timeout of four hours which contributes to these errors because the same connection can be reused for more than four hours. See the Snowflake documentation for further details.
To resolve this issue, do one of the following actions:
Using a validation query
Perform the following steps to use a validation query:
Procedure
Open the Database Connection dialog box, then access the Pooling tab.
Move down in the Parameters table and select the check box to the left of the validationQuery parameter.
Set the parameter value to select 1.
Next steps
Disabling the Snowflake timeout
Perform the following steps to disable the timeout:
Procedure
Open the Database Connection dialog box, then access the Options tab.
Enter in the CLIENT_SESSION_KEEP_ALIVE parameter and set its value to true.
Next steps
Log table data is deleted
When you run a job or transformation, data in the log table is unexpectedly deleted.
When a job or transformation runs, the value in the Log line timeout (days) field determines when to delete the data in the log table, which is selected in the Log table field. In PDI, both fields are located in the job or transformation Properties page.When more than one job or transformation is run using the same table, the data in the log table is deleted according to the shorter timeout value in either of the settings. For example, if you run two jobs with a timeout setting of 20 days in one job and 10 days in the other job, the log table data is deleted in 10 days.
There are two ways to solve this problem:
- As a best practice, use a different log table for each job or transformation.
- Optionally, set the Log line timeout (days) field to the same value in your jobs and transformations.