Cannot set column due to string length limitation during AD import

Products

• Information Centric Analytics

Issue/Introduction

The Bay Dynamics AD Connector Job fails and logs an error similar to the following:

[1:ERROR] ActiveDirectoryImporter.Import() System.AggregateException: One or more errors occurred. ---> System.ArgumentException: Cannot set column 'distinguishedName'. The value violates the MaxLength limit of this column.

Environment

Release : 6.x

Importer : 1.6.0.x

Cause

Versions of the Active Directory Import utility prior to version 1.6.3.0 set the column 'distinguishedName' in both the ActiveDirectoryDW.dbo.Stg_User and ActiveDirectoryDW.dbo.User tables as datatype nvarchar(256). String lengths on this column that exceed 256 characters cause the job processing failure and error described in the Introduction of this article.

Resolution

To resolve this issue, install version 1.6.3.0 of the AD Import Utility (or later).