Environment
Novell ZENworks Configuration Management 11.4 Database
Sybase Database
Sybase Database
Situation
High CPU utilization for database.
Possibly slow or sluggish ZCC response and higher loading times.
Similar or Same entries in loader-messages.log:
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: errorcode is ERR_SUB_EXP] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: Entitlement code is expired] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: Attempting to register with NCC, NCC entitlement validity from response = ERR_SUB_EXP] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.910] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINE: Attempting to register with NCC, Registration URL:https://secure-www.novell.com/center/regsvc/?command=register&lang=en-US&version=1.0] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.910] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINEST: Timeout value which will be used= 120] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:57.156] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINEST: Status Code returned while connecting to NCC = 302] [] [] [] [ZENServer]
Possibly slow or sluggish ZCC response and higher loading times.
Similar or Same entries in loader-messages.log:
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: errorcode is ERR_SUB_EXP] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: Entitlement code is expired] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.849] [19437] [ZENLoader] [166] [] [Loader.SystemUpdateModule] [] [FINE: Attempting to register with NCC, NCC entitlement validity from response = ERR_SUB_EXP] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.910] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINE: Attempting to register with NCC, Registration URL:https://secure-www.novell.com/center/regsvc/?command=register&lang=en-US&version=1.0] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:56.910] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINEST: Timeout value which will be used= 120] [] [] [] [ZENServer]
[TRACE] [02/25/2016 12:52:57.156] [19437] [ZENLoader] [170] [] [Loader.SystemUpdateModule] [] [FINEST: Status Code returned while connecting to NCC = 302] [] [] [] [ZENServer]
Resolution
This is fixed in version 11.4.2 - see KB 7017469 "ZENworks Configuration Management 11.4.2 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7017469
Workaround:1. Run the following query against your database: " Select count(*) from zqueue where type like '%ncc.reregistration.queue.id%' and status = 'N';
2. If a large number of rows are returned this can be confirmation.
3. Take a full backup the database.
4. Run the following query against your database: " Delete * from zqueue where type like '%ncc.reregistration.queue.id%' and status = 'N';
5. If you have an expired System Entitlement code in ZCC, please update it with a current one in ZCC->Configuration->Management Zone Settings->Infrastructure Management->System Update Settings.
2. If a large number of rows are returned this can be confirmation.
3. Take a full backup the database.
4. Run the following query against your database: " Delete * from zqueue where type like '%ncc.reregistration.queue.id%' and status = 'N';
5. If you have an expired System Entitlement code in ZCC, please update it with a current one in ZCC->Configuration->Management Zone Settings->Infrastructure Management->System Update Settings.