Database installation errors when upgrading Jasper to 6.4.3

Products

• CA Spectrum

Issue/Introduction

When trying to upgrade JasperSoft to 6.4.3 errors are seen when trying to log into existing MySQL database.
Error seen: Database is not valid

Environment

Jasper 6.4.2
MySQL Database

Cause

A bug in the code when dealing with mysql databases causes this error to be seen.

Resolution

This will be resolved in a future release of CABI.

Additional Information

Workaround:

Before starting the upgrade installer, execute the below query in the mysql database:

ALTER TABLE jasperserver.JIResourceFolder RENAME jasperserver.JIRESOURCEFOLDER; 

Before the install is executed (where the install actually runs) , however, the following query must be run:

ALTER TABLE jasperserver.JIRESOURCEFOLDER RENAME jasperserver.JIResourceFolder;