Troubleshooting possible analytics issues

Use these fixes for common analytics issues in Pentaho Business Analytics.

In this topic

• Multi-byte characters do not appear in PDFs exported from Analyzer

• Geo Maps partially rendering

• Cannot change Administrator password in PUC

Multi-byte characters do not appear in PDFs exported from Analyzer

If you use a multi-byte character set, PDF export might fail. You might see missing or corrupted characters. Analyzer uses Helvetica for PDF export by default. Helvetica does not support multi-byte character sets.

When you view a report in Analyzer, the browser controls the fonts. When you export to PDF, Analyzer might not have those fonts available. The PDF output might not match the browser output.

To fix this issue, set a default TrueType font for PDF rendering.

1

Stop the server

Stop the Pentaho Server and the Pentaho User Console.

2

Edit analyzer.properties

Edit analyzer.properties:

/pentaho/server/pentaho-server/pentaho-solutions/system/analyzer/

3

Set the PDF font path

Uncomment renderer.pdf.font.path.

Example (Windows font collection):

renderer.pdf.font.path=C:/WINDOWS/Fonts/MSGOTHIC.TTC,1

4

Update the font value

Replace the value with your font file or font collection.

• For font collections, add ,1 after the file name.

• For individual fonts (.ttf), do not add ,1.

Example (Linux .ttf file):

renderer.pdf.font.path=/usr/share/fonts/truetype/freefont/FreeSans.ttf

5

Restart the server

Save the file. Start the Pentaho Server.

Geo Maps partially rendering

If Geo Map visualizations in Analyzer do not display correctly, the server might not be giving them enough time to render.

Pentaho Server waits a fixed amount of time before capturing the map image. This delay allows map tiles to download and points to plot. The default wait time is 1200 milliseconds.

You can change the delay in pentaho-solutions/system/pentaho-geo/settings.xml:

<map-export-javascript-delay>1200</map-export-javascript-delay>

The following steps show how to increase the cache size used by Geo Maps:

1. Locate pentaho-server/tomcat/webapps/pentaho/WEB-INF/classes and open ehcache.xml.

2. Find the cache element and increase maxElementsInMemory. For example:

   <cache
       name="pentaho-geo-{CUSTOM_ROLE_TYPE}"
       maxElementsInMemory="1000"
       eternal="false"
       overflowToDisk="true"
       timeToIdleSeconds="0"
       timeToLiveSeconds="0"
       diskPersistent="false"
       diskExpiryThreadIntervalSeconds="120"
     />

3. Save ehcache.xml.

4. Restart the Pentaho Server.

Cannot change Administrator password in PUC

When you add an administrator account in the Pentaho User Console (PUC), you have two administrator passwords:

• The default admin password.

• A password for the additional administrator account.

When you change the password for the additional administrator account, you might see an error. To fix this issue, enter the password for the currently logged-in administrator. Enter it in Administrator password.

Change PUC Password dialog box

See Administer Pentaho Data Integration and Analytics for additional troubleshooting information.