Microsoft Office Suite software such as Visio missing from Inventory Reports

  • 7021004
  • 21-Jun-2017
  • 21-Jun-2017

Environment

Novell ZENworks Configuration Management 11.4 Inventory
Microsoft Office Suite

Situation

  • Running a device inventory report in ZENworks Control Center (ZCC)
  • Microsoft Office Suite components such as Visio are missing from the report
  • Suite components show as installed in Add or Remove Programs
  • Suite components show in the inventory xml file on the device
The following error message is seen in the loader-messages.log when the inventory scan processes:

ERROR:
[ZENLoader] [739] [] [InventoryStorer] [Exception loading component: InternalDataModelException ::com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): ((com.novell.zenworks.datamodel.objects.inventory.Software#54daeb9043200bccb7ee9300d2cb60ea()
    at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:468)
...
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): ((com.novell.zenworks.datamodel.objects.inventory.Software#54daeb9043200bccb7ee9300d2cb60ea()
    at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2368)

Resolution

Please contact Micro Focus Customer Care for a resolution to this issue.

Cause

This issue is caused by orphaned entries in the inventory database tables.