-
Titre
Inactive Users and Computers task returns error - String or binary data would be truncated. -
Description
When Inactive Users and Computers ran, within the Application Event log Event ID: 5001 Error "String or binary data would be truncated. The statement has been terminated" occurred while logging in active accounts history. The task also returns error - String or binary data would be truncated. -
Cause
This error could occur if any of the column lengths within the dbo.tblInactiveHistory table are shorter than the actual path size. -
Résolution
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
