Skip to main content
Version Pentaho
Hitachi Vantara Lumada and Pentaho Documentation

Correct DI Repository Problems

  1. Last updated
  2. Save as PDF

Overview

Explains how to recognize and correct DI Respository issues.

Common DI Repository problems and solutions appear in the following sections.

Cannot Create Jackrabbit Tables in MySQL

The Pentaho solution repository uses long text strings that require a longer maximum character limit than the default UTF-8 configuration allows. Therefore, if your MySQL character set is configured to use UTF-8, you must change it to ASCII instead in order to use it as a Pentaho solution database. Using UTF-8 will prevent the MySQL initialization scripts from running during installation.

Troubleshooting a Corrupted DI Server Repository

If the DI Repository becomes corrupt, it will be unresponsive, content may be missing or inaccessible, and an error message similar to this will appear in the /data-integration-server/tomcat/logs/catalina.out log file:

ERROR [ConnectionRecoveryManager] could not execute statement, reason: File corrupted while reading record: "page[48970] data leaf table:8 entries:1 parent:49157 keys:[118547] offsets:[737]". Possible solution: use the recovery tool [90030-131], state/code: 90030/90030

If this happens, shut down the DI Server and restore your solution repository from a recent backup.

If you do not have a viable backup, you may be able to minimize data loss by identifying the exact file that is corrupt. To do this, enable debug logging by adding the following XML snippet above the <root> element in the /WEB-INF/classes/log4j.xml inside your deployed pentaho.war:

<category name="org.pentaho.platform">
     <priority value="DEBUG"/>
</category>

Restart the DI Server and retry the action that caused the original error. If it occurs again, shut down the DI Server and open thecatalina.out log file in Tomcat. Look for the last line that appears before the error; it usually contains the name of the file that has been damaged. When you are finished investigating the data corruption, remove the extra logging capabilities so that your DI Server log files don't become large and unmanageable.

reading file with id 'xyz' and path '/public/a.txt'

Unable to Use the Database Init Scripts for PostgreSQL

The pg_hba.conf file contains host-based authentication information. If you can't run the SQL scripts that generate the Jackrabbit and Quartz databases, it's probably because the default user accounts for each database don't have the right permissions. To change this, edit the file to ensure that connections from local users created by the Pentaho sql scripts (such as pentaho_user) will be able to connect. The default on Debian-based systems is for local connections you use ident authentication, which means that database users must have local user accounts. In other words, to continue using ident, you would have to create a local pentaho_user account. It's easier to just change the authentication method to something less restrictive, if your IT manager allows that approach.