Oracle Error on Upgrade when PL/SQL Not Enabled
If you're upgrading to JasperReports Server version 6.1 or later using the js-upgrade-samedb.sh/bat script, you may encounter an error if Oracle's Procedural Language (PL/SQL) is not enabled.
The upgrade script for upgrading to a 4.7 database from a 4.5 database requires enabling the PL/SQL language. The script is located here:
buildomatic/install_resources/sql/oracle/upgrade-oracle-4.5.0-4.7.0-pro.plsql
The error you encounter might look something like this:
[advanced-sql] PLS-00103: Encountered the symbol “end-of-file”
To enable your PL/SQL language, consult the documentation for your Oracle database to enable PL/SQL.
DB2 Script Error on Upgrade
If you're upgrading from 4.7 to 6.1, and you use the js-upgrade-samedb.bat/sh script, you may get an error related to an inadequate PAGESIZE setting. The recommended minimal PAGESIZE setting for both 4.7 and 5.0 is 16384. If the PAGESIZE setting is less than this you may get an error like this:
com.ibm.db2.jcc.am.SqlException:
DB2 SQL Error: SQLCODE=-670,SQLSTATE=54010, SQLERRMC=4005;
or
com.ibm.db2.jcc.am.SqlSyntaxErrorException:
DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;DB2ADMIN,
DRIVER=4.11.77
If you get this error, recreate your 4.5 database using a command like the following:
CREATE DATABASE JSPRSRVR USING CODESET UTF-8 TERRITORY US PAGESIZE 16384
This may require reloading your database from your database backup and rerunning the upgrade procedure after PAGESIZE has been changed.
Include Audit Events on Upgrade
If you have auditing enabled and you run upgrade using js-upgrade-newdb.bat/sh, audit events are not imported by default. To import audit events, you need to run an additional command after the js-upgrade-newdb script completes. To do this, change to the buildomatic directory:
cd <js-install>/buildomatic
Then run one of the following commands:
js-import.bat --input-zip=js-my-export-all.zip --include-audit-events (Windows)
js-import.sh --input-zip=js-my-export-all.zip --include-audit-events (Linux)
or
ant import -DimportFile=js-my-export-all.zip -DimportArgs="--include-audit-events"
These commands reimport all resources from the specified export file, add the audit event, and do not overwrite existing resources.
When using either import utility, the server must be stopped to avoid issues with caches, configuration, and security. |
Overlay Upgrade Permissions Error with Bundled Installation
If you're using the overlay upgrade procedure with a PostgreSQL database, and you installed an earlier version of JasperReports Server, you might see an HTTP Status 404 error. The jasperserver-pro.log file will show something like this:
ERROR ContextLoader,Thread-1:307 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proMaintenanceSchedulerTriggers' defined in ServletContext resource [/WEB-INF/applicationContext-audit.xml]: Cannot resolve reference to bean 'heartbeatTrigger' while setting constructor argument with key [1];
This occurs because in the default master properties file we have the user postgres and in context.xml we have the user jasperdb.
If this happens, follow this procedure:
1. | Back up your existing master properties. |
2. | Change the DB user in the master properties to jasperdb. |
3. | Run the overlay upgrade. |
Overlay Upgrade Domain Issue with MySQL and MariaDB JDBC Driver
When working with Domains using the MySQL database — and using the 1.1.2 version of the MariaDB JDBC driver (mariadb-java-client-1.1.2.jar) — there can be an issue handling boolean values correctly. The fix is to upgrade to a higher version of the MariaDB JDBC driver such as 1.1.6.
Because JasperReports Server 5.5, 5.6, 6.0, 6.1 and the Overlay packages are distributed with the MariaDB 1.1.2 JDBC driver, this error can also occur even without an upgrade operation.
The issue may occur when a boolean filter is created on a domain. Because of a bug in older versions of the MariaDB driver, the boolean filter is evaluated as a numeric filter.
Recommended Comments
There are no comments to display.