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


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

- UIM v8.47 - Linux - MySQL database

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.




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