CABI JasperReports Server Installation Failed with DB_ALREADY_EXIST error

Products

• CA Spectrum

Issue/Introduction

After uninstalling CABI JasperReports Server the following error is seen when re-installing:

C:\Media\ca-jaspersoft-6.1.0\ca_install>.\install.bat -r sample.properties -l jasperinstall.log
Buildfile: C:\Media\ca-jaspersoft-6.1.0\ca_install\build.xml

preinstallcheck:
     [echo] Installation Component is:
     [java] Initializing the Pre-Install Validation LOG file in ValidateAppServer Java
     [java] Validation of Application server is completed Successfully
     [java] Initializing the Pre-Install Validation LOG file in ValidateDbServer Java
     [java] Preinstall check failed with following errors -
     [java] 16217: DB_ALREADY_EXISTS
     [java] 16218: SUGARCRMDB_ALREADY_EXISTS
     [java] 16219: FOODMARTDB_ALREADY_EXISTS
     [java] Java Result: 1

BUILD FAILED
C:\Media\ca-jaspersoft-6.1.0\ca_install\build.xml:117: Preinstall check failed

Environment

Release:
Component: SPCRPT

Cause

The install failed because jaspersoft, sugarcrm and foodmart databases exist.

Resolution

Drop the existing databases as the following

C:\Program Files\MySQL\MySQL Server 5.7\bin>.\mysql.exe -u<user> -p<password>
mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 125
Server version: 5.7.11-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| foodmart           |
| jaspersoft         |
| mysql              |
| performance_schema |
| sugarcrm           |
| sys                |
+--------------------+
7 rows in set (0.00 sec)

mysql> drop database jaspersoft;
Query OK, 88 rows affected (20.23 sec)

mysql> drop database sugarcrm;
Query OK, 80 rows affected (1.64 sec)

mysql> drop database foodmart;
Query OK, 37 rows affected (9.00 sec)

mysql> quit;
Bye

Then reinstall CABI JasperReports Server.