UIM install failing with a syntax error updating the mysql database

Document ID : KB000098447
Last Modified Date : 22/06/2018
Show Technical Document Details
Issue:
The install is failing with a syntax error updating the mysql database

From install screen it fails here:
[2/10] mysql_slm_create.sql ... - OK 
[3/10] mysql_dataengine_create.sql ...You have new mail in /var/spool/mail/root 

From install log he failure point is with:
Query is: 
create procedure spn_de_DataMaint_Configure( 

it has a problem wth 
if ( spn_de_GetVersionInt() >= 50607 ) then 
set ' 

and 
set pState := 'basic'; 
end if; 

Yet similar statements work just fine,
Environment:
Linux
Resolution:
the MySQL my.cnf was incomplete. 
started with a default copy and modified as per documentation.
Additional Information:
There may be additional clues/error messages in the installer log which is kept in /tmp/ia/ on Linux (or C:\tmp\ia on Windows).

Install log file name: uimserver_ia_install.log