Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Pentaho upgrade

Parent article

This guide describes how to upgrade the Pentaho Server from the archive installation of Pentaho version 7.x or 8.x to Pentaho 8.3. This upgrade documentation assumes that you are upgrading to 8.3 on the same server as your current archive installation.

If you are currently using Pentaho 7.x or 8.x that was previously upgraded to the DI Server only, use the Upgrade from 7.x or 8.x DI Server to 8.3 upgrade instructions.

Get started with the 8.3 upgrade

To perform this upgrade process, you need to know how to access the Pentaho Server as an Administrator from a command line.

Before you begin

You must also perform the following prerequisites:

Procedure

  1. Verify your current version of the Pentaho Suite. Start with a working installation of Pentaho Server 7.x or 8.x.

  2. Verify that your system components are current. Ensure that your system components, such as web browsers or repository databases, are up-to-date for Pentaho.

  3. Create backups of all the following Pentaho databases:

    • hibernate
    • quartz
    • jackrabbit
  4. For Linux installations only, verify Info-ZIP has been installed and configured.

    If needed, you can download, install, and configure Info-ZIP open source compression utility using the Info-ZIP documentation. Info-ZIP is available at http://www.info‐zip.org/. A BSD-style license is provided and used for most Linux and Unix variants. A Windows version of Info-ZIP is pre-configured and included in the Pentaho update package.
  5. Verify that no users are logged on to the server.

    The upgrade process should be performed during off-business hours to minimize impact to your day-to-day operations.

Next steps

Get the Pentaho upgrade and utility files

The upgrade process involves utility and installation files that you must download from the Pentaho Customer Support Portal.

Download the upgrade and utility files

Perform the following steps to download these files:

Procedure

  1. On the Customer Portal home page, sign in using the Pentaho support user name and password provided in your Pentaho Welcome Packet.

  2. Click Downloads, then click Pentaho 8.3 GA Release in the 8.x list.

  3. On the bottom of the Pentaho 8.3 GA Release page, browse the folders in the Box widget to find the files you need, including the pentaho-upgrade-utility-8.3.x.yy-pentaho file in the Utilities and Tools folder.

Available update files

The following files are required to perform a complete Pentaho 8.3 update:
ComponentFile Name
Pentaho Server Upgrade Utilitypentaho-upgrade-utility-8.3.x.yy-pentaho
Pentaho Server Installationpentaho-server-ee-8.3.x.yy-dist
PDI clientpdi-ee-client-8.3.x.yy-dist
Pentaho Analyzerpaz-plugin-ee-8.3.x.yy-dist
Pentaho Dashboard Designerpdd-plugin-ee-8.3.x.yy-dist
Pentaho Interactive Reportspir-plugin-ee-8.3.x.yy-dist
Report Designerprd-ee-8.3.x.yy-dist
Metadata Editorpme-ee-8.3.x.yy-dist
Schema Workbenchpsw-ee-8.3.x.yy-dist
Aggregation Designerpad-ee-8.3.x.yy-dist
License FilesPentaho [component] Enterprise Edition.lic

Unzip the downloaded files

Perform the following steps to unzip the downloaded files:

Procedure

  1. If needed, move the downloaded files to a temporary location on your current server.

  2. Unzip each downloaded file.

Next steps

You are now prepared to begin your 7.x or 8.x to 8.3 upgrade.

Upgrade the Pentaho Server

The following steps will guide you through the version 8.3 Pentaho Server upgrade process:

  1. Back up your Pentaho Server configuration and solutions files
  2. Install the version 8.3 Pentaho Server and plugins
  3. Restore your server configuration and solutions files
  4. Consider previous version upgrades and customizations
  5. Start and test the Pentaho Server

This process assumes you have completed an archive installation of the version 7.x or 8.x Pentaho Server and are upgrading to version 8.3.

Step 1: Back up your Pentaho Server configuration and solutions files

The backup utility copies your Pentaho configuration and solutions files, then stores the created ZIP files in your user's home directory.

Complete the following steps to back up your configuration and solutions files:

Procedure

  1. Stop the Pentaho Server.

  2. Open a command line terminal and navigate to the unzipped directory of the pentaho-upgrade-utility-8.3.x.yy-pentaho upgrade utility.

  3. At the prompt, run the correct PentahoServerConfigAndSolutionsBackup utility for your operating system as shown below:

    • Windows: PentahoServerConfigAndSolutionsBackup.bat <path to your 7.x or 8.x pentaho server>
      NoteIf you are using Windows and the directory path you specified contains white spaces, then be sure to wrap it in double quotation marks ().
    • Linux: ./PentahoServerConfigAndSolutionsBackup.sh <path to your 7.x or 8.x pentaho server>

    The backup utility has the following optional parameters:

    • pentaho_solutions_folder

      Specifies the path to the pentaho-solutions directory if you manually installed it outside of the main pentaho directory structure.

    • pentaho_version

      Specifies your Pentaho Server version if a valid version cannot be automatically found during the backup process.

Next steps

When the backup utility finishes, you can install a new instance of the Pentaho 8.3 software.

Step 2: Install the 8.3 Pentaho Server and plugins

After completing Step 1, you are ready to install the 8.3 Pentaho Server and related plugins.

Make sure to install the new instance of Pentaho on the same server, but leave your Pentaho 7.x or 8.x instance "as is" while unpacking Pentaho 8.3 into a new directory.

Pentaho Server installation

Perform the following steps to install version 8.3 of the Pentaho Server:

Procedure

  1. Verify Java 8 is installed on the server machine.

    If you need to install Java 8, you can download a supported version of JRE or JDK.
  2. Verify the PENTAHO_JAVA_HOME environment variable is set to the path of your Java installation.

    • If you need to set this variable, use the SET command in Windows or the export command in Linux.
    • If you are using a JRE, verify the JRE_HOME environment variable is also set to the correct location.
  3. Browse to the location where you unzipped the pentaho-server-ee-8.3.x.yy-dist file in the Available Update Files section.

  4. Execute the supplied install.bat or install.sh file.

  5. Agree to the end-user license agreement.

  6. Select the pentaho/server/pentaho-server directory as the location to store the extracted files.

Plugin installation

The following -dist files listed in the Available Update Files section apply to the Analyzer, Interactive Reports, and Dashboard Designer plugins:
  • paz-plugin-ee-8.3.x.yy-dist
  • pir-plugin-ee-8.3.x.yy-dist
  • pdd-plugin-ee-8.3.x.yy-dist

If you use any of these plugins, browse to the location where you unzipped these distributions and perform the following steps for each file:

Procedure

  1. Execute the supplied install.bat or install.sh file.

  2. Agree to the end-user license agreement.

  3. Select the pentaho/server/pentaho-server/pentaho-solutions/system directory as the location to store the extracted files.

Step 3: Restore your server configuration and solutions files

After you have unpacked your Pentaho 8.3 bundle, restore your Pentaho files to your 8.3 instance with the restore utility.

Perform the following steps to apply the PentahoServerConfigAndSolutionsRestore utility:

Procedure

  1. Delete the content in the version 8.3 Pentaho Server pentaho-solutions/system/default-content directory.

  2. Open a command line terminal and navigate to the unzipped directory of the pentaho-upgrade-utility-8.3.x.yy-pentaho.

  3. In the prompt, run the PentahoServerConfigAndSolutionsRestore utility to restore your data from the ZIP files located in your user home directory as shown below:

    • Windows: PentahoServerConfigAndSolutionsRestore.bat <path to 8.3 pentaho server>
      NoteIf you are using Windows and the directory path you specified contains white spaces, then be sure to wrap it in double quotation marks ().
    • Linux: ./PentahoServerConfigAndSolutionsRestore.sh <path to 8.3 pentaho server>
    If the directory path you specify is not within the main directory structure, use an optional pentaho_solutions_folder parameter to specify its location.

Step 4: Review previous version upgrades and customizations

This section includes version specific and configuration changes that should be reviewed.

ImportantIf upgrading from version 7.0, follow the tasks in the "Step Four: Review previous version upgrades and customizations" article in the Pentaho 8.1 upgrade documentation. These additional steps may include updates for plugins, spring-security property files, and database connection pool information.

Verify spring security namespace header updates

If you performed the upgrade process using tools other than those supplied in the installation kit, ensure the spring-security namespace headers are updated in the user-configurable Pentaho Server files.

Perform the following steps to verify the spring-security namespace headers:

Procedure

  1. Stop the Pentaho Server.

  2. Open the following three files:

    1. /pentaho-server/pentaho-solutions/system/applicationContext-spring-security.xml

    2. /pentaho-server/pentaho-solutions/system/applicationContext-spring-security-cas.xml

    3. /pentaho-server/pentaho-solutions/system/repository.spring.xml

  3. Locate the spring-security namespace in each file header. If it is not already updated, enter the following version:

    http://www.springframework.org/schema/security/spring-security-4.2.xsd
  4. Save and close the files.

Results

The spring-security namespace headers are updated.

Karaf customizations

The Pentaho Server installs all the Karaf features upon installation. The system waits for these features to be installed before timing out. The default is to wait two minutes before timing out. If you modified any Karaf feature, you should consider changing the Karaf startup timeout setting.

Password encoding

Pentaho 8.0 changed the password encoding from previous versions.
NoteThis update is not necessary if:
  • You are upgrading from version 8.1 to 8.3.
  • You are using your own password encoding or you previously applied this version of encoding

If you wish to use this version of password encoding, perform the following steps:

Procedure

  1. Navigate to the pentaho/server/pentaho-server/pentaho-solutions/system directory and open the pentahoObjects.spring.xml file with any text editor.

  2. Locate the line that contains bean id="IPasswordService".

  3. Verify or modify the class=<value> with the following value:

    bean id="IPasswordService" class="org.pentaho.platform.util.KettlePasswordService" scope="singleton"/>
  4. Save and close the file.

  5. If you modified the class=<value> above, you must make the following modification to encrypt the Pentaho Admin password. In the same pentaho/server/pentaho-server/pentaho-solutions/system directory, open the defaultUser.spring.properties file with any text editor.

  6. Locate the following lines:

    defaultAdminUserPassword=cGFzc3dvcmQ= defaultNonAdminUserPassword=cGFzc3dvcmQ=
  7. Replace the values in these lines with the following values:

    defaultAdminUserPassword=Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde defaultNonAdminUserPassword=Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde
  8. Save and close the file.

Documentation version link

The default URL of the online Pentaho documentation changes with each release. When upgrading, this URL parameter may need to be updated in the pentaho.xml file.

Procedure

  1. Navigate to the pentaho/server/pentaho-server/pentaho-solutions/system directory and open the pentaho.xml file with any text editor.

  2. Modify the following <documentation-url> line and replace the previous documentation value with the current documentation value:

    <documentation-url>https://help.pentaho.com/Documentation/8.3/Products/User_Console</documentation-url>
  3. Save and close the file.

CORS (for embedding CTools)

If your Pentaho deployment requires the ability to embed CTools, you can modify the following settings.

Procedure

  1. Navigate to the pentaho/server/pentaho-server/pentaho-solutions/system directory and open the pentaho.xml file with any text editor.

  2. Modify or add the following CORS lines:

    <!--
    cors-requests-allowed:
    Flag indicating if cross-origin requests are allowed or not.
    accepted values are: true | false
    -->
    
    
    <cors-requests-allowed>false</cors-requests-allowed>
    
    
    <!--
    cors-requests-allowed-domains:
    Comma separated list of domains allowed to do cross-origin requests to the server.
    Example:
    http://domainA.com, http://localhost:1337
    -->
    
    
    <cors-requests-allowed-domains><!-- allowed domains here --></cors-requests-allowed-domains>
  3. If you are embedding CTools, add the following line (as shown above) and set the value to true.

    <cors-requests-allowed>true</cors-requests-allowed>
  4. Save and close the file.

Previously customized files

If you have previously customized any of the following items, verify that your customizations have been carried forward:

  • server.xml
  • startup and shutdown scripts
  • system listeners
  • security configuration files

If your previous customizations have not been merged, incorporate them into their 8.3 files.

Step 5: Start and test the Pentaho Server

You are now ready to Start your 8.3 Pentaho Server.

CautionDo not pause or stop the initial starting of the server.

Test your server

You can use the following actions to ensure your content has been restored to the 8.3 Pentaho Server:

Procedure

  1. Clear your web browser cache and history.

  2. Navigate to your Pentaho URL (the default URL is http://localhost:8080/pentaho) and ensure the login screen appears.

  3. Log on to PUC and try to run your existing content.

  4. Verify your schedules exist and are working properly.

  5. Ensure your Pentaho plugins are installed and functional by performing the following tasks:

    • Open a report that requires no user prompts or parameters.
    • Create a test report for Interactive Reports and a test report for Analyzer.
    • Open a dashboard in Dashboard Designer.
  6. Examine the application server logs for any errors:

    • Check your Catalina and Pentaho logs in the server/pentaho-server/tomcat/logs directory.
  7. Log on and try to access the kettle/status page.

Next steps

For troubleshooting issues, refer to the Installation and Upgrade Issues article.

Update your design tools

After completing the server upgrade to 8.3, perform the following steps to upgrade your Pentaho design tools on your workstations.

Procedure

  1. Exit any of the design tools, if any are currently running.

  2. Back up and rename all the 7.x or 8.x existing directories in a separate, temporary directory.

  3. Browse to the location where you downloaded the following -dist files in the Available Update Files section:

    • pdi-ee-client-8.3.x.yy-dist
    • prd-ee-8.3.x.yy-dist
    • pme-ee-8.3.x.yy-dist
    • psw-ee-8.3.x.yy-dist
    • pad-ee-8.3.x.yy-dist
  4. If you have not already done so, unzip all the new design tools directories and install them into a pentaho/design-tools directory.

  5. Start your new design tools to verify they were upgraded to 8.3.

  6. Test the functionality of the design tools.

Results

You have now completed your Pentaho upgrade from 7.x or 8.x to 8.3.

For customers using Analyzer

Analyzer can be upgraded from Visualization API 2.0 to Visualization API 3.0. Before upgrading, please review the following information for more details: Analyzer and the Visualization API.

For customers using Ops Mart

If you installed an Ops Mart as part of the previous Pentaho 7.x or 8.x upgrade, you do not have to reinstall it.

If you are interested in installing and using DI Ops Mart, see Install DI Ops Mart.

NoteIn Pentaho 8.3, the maximum number of characters in an audit table field can be increased to allow you to store more information, as described here.