Environment
Novell ZENworks Configuration Management 11.2
Situation
Inventory from Inventory Only devices are not being stored if the serial number is blank. This will cause it not to be created as a device in ZCC. In the loader-messages.log on the server storing the inventory scan, it shows the following error:
[DEBUG] [3/26/13 11:14:53 AM] [] [InventoryStorer] [58] [] [failed to create device...com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.ConstraintViolationException: could not insert:
[[com.novell.zenworks.datamodel.objects.devices.Device]]] [] []
org.hibernate.exception.ConstraintViolationException: could not insert:
[[com.novell.zenworks.datamodel.objects.devices.Device]]] [] []
The Sybase_Debug.log shows the following error:
04/18 12:17:48. E,50,-196,Index 'uniq_zDevice_SerialNumber' for table
'zDevice' would not be unique.
'zDevice' would not be unique.
Cause
The Serial Number field in the zDevice table must be unique. A blank field is not unique. The first IO device to be scanned will work properly, and create a record in the zDevice table with a blank Serial Number. With the second IO device, and subsequent devices, the Storer will not be able to create the device in zDevice table because the Serial Number field would not be unique.