Purge_history script not clearing all old inventory information

  • 7011317
  • 06-Nov-2012
  • 15-Jan-2014

Environment

Novell ZENworks Configuration Management 11.2 Inventory
Novell ZENworks Asset Management 11.2

Situation

The ZCM SQL database is running on Sybase.

The SQL database has been growing on inventory information and it is desired to remove inventory and software usage tracking history.

The ZCM SQL database schema includes a function called zcm_purgehistory to remove historic inventory information as outlined in ZCM online documentation under Cleaning Up Historical Data from the Inventory (scroll down to '2.4.3 Cleaning Up Historical Data from the Inventory').

The script does not clean up all historic inventory data up to the configured daystokeep value.

Resolution

This is fixed in version 11.2.3a - see KB 7011295 "ZENworks Configuration Management 11.2.3a - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7011295

Cause

It was possible that items in the NC_COMPONENT or NC_PRODUCT failed to delete because they were still referenced by child tables.

Additional Information

Novell Engineering revised the way inventory history is cleaned up. Now it is ensured the referencing entries in child tables get removed first before entries in NC_COMPONENT and NC_PRODUCT tables get deleted.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.