-
Title
Collector complete with a status of error -
Description
Collector errors out when trying to collect object data from Active Directory. The following error is seen in the collector log:
The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.String or binary data would be truncated.
-
Cause
One or more objects the collector is trying to collect has an attribute value exceeding the nvarchar limit for that column in the collector database -
Resolution
WORKAROUND:
1) Run the SQL statement below against the reporting DB (created during the first run of the Collector):
ALTER TABLE [dbo].[ObjectsComputerAccountsProperties]
ALTER COLUMN [operatingSystemVersion] [nvarchar](40) NULL
2) Then please go ahead and run the collector again.
STATUS:
This Product Defect (TF00610042) has been fixed in the latest available maintenance release, you can get more information from its ReleaseNotes:
Active Roles 7.0.3 - Release Notes
https://support.quest.com/active-roles/7.0.3/technical-documents
-
Change Request
TF00610042 -
Additional Information
TF00610042