In the ZENworks database on the Microsoft SQL server, if the unique constraint is not created on the serial number column of the zDevice table, duplicate serial numbers might be assigned to the devices that are connected to the Management Zone. Because of the duplicate serial numbers, the database migration from the Microsoft SQL database to the Oracle database might fail.
To resolve the issue, do the following before performing the database migration from the Microsoft SQL database to the Oracle database:
Use the following query to identify the duplicate serial numbers:
SELECT * FROM zDevice WHERE serialnumber IN (SELECT serialnumber FROM zDevice GROUP BY serialnumber HAVING COUNT(1) > 1)
If the duplicate serial numbers are found on the zDevice table, do one of the following:
Remove the device from the Management Zone and register the device again.
Modify the duplicate serial numbers so that each serial number is unique.
NOTE:Novell recommends that you clean up the duplicate serial numbers data before starting the database migration. You can continue to use the existing Management Zone without any loss in functionality.