UIM installation failed during a fresh installation (Linux/MySQL)
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.