search cancel

CABI JasperReports Server Installation Failed with DB_ALREADY_EXIST error

book

Article ID: 42203

calendar_today

Updated On:

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

Cause

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

Environment

Release:
Component: SPCRPT

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.