Unreferenced entries stay in zAction table

  • 7007642
  • 24-Jan-2011
  • 29-Dec-2014

Environment

Novell ZENworks 11 Configuration Management Database
Novell ZENworks 10 Configuration Management Database

Situation

Administering a Bundle might leave unreferenced entries in the zAction table in the SQL database.

Migration of a ZENworks Desktop Management Application to a ZENworks Configuration Management Bundle does not remove unreferenced entries in the zAction table.

Using zman bundle-remove-actions command to remove an action from a Bundle leaves unreferenced entries in the zAction table.

Resolution

Running the following SQL query removes those unreferenced and no further needed database entries:
delete from zActionSet where ActionSetObject is null

Additional Information

The issue appears whenever actions/actionSets get removed from an existing bundle and updated through web service calls. This occurs e.g., while creating Bundles with the migration wizard or modifying Bundles with zman commands.

Since there is no functional impact as such, this is classified as following the current product design.