Troubleshooting

Last updated
Save as PDF

Audience: Customers, partners, and consultants who are already familiar with the installation, configuration, and operation of the Pentaho software.

The best initial approach for troubleshooting components within the Pentaho Suite is logging to monitor operations within transformations, jobs, database connections, and the server. You can monitor transformations, jobs, and database connections through logging in PDI. For the Pentaho Server, the log file is pentaho.log, which is in the pentaho-server/logs folder. The contents of this file can help you track down why the server failed to start or work properly.

If you used a manual install, pentaho.log resides under pentaho-server/tomcat/logs. If you are using JBoss, the pentaho.log resides in the JBoss folder structure under pentaho-server/logs.

Besides analyzing logs, a number of Pentaho customers and partners have posted problems and solutions they have encountered in the past. The following common categories contain descriptions of these problems and how to resolve them:

Category	Topics
General Issues	JDBC Driver Issues Data Conversion Issues with MySQL Driver 5.0.8 Fixing JTDA varchar(MAX) Limitations in MSSQL 2005
Installation and Upgrade Issues	User Console Themes Render Improperly After Upgrade Pentaho Server Does Not Start When Installed on a Virtual Machine Context XML Changes Do Not Take Effect After Deploying a WAR No Search Manager Configured for the Java Repository Cannot Create Jackrabbit Tables in MySQL Unable to Use the Database Init Scripts for PostgreSQL JBoss Fails to Start Not Able to Login or Run Transformations
Security Issues	Increase Security Log Levels in the Pentaho Server Log Output Security Analysis LDAP Roles Issues with Admin and Authenticated With LDAP Authentication, the PDI Repository Explorer is Empty LDAP Incorrectly Authenticates User IDs That Do Not Match Letter Case
Pentaho Server Issues	Publishing Domain to the Pentaho Server Fails Library Conflicts Report Parameters That Include Accented Characters Fail to Validate VFS Provider XML Duplicates Tomcat Logs Report Memory Leaks Windows Domains Will Not Authenticate When Using the JTDS Drive Unable to Run XAction when using JavaScript Component
Data Integration Issues	Troubleshooting Transformation Steps and Job Entries Troubleshooting Database Connections Jobs Scheduled on Pentaho Server Cannot Execute Transformation on Remote Carte Server Cannot Run a Job in a Repository on a Carte Instance from another Job Troubleshoot Pentaho Data Service Issues Kitchen and Pan Cannot Read Files from a ZIP Export Using ODBC
Pentaho Repository Issues	Debugging a Corrupted Pentaho Server Repository Unable to Get List of Repositories
Big Data Issues	General Configuration Problems Cannot Access Cluster with Kerberos Enabled Cannot Access a Hive Cluster Cannot use Keytab File to Authenticate Access to PMR Cluster HBase Get Master Failed Error Sqoop Import into Hive Fails Pig Job Not Executing after Kerberos Authentication Fails Cannot Start Any Pentaho Components after Setting MapR as Active Hadoop Configuration Kettle Cluster on YARN Will Not Start Spark Issues
Analysis Issues	Multi-Byte Characters Do Not Appear in PDFs Exported from Analyzer Geo Maps Partially Rendering
Report Designer and Reporting Engine Issues	Report Elements With Dynamic Heights Overlap Other Elements Columns Unexpectedly Merge When Exporting to Excel
Metadata Issues	Managing Multiple Outer-Joins Slow Responses or Inconsistent Results in Reports Metadata-Based Reports Generated in Version 4.8 Produce Different Results in Version 5.x