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;
[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