String length mismatch between ActiveDirectoryDW OU distinguishedName and RiskFabric OU distinguishedName

Products

• Information Centric Analytics

Issue/Introduction

Staging during RiskFabric Processing fails and returns the following error:

ErrorDesc=Error Msg: String or binary data would be truncated in table 'RiskFabric.dbo.Stg_AD_OrganizationalUnit', column 'distinguishedName'. Truncated value: '<string>'.Line  Number: 1

Environment

Release : 6.6

Component : Active Directory Connector Utility

Cause

The source column distinguishedName in ActiveDirectoryDW.dbo.OrganizationalUnit is of data type nvarchar(512) while the destination column distinguishedName in RiskFabric.dbo.Stg_AD_OrganizationalUnit is of data type nvarchar(256).

The stored procedure spUpdateStg_AD converts user distinguishedName values to nvarchar(256) during staging but inserts OU distinguishedName values as-is.

Resolution

This will be fixed in the next release of ICA.

Contact Broadcom Support for assistance with resolving this error.