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.
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.
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