LDAP Users Import Failed with Custom User Fields

When configuring "Custom User Fields To Be Synchronized", every time you add anything to the section at : System > LDAP > LDAP Directory > Custom User Fields To Be Synchronized, the synchronization process fails.

Checking CUCM traces for DirSync and found this exception:

2014-06-06 15:50:52,830 ERROR [DirSync-DBInterface] common.DSDBInterface (DSDBInterface.java:534) - DSDBInterface.executeSQL Calling rollbackTransaction

2014-06-06 15:50:52,831 ERROR [DirSync-DBInterface] common.DSDBInterface (DSDBInterface.java:535) - DSDBInterface.executeSQL Caught SQLException, Error code=-217

2014-06-06 15:50:52,831 ERROR [DirSync-DBInterface] common.DSDBInterface (DSDBInterface.java:300) - DSDBInterface.updateUserInfo Error code=-217

2014-06-06 15:50:52,831 ERROR [DirSync-DBInterface] common.DSDBInterface (DSDBInterface.java:301) - DSDBInterface.updateUserInfo java.sql.SQLException: Column (customfield1) not found in any table in the query (or SLV is undefined).

MESSAGE Column (customfield1) not found in any table in the query (or SLV is undefined).

Of course customfield1 not found, this is not a column in the DB. The sync should update table 'customuserattributedata' table, column 'value' not column 'customfield1'…

admin:run sql select * from customuserattributedata

pkid tkcustomuserattribute fkenduser value

==== ===================== ========= =====

Table remains empty.

This is a bug fixed in version 9.1.2 and later CSCug93527.