When importing a CSV file in to Quest Migrator Pro for Active Directory, you may encounter validation errors:
Click the Download Validation Results link and open the CSV file. All import errors will be at the top of the CSV file. It will look something like:
Migration Wave,Object Name,Matched,Reason
June3_Morning,LT-11111$,NO,Duplicate object found in the database
June3_Morning,LT-22222$,NO,No matching object found in the database
June3_Morning,LT-33333$,YES
Yes
The computer has been successfully validated. No action required.
No matching object found in the database
The computer does not exist in the source domain. It could simply be a typo in the CSV file. It’s also possible the computer has not been synced from the source domain. The entry in CSV file will need to be corrected or removed.
Duplicate object found in the database
Somehow Quest has registered the same computer twice in the SQL database and therefore does not know which entry the CSV import file refers to. There is no way to resolve this from the AD Migrator web GUI, so the duplicate entry will have to be manually deleted from the Quest database. To do this:
1. Log on to the Quest Database Server usingSQL Server Management Studio.
2. Click the “New Query” button.
3. Run the following T-SQL query:
select * from BT_Device
where samaccountname= ‘LT-11111$’
4. The output will be something like this:
5. The DeviceId where “TypeOfTransaction” is “Delete” will need to be removed from the BT_Device database table.
6. Run the following T-SQL query (where “DeviceId” is the ID of the device you want to delete from the previous query):
delete from BT_Device
where DeviceId = ‘7254’
7. If you run the first T-SQL query again, only one database entry for that computer sAMAccountName should be returned.
8. Re-running the migration wave import in the web GUI will result in that computer being successfully imported.
