UIM Server Installation fails on MySQL environment - installer stops at "mysql_ace_create.sql" with no error message.

book

Article ID: 4485

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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'

 

 

Cause

This is caused by a (now deprecated) setting in MySQL. The setting is called explicit_defaults_for_timestamp.  

 

 

 

 

Environment

UIM 8.47 - New installMySQL 5.6 or above

Resolution

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.

 

 

Additional Information

Further Reading