UIM installation fails during database creation (Linux with MySQL)

Document ID : KB000004985
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

UIM installation failed during a fresh installation (Linux/MySQL)

Environment:
- UIM v8.47- Linux- MySQL database
Cause:

mySQL database installation issue

During UIM installation the database could not be created. Installation failed.

The dba created the database as CA_UIM before the on-site installation took place. The DBA created the database using all uppercase letters.

Since mySQL doesn't allow 2 databases of the same name even if the case is different, installation was failing because during the install the customer was specifying the database name in lowercase as uim_db.

The customer was trying to create a new database using the lowercase name BUT it was failing since the lowercase name was the same except for the difference in case.

Resolution:

In the end we deleted the CA_UIM database and had the installer create it anew and then there was no conflict with the name and it was then successful.