TDI import troubleshooting
April 18, 2011 3 Comments
TDI is on my list of products I need to know more about. At Lotusphere this year I went to a ‘Show and Tell’ presentation on TDI – ‘Assemble ‘n Go: Integrate Data and Directories with Tivoli Directory Integrator’ which really showed the power of the product. My experience so far has been limited to its interaction with Lotus Connections (synchronising Profiles with various directories)
One of the questions I’ve been asked a couple of times recently (hence the blog post) is where to start troubleshooting when you get errors or failures, like the one below, during the TDI sync process for Lotus Connections:
CLFRN0037I: After synchronisation, added/modified records is 0, deleted records is 0, duplicate records is 4196, failure records is 11
The place I start looking to find the cause of the problem is in the ibmdi.log file (/opt/IBM/TDI/V7.0/tdisol/TDI/logs/ibmdi.log) which usually guides me successfully to the root cause.
In this particular instance I found the errors (shown below) in the ibmdi.log which identified the users that had not been imported and identified the cause as being an invalid country code. Once the country code was corrected the import ran successfully.
2011-04-17 14:49:47,307 WARN [AssemblyLine.AssemblyLines/sync_all_dns_process_add.18] – CLFRN0209W: WARNING: Validation failed for field countryCode. Value is U.K..
2011-04-17 14:49:47,310 WARN [AssemblyLine.AssemblyLines/sync_all_dns_process_add.18] – CLFRN1183W: WARNING: Validation failed for entry CN=Test User,o=corp




