Environment
NetIQ Identity Manager Driver - JDBC
Oracle MySQL
Situation
Using 1_install_myisam.sql to create the default databases will create the tables using foreign keys which is not supported by MYISAM (as per: http://dev.mysql.com/doc/refman/5.6/en/ansi-diff-foreign-keys.html)
At a later stage, foreign key constraints will be implemented for MyISAM tables as well.
This will cause inserts into child tables to fail:
<status event-id="xxxxxxxxx#20121211172757#1#7:xxxxxx-xxxx-xxxx-xxxx-xxxxxxxx"
level="warning">Table/view 'usr_phone' is undefined or unsyncable.</status>
Resolution
The solution is to use the 1_install_innodb.sql to create the database.
If the database already exist, and contain data then one can export and import the database with the correct information:
1) use mysqldump to export the data:
# mysqldump -u <user> -p <database> > database.sql
2) replace all instances of "ENGINE=MyISAM" with "ENGINE=INNODB" in database.sql
3) drop the existing database and reimport data
(before doing this, verify that your database.sql contain all data as after this step data can get lost)
# mysql -u root -p
Enter password: <enter password>
mysql> drop database <database>;
mysql> create database <database>;
mysql> use <database>;
mysql> source database.sql
mysql> exit
Additional Information
This have been reported to engineering.