Troubleshooting your Configuration

Startup Problems

The most common problems are errors in the database configuration. These are typically errors in the database configuration files or in the application server configuration files. For information about resolving these errors, refer to the troubleshooting section Troubleshooting.

Error Running Report

If you have trouble running reports in your new JasperReports Server instance, refer to the troubleshooting section Error Running a Report. If you are having trouble running the MDX example Topic or SugarCRM OLAP view, you need to update the port for XML/A connections. See Updating XML/A Connection Definitions (Optional).

Filter Error Using MySQL

The following error could be caused by an incorrect ampersand setting on your data source configuration:

Error 500: Filter [characterEncodingProxyFilter]: could not be initialized

The data source line needs to have & and not & to be evaluated correctly. That is, the URL you enter in the procedure to define the JDBC data source and expose it through JNDI should look like this:

jdbc:mysql://localhost/jasperserver?useUnicode=true&characterEncoding=UTF-8

Error Creating Internationalized Name

If you encounter errors when creating resources with internationalized names and you have an Oracle database, configure your Oracle JDBC driver. Set the Oracle-specific option listed in the tables of Setting JVM Options.

Xerces Error

In earlier releases of JasperReports Server, it was possible to find the following error in the WebSphere log:

SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet:
jasperserver. Exception thrown: org.springframework.web.util.NestedServletException:
javax.xml.validation.SchemaFactoryFinder$ConfigurationError: Provider
org.apache.xerces.jaxp.validation.XMLSchemaFactory could not be instantiated:
org.apache.xerces.impl.dv.DVFactoryException: DTD factory class
org.apache.xerces.impl.dv.dtd.DTDDVFactoryImpl does not extend from DTDDVFactory.

More recently, the server uses version 2.10.0.

The error shown above is caused by a conflict between the IBM JDK used by WebSphere and the xercesImpl-2.6.2 library bundled with older versions of JasperReports Server. There are two solutions:

• Remove the xercesImpl library from the following location:

<websphere>\profiles\AppSrv<NN>\installedApps\<node>\jasperserver-pro_war.ear\

   jasperserver-pro.war\WEB-INF\lib

• Update the xercesImpl library to a new version (if it is an old version).

OLAP View Fails with Exception

The following error may occur because AspectJ needs class loaders to be tried out in a specific order:

java.lang.NoSuchMethodError: org/aspectj/runtime/reflect/Factory.makeMethodSig(

  java/lang/String;

  ...)

  org/aspectj/lang/reflect/MethodSignature;

Change the default class loader policy:

1. In the WebSphere Administrative Console, navigate to Applications > (app-name) > Manage Modules > JasperServer UI application.
2. Change the following setting:
Property Name Value

Class loader order

Class loaded with local class loader first (parent last)
3. Click OK.
4. Save the master configuration.
5. Restart the WebSphere server.