Inventory Only Devices are not registering after first scan

  • 7012996
  • 06-Aug-2013
  • 06-Aug-2013

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

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.

Status

Reported to Engineering