Tech Tip: UIM - UIM installation fails during database creation (Linux with MySQL)

Document created by danst04 Employee on Mar 13, 2017
Version 1Show Document
  • View in full screen mode

Document ID:  TEC1038807
Last Modified Date:  12/23/2016
Show Technical Document Details

Problem:

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.

1 person found this helpful

Attachments

    Outcomes