I read an open APAR on IBM Connections today (login required!): LO73245
Description:
TDI’s sync_all_users.sh doesn’t allow us to import departmentNumbers longer than 16 chars, although the database schema supports values up to 24 chars.
And as local solution:
worked around the issue with creating a custom field
I had a very similar problem with validation of LDAP Search filter (which is saved in employee-table too) and searched longer to solve this (I set sync_store_source_url=false), but the real error was like here in validate_dbrepos_fields.properties.
When you open validate_dbrepos_fields.properties (in your tdisol directory) you found following:
deptNumber=16
So here is the validation error and not in the database! You can solve the APAR without using a customField, when you set deptNumber to 24.