UIM Installation on MySQL database may fail without an error message. The installer stops at Step 8 of 9, "mysql_ace_create.sql".
===============================================================================
Database Schema Configuration
-----------------------------
[1/9] mysql_nis_base_create.sql ... - OK
[2/9] mysql_slm_create.sql ... - OK
[3/9] mysql_dataengine_create.sql ... - OK
[4/9] mysql_nis_installer_create.sql ... - OK
[5/9] mysql_nis_account_create.sql ... - OK
[6/9] mysql_discovery_server_create.sql ... - OK
[7/9] mysql_nis_server_create.sql ... - OK
[8/9] mysql_ace_create.sql ...
The installer log file (located at /tmp/ca_uim/ on Linux, or C:\tmp\ca_uim\ on windows) will contain the following errors:
2016-11-03 10:59:41,628 ERROR impl.UIMServerDBSchemaController:run:132 [main] - NimException caught
(503) , java.sql.SQLSyntaxErrorException: Invalid default value for 'last_update': Invalid default value for 'last_update'
UIM :Any supported release
New install MySQL 5.6 or above
This is caused by a (now deprecated) setting in MySQL. The setting is called explicit_defaults_for_timestamp.
To resolve the issue, examine the my.cnf or my.ini file (depending on your MySQL platform) and locate the following line:
explicit_defaults_for_timestamp=1
Remove this line or set it to a value of 0, and then restart MySQL and try the installation again.