Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Situation
Doing a ZAM 7.5 to ZCM 10.x migration fails when migrating workstations with an error about duplicate workstations.
Resolution
Fixed in ZENworks Asset Management 7.5 Interim Release 21 or newer
Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com. The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.
Each interim release is cumulative. If Interim Release 21 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.
Additional Information
The problem that causes this symptom is rare. There are multiple other reasons that the migration could fail due to duplicate workstations, including the reason that there actually are duplicate workstations.
The problem with this issue is that there are multiple rows in the NC_WkstaExtension table for the same workstation. This very rarely happens.
To find out if this is the case, run the following query
select workstationoid from NC_WkstaExtension
group by workstationoid
having count(*) > 1
group by workstationoid
having count(*) > 1