Monday, 20 April 2015

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.

No comments:

Post a Comment