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
A bug in the code when dealing with mysql databases causes this error to be seen.
This will be resolved in a future release of CABI.
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;