How can I change the "Existing username" to root for (Spectrum) JasperSoft upgrade?

Products

• CA eHealth
• CA Spectrum

Issue/Introduction

I am trying to upgrade from JasperSoft 6.3 to 6.4.3.

The passwords and users are valid, but the update fails on the screen: "Existing Database Details"
With the error "Database not valid"

My questions:
 How can I change the "Existing username" to root?

 

Environment

OS: CentOS Linux release 7.6.1810 (Core), 
Coupled to Spectrum 10.3.2 (running on Linux or Windows)

JasperSoft 6.3.0,

Resolution

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

ALTER TABLE jasperserver.JIResourceFolder RENAME jasperserver.JIRESOURCEFOLDER;