Identity Manager JDBC Driver reports Table/view 'usr_phone' is undefined or unsyncable

  • 7011490
  • 12-Dec-2012
  • 12-Dec-2012

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.