Within the SQL Management Studio, expand the Active Administrator database tables. Find the dbo.tblInactiveHistory table and expand Columns. Modify the varchar Data Type value for whichever Column Name needs to be adjusted to a larger size or varchar(MAX). In the example below, “DNPath” was modified from varchar(200) to varchar(MAX). Note: You can change all of the varchchar data types to higher values or varchar(MAX), if you are unsure of which one is generating the error: "String or binary data would be truncated." The usual fields that cause the error are DNPath, Name and Location.
If the issue persists after adjusting the previous fields, then these other fields could be adjusted.
- MovedTo, MovedFrom (both set to 200 chars, and this may be exceeded if the DN path to the item exceeds 200 characters)
- DisplayName is possible as well though user / group display names rarely exceed 50 characters
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center