SQL exception while upgrading to 11.2.1

  • 7011353
  • 12-Nov-2012
  • 12-Nov-2012

Environment

Novell ZENworks Configuration Management 11.2 System Update

Situation

PreGlobalAction throws the following exception while upgrading to 11.2.1:

[FINER][Thu Jul 19 21:12:57 CDT 2012][PreGlobalAction]Error executing
inventory_update.sql, will retry (1). Error: [Error executing SQL: CREATE FUNCTION z_Inventory_Pruning
                (IN @TableName NVARCHAR(50),IN @NoOfDays INT,IN
@WorkStationList NVARCHAR(32000))
                returns BIGINT
BEGIN
...
END;]
[FINER][Thu Jul 19 21:12:57 CDT 2012][PreGlobalAction]Stack trace:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Error executing SQL: CREATE FUNCTION z_Inventory_Pruning
                (IN @TableName NVARCHAR(50),IN @NoOfDays INT,IN
@WorkStationList NVARCHAR(32000))
                returns BIGINT
BEGIN
...
END;

Resolution

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